Re: [mv] Interface to SQL

[kswisher@iolinc.net (Swisher, Karl)]

On Mon, 25 Oct 1999, you wrote:
> ******    message to minivend-users from "Tamás Kġhegyi" <tkohegyi@gw.cdk.bme.hu>     ******
Yes, Thank You, Thank You, Thank  You.
It worked.   
     I guess there is a difference between interfacing Postgres vs  MySQL.   Is
it safe to say you drop the host and port part off the DSN statement ?    If
this could be addressed with a couple of sentences in the MiniVend Docs it
could quickly accelerate the learning curve for newbies who pick Postgres as
their database.

Thanks
Karl

> Hi Karl,
> 
> Use this:
> Database products        products.asc         SQL
> Database products        DSN           dbi:Pg:dbname=sample
> 
> I hope this works.
> You also have to create 'sample' database in the postrgesql.
> 
> Regards,
> Tamas
> 
> 
> 
> ----- Original Message -----
> From: Swisher, Karl <kswisher@iolinc.net>
> To: <minivend-users@minivend.com>
> Sent: Thursday, October 21, 1999 22:39
> Subject: [mv] Interface to SQL
> 
> 
> > ******    message to minivend-users from kswisher@iolinc.net (Swisher,
> Karl)     ******
> >
> > Hello,
> > Sorry to brother everyone with this again.  I have just gotten back to
> > trying to get the demo to work with Postgres.  I have two cats.  One named
> > "simple" which is an exact clone of the asc "sample" demo base with
> MiniVend.
> > The second is "sample" which is the SQL one.
> >
> > I have remade, tested and installed DBD and DBI.  This time I
> > deleted the source on DBI after the installation.  I didn't do that the
> first
> > time.  I think everythings there.  I have a database in Postgres named
> > "sample".  This database has a table named "products".  This table is
> populated
> > with the data from the products.asc file in the demo.  I believe I have
> > conformed to the SQL examples in the MiniVend Docs.
> >
> > While I think I'm closer but it is still not working.  I know there will
> > be code in other scripts that must be changed for Postgress to be
> accessed.
> > However I don't believe that would be needed at this point just to connect
> to
> > it in the configure script. Here are some code examples:
> >
> > -----------------------------------
> > Database products        products.asc         SQL
> > Database products        DSN           dbi:Pg:sample:localhost:5432
> >
> > OR
> >
> > Database products products.asc SQL
> > Database products DSN DBI:Pg:sample:localhost:5432
> >
> > OR
> >
> > Database products products.asc dbi:Pg:sample:localhost:5432
> >
> > OR
> >
> > Database products products.asc DBI:Pg:sample:localhost:5432
> >
> > All returns this
> >
> > MiniVend V3.14
> > Configuring catalog sample...sample config error: DBI connect failed:
> ERROR: PQconnectdb()
> >  - Missing '=' after 'sample:localhost:5432' in conninfo
> >
> > sample: error in configuration. Skipping.
> > sample: config error. Skipping.
> > Configuring catalog simple...done.
> > MiniVend server started in INET and UNIX mode(s) (process id 2900)
> > ------------------------------------
> >
> > So I try an equals sign and get this
> >
> > Database products products.asc SQL
> > Database products DSN             DBI:Pg:dbname=sample:localhost:5432
> >
> > OR
> >
> > Database products products.asc SQL
> > Database products DSN             dbi:Pg:dbname=sample:localhost:5432
> >
> > OR
> >
> > Database products products.asc      dbi:Pg:dbname=sample:localhost:5432
> >
> > All return this:
> >
> > MiniVend V3.14
> > Configuring catalog sample...bash$
> > -------------------------------------
> >
> > My setup is:
> > Postgres 6.5.1
> > DBI 1.13
> > DBD 0.92
> > MinVend 3.14
> > Perl  5.004..05
> > RH 5.2
> > kernel 2.0.36
> >
> > Any suggestions will be appreciated.
> > Thanks
> > Karl
> > -
> > 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.
> AArchive of past messages: http://www.minivend.com/minivend/minivend-list