--------------F6E098416FBB6148CED113C8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 --------------F6E098416FBB6148CED113C8 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> 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-usersKim Christensen wrote:
Now i have several times tried to get Interchange running with--------------F6E098416FBB6148CED113C8--
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