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

[Mark Stosberg <mark@summersault.com>]

******    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