3 messages in com.mysql.lists.perlhelp needed
FromSent OnAttachments
Slawomir Orlowski11 Mar 2003 13:57 
Shivan11 Mar 2003 14:53 
Jochen Wiedmann11 Mar 2003 23:12 
Subject:help needed
From:Slawomir Orlowski (orlo@hotpop.com)
Date:03/11/2003 01:57:12 PM
List:com.mysql.lists.perl

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.