help needed

am 11.03.2003 22:57:34 von Slawomir Orlowski

Hello,
I have RH 6.1.
I have mysql 3.22.25 version binary installation
databases are in /var/lib/mysql
binaries in /usr/bin/mysql etc
/var/lib/mysql/mysql.pid
/var/lib/mysql/=mysql.sock
and rpm packages:
perl-DBI-1.13-1,
perl-DBD-mysql-mysql-1.22.10-1
perl-5-5.0050
and binary installation of php 4.04pl
and it was working perfectly (I have web page written in php and perl),

Yesterday I have installed from source (to old RH to get binary
installation) mysql 3.23.55.
It compiled perfectly and was installed in
/usr/local/mysql
databases in
/usr/local/mysql/var

I have stoped old mysql server and run new one.

I could connect with new /usr/local/mysql/bin/mysql client (old one was not
working) and select data from moved databases.
problem is that web pages are not working any more,
after running by hand some script (which use to work) I'm getting:
"
Date::Parse is not available but requested by Class::Date
DBI->connect(database=class;host=localhost) failed: Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at ./class
line 27
Can't call method "prepare" on an undefined value at ./class line 156.
"
it looks to me that that it somehow is trying to connect to old not working
mysql database.
because now mysql.sock is in /tmp/=mysql.sock
I have found somewhere that pearl script I can add directive:
mysql_read_default_file
$dbh = DBI->connect("DBI:mysql:$database"
.. ";mysql_read_default_file=$ENV{HOME}/.my.cnf",
$user, $password);
I did and it worked, but I do not know what to do in php scripts (I do not
know php I'm admin) and it is daunting job to change manually all perl
scripts.

So any advice would be appreciated.

Best regards
Slawomir Orlowski

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2078@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

help needed

am 11.03.2003 23:53:59 von Shivan

HI,
anyone of you using weblogic sever connecting to MySQL? what are your
versions?
is it working correctly?
please let me know.thanks!

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2079@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

help needed

am 11.03.2003 23:53:59 von Shivan

Re: help needed

am 12.03.2003 08:13:12 von Jochen Wiedmann

Zitiere Slawomir Orlowski :

> MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at

Most probably you are using some older client libraries.
The path is hard coded there.

See "perldoc DBD::mysql" for a description of the flags that
you may include in the DSN. One of them allows to select a
socket.

Jochen

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2080@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: help needed

am 12.03.2003 08:13:12 von Jochen Wiedmann