Akopia Akopia Services
[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

RE: [ic] PostgreSQL - No tables created

You need to setup the catalog.cfg file in order to use the Perl DBI database calls to the PostgreSQL server.  I had the same problem with MySQL or any other database.  Uncomment out the DSN ODBC information out in the catalog.cfg file for the database you are going to use.  You should not need to change anything else.
 
Restart interchange and the tables will be created with the Demo information.  It may be a little more involved then what I've stated.  But that will get you started.  By default Interchange uses the Interchage Database.  Even if you configured it to use another Database like MySQL or PostgreSQL.  Hence the errors you are getting.  Look in the error.log in your catalog directory and see what errors you get.  If interchange starts correctly using the database.  You will see in the log file it created all of the tables and data. 
 
Hope this helps.
 
Mark
-----Original Message-----
From: interchange-users-admin@minivend.com [mailto:interchange-users-admin@minivend.com]On Behalf Of Marcel Montes
Sent: Thursday, November 16, 2000 8:13 AM
To: interchange-users@minivend.com
Subject: Re: [ic] PostgreSQL - No tables created

This was my experience. This gave me 3 different sympthoms (spell??):

1) When restarting interchange:
"DBI connect failed: Can't connect to local MySQL server through socket
    '/var/lib/mysql/mysql.sock' (111)"

2) Database created but empty (nor data nor even defined tables)
3) As the catalog wasn't initialized, when accessing through the browser:
"Undefined catalog: /cgi-bin/testingthis"
(testingthis is my construct demo test with sql).

I don't know how PostgreSQL works, I've never even installed it but hope it helps.

------------------------------------------------------------
 Marcel Montes - Programmer (not a good one, though)
 marcel(at)multimake(dot)com

 "If our brain were so simple that we could understand it,
  we would be so stupid that we couldn't do so"
------------------------------------------------------------
  

     From: Marcel Montes
  Subject: Re: [ic] MySQL startup error / connect failed
       To: interchange-users@minivend.com




Another posibility: 

I had the same problem -as far as you describe-. Try to connect to database with "mysql -hHOST_IP" and
with "mysql -hlocalhost". 
if -hHOST_IP works and -hlocalhost doesn't it surely is the same. 

MySQL works both with TCP/IP and UNIX sockets. While connecting with -hHOST_IP you are connecting
through TCP/IP but with -hlocalhost, or DBI, you're trying to connect through UNIX sockets (someone please
correct me, I not very wise on this). 

The mysql.sock file performs some kind of esencial function to the client to know if there's a server, if it exist,
then connects (a kinda PID thing if I can say). 
Also, there's a mysql compilation directive when running configure (./configure
--with-unix-socket-path=/var/lib/mysql/mysql.sock). I'm not quite sure about this as I've downloaded the
binary distribution but maybe that's why mysql pointed to /tmp/mysql.sock, thus when DBI looked for
mysql.sock at /var/lib/mysql couldn't find it. I don't know how to change this setting on mysql nor DBI, so I
kinda patched my own solution, that I don't know if it is "politically" correct nor safe, but -at least by now-
functional... 

My solution was to make a soft link to mysql.sock (ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock). I really
doubted that that would work, but it did... 
I also learned this time that linux' soft links are really beyond from the
always-comparition-start-point-for-windows-users .lnk files. The link made with ln returns a false when
checking file of the link and the linked file doesn't exist (while if you ls the directory... there's the link!!!). really
neat. 

(let me learn some english too: is the last posesive apostrophe well placed? how's the possesive of "linux"?) 

hope this -finally- helped. 

Marcel Montes wrote: 

  Hmmm.... 
  run mysql with: 
  /usr/local/mysql/bin/safe_mysqld --skip-grant-tables --user=mysql & 
  (if the daemon user is mysql... if not change for whatever it is). 

  Try again and if it works then is a mysql permissions problem. 

  Heinz Wittenbecher wrote: 

  > RH7 / latest MySQL rpm from mysql site. Perl 5.6.0 
  > 
  >  DBI connect failed: Can't connect to local MySQL server through socket 
  > '/var/lib/mysql/mysql.sock' (111) 
  > 
  > Have redone CPAN DBI and DBD installs. perl reports that both are up to 
  > date. I can access the data via mysql and webmin/sql. 
  > 
  > Any ideas? 
  > 
  > What's worse is that on another machine I have it all working. Even tried a 
  > tar from the working one and get same error. 
  > Permissions on /var/lib/mysql/mysql.sock same on both machines. 
  > 
  > Any pointers greatly appreciated. 
  > 
  > Heinz 
  > 
  > _______________________________________________ 
  > Interchange-users mailing list 
  > Interchange-users@www.minivend.com 
  > http://www.minivend.com/mailman/listinfo/interchange-users 

  _______________________________________________ 
  Interchange-users mailing list 
  Interchange-users@www.minivend.com 
  http://www.minivend.com/mailman/listinfo/interchange-users

Kim Christensen wrote:

Now i have several times tried to get Interchange running with
PostgreSQL database. I am using SuSE 7.0 and PostgreSQL 7.02.

Everything during installation went fine with no errors at all. CPAN
updates and install the missing modules. I used the construct catalog
with makecat.

I started the Interchange server with the -r option and it comes up without
any errors. It is using the PG:DBI as expected.

The problems is that there are NO tables created so naturally it does not
work. I have seen on the user list that others have experienced the same
kind of problem when using MySQL as database engine.

Any ideas and responses are much appreciated
Regards
Kim C.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users

Search for: Match: Format: Sort by: