Re: mySQL create tables

["Phil Welch" <PhilmoreW@worldnet.att.net>]

Russ,

 

Maybe; in which case you should probably ask your isp what the port should be.  If you can't find out quickly, you might even take a stab in the dark and try removing the port:

 

"DSN
A specification of the DBI driver and its data source. To use the DBD::mSQL driver for DBI, you would typically use:

 

    dbi:mSQL:minivend:othermachine.my.com:1112

 

where mSQL selects the driver (case IS important), minivend selects the database, othermachine.my.com selects the host, and 1112 is the port. On many systems, dbi:mSQL:minivend will work just fine. (The minivend database must already exist, of course.)

 

This is the same as the DBI_DSN environment variable -- if you don't set the DSN parameter, then the value of DBI_DSN will be used to try and find the proper database to connect to. "

 

Just out of curiousity; is your mySQL data base named dbname? 

 

Regards,

 

Phil Welch

 

----- Original Message -----

From: Russ <russ@khouse.org>

To: <minivend-users@minivend.com>

Sent: Friday, July 23, 1999 7:31 PM

Subject: RE: mySQL create tables

> ******    message to 
minivend-users from "Russ" <russ@khouse.org>     
******
> 
> Hello,
> 
> I tried this:
> 
Database            
products products.asc SQL
> 
Database            
products DSN dbi:mysql:dbname:localhost:3306
> 
Database            
products USER       username
> 
Database            
products PASS       password
> 
> And 
got the same error back...
> Is it possible that this error is coming up 
due to a wrong port number
> (3306)?
> 
> Thanks,
> 
> Russ
> 
> -----Original Message-----
> From: owner-minivend-users@minivend.com
> 
[mailto:owner-minivend-users@minivend.com]On 
Behalf Of Phil Welch
> Sent: Friday, July 23, 1999 3:37 PM
> To: minivend-users@minivend.com
> 
Subject: Re: mySQL create tables
> 
> 
> 
******    message to minivend-users from "Phil Welch"
> 
<PhilmoreW@worldnet.att.net>     
******
> 
> Russ,
> 
> Have you tried something like 
this:
> 
> "The configuration of the DBI database is done by setting 
attributes in
> additional Database directives after the initial defining 
line as described
> above. For example, the following defines the database 
arbitrary as a DBI
> database, sets the data source (DSN) to an 
appropriate value for an mSQL
> database named minivend on port 1114 of 
the local machine:
> 
> 
>     Database 
arbitrary arbitrary.asc SQL
>     Database arbitrary 
DSN           
dbi:mSQL:minivend:localhost:1114"
> 
> tailored to mySQL?
> 
> Regards,
> 
> Phil Welch
> 
> ----- Original 
Message -----
> From: Russ <russ@khouse.org>
> To: Minivend-Users 
<minivend-users@minivend.com>
> 
Sent: Friday, July 23, 1999 1:27 AM
> Subject: mySQL create tables
> 
> 
> > ******    message to minivend-users from 
"Russ" <russ@khouse.org>
> 
******
> >
> > Hello,
> >
> > On Solaris 2.5 
w/ mySQL 3.22, and MV 3.14, and PERL
> > 5.005_03...
> > My 
catalog.cfg is this:
> >
> > 
Database            
products products.asc
> > dbi:mysql:dbname:localhost:3306
> > 
Database            
products USER       username
> > 
Database            
products PASS       password
> >
> 
> And the error I get is this:
> >
> > simple config error: 
Undefined subroutine
> > &Vend::Table::DBI::create called 
at
> > /VENDROOT/mvend/lib/Vend/Table/Import.pm line 160, 
<IN>
> > chunk 1.
> >
> > simple: error in 
configuration. Skipping.
> > simple: config error. Skipping.
> 
>
> > DBD and DBI::mysql are installed, and I've messed with 
line
> > 160 of Import.pm, and I've looked around in DBI.pm, at 
the
> > 'create' subroutine.  So far, I can't find any 
problem!
> > Other databases that ues InMemory instead of DBI modules 
to
> > create the data don't have any problems.
> >
> 
> Any ideas folks?
> >
> > Russ Mann
> > 
--------------------------
> > Earn Money to surf the Internet Click 
Here!
> > http://www.alladvantage.com/refhome.asp?refid=AWW-495
> 
>
> > -
> > 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
> 
> -
> 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