Re: [mv] Minivend & mysql on a remote box

[Adam Goodman <adam@metalogica.com>]

******    message to minivend-users from Adam Goodman <adam@metalogica.com>     ******

Thanks you all...

It's a lites strange, I deleted the *.sql files and removed the tables from 
the DB, restarted minivend and it worked.

I wonder what it was, Adam.



At 04:07 PM 3/10/00 -0500, you wrote:
>******    message to minivend-users from Mark Stosberg 
><mark@summersault.com>     ******
>
>
>Adam,
>
>  It looks like you are on the right track. You need to complete your
>database definitions for your mysql database. Look in
>''dist/simple/mysql/', in the MV 4.x distributions (altough this
>functionality is not new to MV4). Then you need to have a DSN entry per
>table.
>   I've been using Minivend with Postgres on a remote machine since day
>1, and this works fine for me. Here's an example entry from my
>(customized) products table in catalog.cfg.
>   The DSN format for mysql may look different.
>   I think MV4 has set up wizard that will allow you get going with the
>simple demo on remote box very easily. I haven't actually tried that,
>though. :)
>
>  Good luck,
>
>   -mark
>
>Database        products 
>products.tab  dbi:Pg:dbname=music;host=foo.server.com;port=5432
>Database    products USER       joebob
>Database        products NUMERIC            id,seller_id,cat_id,price
>Database        products KEY                    id
>
>Database        products COLUMN_DEF     id=serial
>Database        products COLUMN_DEF     seller_id=int4
>Database        products COLUMN_DEF     cat_id=int4
>Database        products COLUMN_DEF     description=text
>Database        products COLUMN_DEF     price=float
>Database        products COLUMN_DEF     condition=char(4)
>Database        products COLUMN_DEF     sold=bool not null default 'f'
>
>
>
>Adam Goodman wrote:
> >
> > ******    message to minivend-users from Adam Goodman 
> <adam@metalogica.com>     ******
> >
> > useing :
> > --------
> > MiniVend 4.0.1
> > RedHat 6.1
> >
> > I am trying to setup a catalog and use a mysql server running on 
> another box.
> > Any Ideas?
> >
> > Thanks, Adam
> >
> > The line in the catalog.cfg looks like:
> > 
> ---------------------------------------DSN=dbi:mysql:shop1:mysql_server.mydo
> > main.com:3306
> >
> > The error I am getting:
> > -----------------------
> > shop1 config error: Can't call method "close_table" on an undefined value
> > at /usr/local/minivend/lib/Vend/Data.pm line 409
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to 
> Majordomo@minivend.com.
> > Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
>--
>   <<-------------------------------------------------------------->>
>personal website                <    Summersault Website Design
>    http://mark.stosberg.com/     >       http://www.summersault.com/
>-
>To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list