Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker wrote: It really seems like I need to delete current version of mysql and wipe out all directories everywhere related to it ... the ones gnorpm says it can't delete since they are not empty. Didn't do that the last time. Then start fresh and see where it goes from there. What are your thoughts? Is there anything else I might need to do to get back to a pre-mysql machine that I am missing? Just try rpm -e `rpm -qa | grep mysql` (make sure to use back ticks (usually under the Esc key) to uninstall all MySQL packages. Then clear out /var/lib/mysql and remove /etc/rc.d/init.d/mysql* (just in case some are left). Then find some packages which have worked before and install those. Good luck. -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Thanks Steve, Here is what happens when I try rpm -e `rpm -qa | grep mysql` [fran@flp fran]$ su Password: [root@flp fran]# rpm -e `rpm -qa | grep mysql` rpm: no packages given for uninstall [root@flp fran]# Missing something? Thanks, Bambi Steve Fox wrote: Fran Parker wrote: It really seems like I need to delete current version of mysql and wipe out all directories everywhere related to it ... the ones gnorpm says it can't delete since they are not empty. Didn't do that the last time. Then start fresh and see where it goes from there. What are your thoughts? Is there anything else I might need to do to get back to a pre-mysql machine that I am missing? Just try rpm -e `rpm -qa | grep mysql` (make sure to use back ticks (usually under the Esc key) to uninstall all MySQL packages. Then clear out /var/lib/mysql and remove /etc/rc.d/init.d/mysql* (just in case some are left). Then find some packages which have worked before and install those. Good luck. -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker wrote: Thanks Steve, Here is what happens when I try rpm -e `rpm -qa | grep mysql` [fran@flp fran]$ su Password: [root@flp fran]# rpm -e `rpm -qa | grep mysql` rpm: no packages given for uninstall [root@flp fran]# Missing something? Yes. Do this instead:- rpm -e `rpm -qa | grep -i mysql` -- - Antony Suter ([EMAIL PROTECTED]) "Examiner" openpgp:71ADFC87 - "And how do you store the nuclear equivalent of the universal solvent?"
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Thanks Antony...that was what was missing... now only references to mysql are in: /tmp/tksysv-backup/rc.d/init.d/mysql /var/lib/mysql* Also still have reference in /usr/lib/per5/site_perl/5.005/i386-linux under the /auto/DBD and /DBD and /Bundle/DBD...but they appear to be related to the perl-mysql stuff. Should I uninstall rpms for the perl-mysql ? or can that stay and link to a new mysql when installed? Should I remove the /tmp/tksysv-backup/rc.d/init.d/mysql too, as well as the /var/lib/mysql* that Steve mentioned? Thanks, Bambi Antony Suter wrote: Fran Parker wrote: Thanks Steve, Here is what happens when I try rpm -e `rpm -qa | grep mysql` [fran@flp fran]$ su Password: [root@flp fran]# rpm -e `rpm -qa | grep mysql` rpm: no packages given for uninstall [root@flp fran]# Missing something? Yes. Do this instead:- rpm -e `rpm -qa | grep -i mysql` -- - Antony Suter ([EMAIL PROTECTED]) "Examiner" openpgp:71ADFC87 - "And how do you store the nuclear equivalent of the universal solvent?"
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Thanks so much! Got it all...checked for any Mysql* stuff with find and it is all gone, except where it is under the perl-mysql directories. I now have a mysql-less machine to start again...later :) Thanks again, Bambi Steve Fox wrote: Fran Parker wrote: Thanks Antony...that was what was missing... now only references to mysql are in: /tmp/tksysv-backup/rc.d/init.d/mysql /var/lib/mysql* Delete the stuff in /var/lib/mysql. That's where your databases are kept. Also still have reference in /usr/lib/per5/site_perl/5.005/i386-linux under the /auto/DBD and /DBD and /Bundle/DBD...but they appear to be related to the perl-mysql stuff. Should I uninstall rpms for the perl-mysql ? or can that stay and link to a new mysql when installed? Should be able to leave these. Should I remove the /tmp/tksysv-backup/rc.d/init.d/mysql too, as well as the /var/lib/mysql* that Steve mentioned? That just looks like its from a backup program you use. Shouldn't have to worry about itl Antony Suter wrote: Yes. Do this instead:- rpm -e `rpm -qa | grep -i mysql` Oops, forgot the packages had capital letters in them ;0) -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Hi Steve, that is what I figured. The mysql.log stopped recording after I uninstalled a newer cooker version of mysql in favor of the stable one due to an incompatibility with the DBD support needed for pronto mail. There are no entries in the mysql.log after 8/27/2000 when I was using mysql version MySQL-3.23.22 not the current version 22.32. By the way...having two with numbers so close is very difficult to keep track of. I had used gnorpm to uninstall the newer cooker version and then installed the stable MySQL-3.22.32-5mdk rpm in hopes of getting to a version that was compatible with the DBD that Pronto mail uses. I have been at this too long...I have pretty much decided to stay with Netscrappy mail for now...seems dumb to have to have a separate database program installed to run a mail program anyway so it will be stable and quick. I tried Pronto mail with the .CSV database format ...but it is buggy as hell, and slow as molassas if you have more than a hundred or two mail messages you are maintaining. Would still like to get mysql working..but not for this mail program anymore...it is because there are other databases I am using in windows that I would like to be able to use in linux. It really seems like I need to delete current version of mysql and wipe out all directories everywhere related to it ... the ones gnorpm says it can't delete since they are not empty. Didn't do that the last time. Then start fresh and see where it goes from there. What are your thoughts? Is there anything else I might need to do to get back to a pre-mysql machine that I am missing? Thanks for any input. Bambi Steve Fox wrote: Fran Parker wrote: Hi Jean-Michel, I think I forgot one of the steps you suggested..here's output with the "chkconfig--add mysql" before running "/etc/rc.d/init.d/mysql start" [fran@flp fran]$ su Password: [root@flp fran]# chkconfig --add mysql [root@flp fran]# /etc/rc.d/init.d/mysql start [root@flp fran]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended That means it couldn't start up for some reason. Check /var/lib/mysql/mysqld.log for any errors. -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Can you make heads or tails out of that? :) Well, it lost the carriage returns in sending, but I didn't see mysql in there at all. Try '/etc/rc.d/init/mysql start' and then try your script again and see if that helps. If it does, you'll need to add the mysql script to your current runlevel's init. -- Ben Reed a.k.a. Ranger Rick ([EMAIL PROTECTED]) http://defiance.dyndns.org/ / http://radio.scenespot.org/ Now playing on Defiance Radio: I Don't Know You People by Orbital
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Hi Benjamin, I am really at a loss here, here's the output: [fran@flp fran]$ su Password: [root@flp fran]# /etc/rc.d/init/mysql start bash: /etc/rc.d/init/mysql: No such file or directory [root@flp fran]# But when I boot .. mysql daemon is loaded. Bambi Benjamin Reed wrote: Can you make heads or tails out of that? :) Well, it lost the carriage returns in sending, but I didn't see mysql in there at all. Try '/etc/rc.d/init/mysql start' and then try your script again and see if that helps. If it does, you'll need to add the mysql script to your current runlevel's init. -- Ben Reed a.k.a. Ranger Rick ([EMAIL PROTECTED]) http://defiance.dyndns.org/ / http://radio.scenespot.org/ Now playing on Defiance Radio: I Don't Know You People by Orbital
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Hi Benjamin, I am really at a loss here, here's the output: [fran@flp fran]$ su Password: [root@flp fran]# /etc/rc.d/init/mysql start bash: /etc/rc.d/init/mysql: No such file or directory [root@flp fran]# But when I boot .. mysql daemon is loaded. Hrm, I don't have a cooker machine handy, so I can't be sure if things changed, but you should have an /etc/rc.d/init/mysql file if it's installed. Try doing 'rpm -qil MySQL' and see if it's listed in the files that are supposed to be installed. If so, then perhapse your mysql install is corrupted. -- Ben Reed a.k.a. Ranger Rick ([EMAIL PROTECTED]) http://defiance.dyndns.org/ / http://radio.scenespot.org/ Now playing on Defiance Radio: Never Enough by The Cure
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Hi Benjamin, Well I did that and ps -A ... results follow (will try to align better with carriage returns:) [fran@flp fran]$ su Password: [root@flp fran]# ps -A PID TTY TIME CMD 1 ?00:00:05 init 2 ?00:00:00 kflushd 3 ?00:00:00 kupdate 4 ?00:00:00 kpiod 5 ?00:00:02 kswapd 6 ?00:00:00 mdrecoveryd 351 ?00:00:00 syslogd 361 ?00:00:00 klogd 376 ?00:00:00 atd 391 ?00:00:00 crond 406 ?00:00:00 inetd 421 ?00:00:00 lpd 500 ?00:00:00 master 507 ?00:00:00 pickup 508 ?00:00:00 qmgr 522 ?00:00:00 gpm 571 ?00:00:01 xfs 588 ?00:00:00 smbd 598 ?00:00:00 nmbd 628 tty1 00:00:00 login 629 tty2 00:00:00 mingetty 630 tty3 00:00:00 mingetty 631 tty4 00:00:00 mingetty 632 tty5 00:00:00 mingetty 633 tty6 00:00:00 mingetty 634 ?00:00:00 kdm 641 ?00:00:41 X 981 tty1 00:00:00 bash 1347 ?00:00:00 kdm 1360 ?00:00:00 kwm 1405 ?00:00:00 kikbd 1413 ?00:00:00 kaudioserver 1414 ?00:00:00 kwmsound 1415 ?00:00:01 kpanel 1416 ?00:00:02 kfm 1417 ?00:00:00 krootwm 1418 ?00:00:00 kbgndwm 1421 ?00:00:00 maudio 1426 ?00:00:00 kbiff 1442 ?00:00:00 kcmlaptop 1443 ?00:00:00 kppp 1444 ?00:00:00 kppp 1445 ttyS100:00:00 pppd 1464 ?00:00:02 netscape 1465 ?00:00:00 netscape 1467 ?00:00:00 konsole 1468 pts/000:00:00 bash 1481 pts/000:00:00 su 1482 pts/000:00:00 bash 1497 pts/000:00:00 ps [root@flp fran]# rpm -qil MySQL Name: MySQLRelocations: (not relocateable) Version : 3.22.32 Vendor: MandrakeSoft Release : 5mdk Build Date: Tue 18 Apr 2000 06:33:17 AM EDT Install date: Tue 29 Aug 2000 11:35:56 PM EDT Build Host: kenobi.mandrakeso ft.com Group : Databases Source RPM: MySQL-3.22.32-5mdk.src.r pm Size: 6613938 License: MySQL FREE PUBLIC LICENS E (See the file PUBLIC) Packager: Jean-Michel Dault [EMAIL PROTECTED] URL : http://www.mysql.com/ Summary : MySQL: a very fast and reliable SQL database engine Description : MySQL is a true multi-user, multi-threaded SQL (Structured Query Language) database server. SQL is the most popular database language in the world. MySQL is a client/server implementation that consists of a server daemon mysqld and many different client programs/libraries. The main goals of MySQL are speed, robustness and easy to use. MySQL was originally developed because we at Tcx needed a SQL server that could handle very big databases with magnitude higher speed than what any database vendor could offer to us. We have now been using MySQL since 1996 in a environment with more than 40 databases, 10,000 tables, of which more than 500 have more than 7 million rows. This is about 50G of mission critical data. The base upon which MySQL is built is a set of routines that have been used in a highly demanding production environment for many years. While MySQL is still in development, it already offers a rich and highly useful function set. See the documentation for more information" /etc/logrotate.d /etc/logrotate.d/mysql /etc/rc.d /etc/rc.d/init.d /etc/rc.d/init.d/mysql /usr/bin/isamchk /usr/bin/isamlog /usr/bin/mysql_fix_privilege_tables /usr/bin/mysql_install_db /usr/bin/mysql_setpermission /usr/bin/mysql_zap /usr/bin/mysqlbug /usr/bin/perror /usr/bin/replace /usr/bin/resolveip /usr/bin/safe_mysqld /usr/doc/MySQL-3.22.32 /usr/doc/MySQL-3.22.32/PUBLIC /usr/doc/MySQL-3.22.32/README /usr/doc/MySQL-3.22.32/manual.html /usr/doc/MySQL-3.22.32/manual.ps /usr/doc/MySQL-3.22.32/manual.texi /usr/doc/MySQL-3.22.32/manual.txt /usr/doc/MySQL-3.22.32/manual_toc.html /usr/info/mysql.info.bz2 /usr/sbin/mysqld /usr/share/mysql /usr/share/mysql/binary-configure /usr/share/mysql/czech /usr/share/mysql/czech/errmsg.sys /usr/share/mysql/czech/errmsg.txt /usr/share/mysql/danish /usr/share/mysql/danish/errmsg.sys /usr/share/mysql/danish/errmsg.txt /usr/share/mysql/dutch /usr/share/mysql/dutch/errmsg.sys /usr/share/mysql/dutch/errmsg.txt /usr/share/mysql/english /usr/share/mysql/english/errmsg.sys /usr/share/mysql/english/errmsg.txt /usr/share/mysql/estonia /usr/share/mysql/estonia/errmsg.sys /usr/share/mysql/estonia/errmsg.txt /usr/share/mysql/french /usr/share/mysql/french/errmsg.sys /usr/share/mysql/french/errmsg.txt /usr/share/mysql/german /usr/share/mysql/german/errmsg.sys /usr/share/mysql/german/errmsg.txt /usr/share/mysql/greek /usr/share/mysql/greek/errmsg.sys /usr/share/mysql/greek/errmsg.txt /usr/share/mysql/hungarian /usr/share/mysql/hungarian/errmsg.sys /usr/share/mysql/hungarian/errmsg.txt /usr/share/mysql/italian /usr/share/mysql/italian/errmsg.sys /usr/share/mysql/italian/errmsg.txt /usr/share/mysql/japanese
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
/etc/logrotate.d/mysql /etc/rc.d /etc/rc.d/init.d /etc/rc.d/init.d/mysql Well, it shows you as having an /etc/rc.d/init.d/mysql on install, so if it doesn't actually exist, I would say that's a pretty good sign that your install is fubar'ed. You may want to try re-installing your MySQL RPMs. -- Ben Reed a.k.a. Ranger Rick ([EMAIL PROTECTED]) http://defiance.dyndns.org/ / http://radio.scenespot.org/ Now playing on Defiance Radio: Pump Up The Volume by M.A.R.R.S.
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker [EMAIL PROTECTED] writes: [root@flp fran]# /etc/rc.d/init/mysql start bash: /etc/rc.d/init/mysql: No such file or directory maybe try with "/etc/rc.d/init.d/mysql start" ;p
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
On Sat, 2 Sep 2000, Fran Parker wrote: Hi Benjamin, I am really at a loss here, here's the output: [fran@flp fran]$ su Password: [root@flp fran]# /etc/rc.d/init/mysql start isn't that supposed to read /etc/rc.d/init.d/mysql start ? maybe the path was just wrong. bash: /etc/rc.d/init/mysql: No such file or directory [root@flp fran]# But when I boot .. mysql daemon is loaded. Bambi Benjamin Reed wrote: Can you make heads or tails out of that? :) Well, it lost the carriage returns in sending, but I didn't see mysql in there at all. Try '/etc/rc.d/init/mysql start' and then try your script again and see if that helps. If it does, you'll need to add the mysql script to your current runlevel's init. -- Ben Reed a.k.a. Ranger Rick ([EMAIL PROTECTED]) http://defiance.dyndns.org/ / http://radio.scenespot.org/ Now playing on Defiance Radio: I Don't Know You People by Orbital -- Regards, Ellick Chan [EMAIL PROTECTED] Sep 2
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
That would probably help :) But here's the output when I do that: [fran@flp fran]$ su Password: [root@flp fran]# /etc/rc.d/init.d/mysql start [root@flp fran]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended (and it hangs and doesn't give back the cursor ... had to control-c to get it back.) Bambi Pixel wrote: Fran Parker [EMAIL PROTECTED] writes: [root@flp fran]# /etc/rc.d/init/mysql start bash: /etc/rc.d/init/mysql: No such file or directory maybe try with "/etc/rc.d/init.d/mysql start" ;p
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Yep...you all are right! doh! But hung when I tried it correctly, I put the results in response to Jean-Michel Dault. Results are not good...but at least they are results to the correct command :P Bambi Pixel wrote: Fran Parker [EMAIL PROTECTED] writes: [root@flp fran]# /etc/rc.d/init/mysql start bash: /etc/rc.d/init/mysql: No such file or directory maybe try with "/etc/rc.d/init.d/mysql start" ;p
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
yep..and I guess that would normally help! But it didn't... see results in response to Jean-Michel Dault. Not good...but at least correct. Bambi Ellick Chan wrote: On Sat, 2 Sep 2000, Fran Parker wrote: Hi Benjamin, I am really at a loss here, here's the output: [fran@flp fran]$ su Password: [root@flp fran]# /etc/rc.d/init/mysql start isn't that supposed to read /etc/rc.d/init.d/mysql start ? maybe the path was just wrong. bash: /etc/rc.d/init/mysql: No such file or directory [root@flp fran]# But when I boot .. mysql daemon is loaded. Bambi Benjamin Reed wrote: Can you make heads or tails out of that? :) Well, it lost the carriage returns in sending, but I didn't see mysql in there at all. Try '/etc/rc.d/init/mysql start' and then try your script again and see if that helps. If it does, you'll need to add the mysql script to your current runlevel's init. -- Ben Reed a.k.a. Ranger Rick ([EMAIL PROTECTED]) http://defiance.dyndns.org/ / http://radio.scenespot.org/ Now playing on Defiance Radio: I Don't Know You People by Orbital -- Regards, Ellick Chan [EMAIL PROTECTED] Sep 2
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker wrote: Hi Benjamin, Well I did that and ps -A ... results follow (will try to align better with carriage returns:) Sorry for the slow response. Judging from this output, MySQL is definitely not running. Following the advice that others have given should be you going. (ie, either /etc/rc.d/init.d/mysql to start up whenever you want it of chkconfig --add mysql to have it automatically start upon boot) -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Hi Jean-Michel, I think I forgot one of the steps you suggested..here's output with the "chkconfig--add mysql" before running "/etc/rc.d/init.d/mysql start" [fran@flp fran]$ su Password: [root@flp fran]# chkconfig --add mysql [root@flp fran]# /etc/rc.d/init.d/mysql start [root@flp fran]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended [root@flp fran]# still had to control-c out of it to get prompt back after it reports mysql daemon ended. Thanks, Bambi Jean-Michel Dault wrote: On Fri, 1 Sep 2000, Fran Parker wrote: [root@flp fran]# perl -e 'use DBD::mysql;'; [root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]# Usually that just means the the MySQL server isn't started. Are you absolutely sure it's running? What does 'ps ux' show? From what I see, MySQL-perl is working, but your MySQL server is not running. First do a "chkconfig --add mysql" then run "/etc/rc.d/init.d/mysql start" Jean-Michel Dault [EMAIL PROTECTED] Hi Steve, ps ux as follows: [fran@flp fran]$ su Password: [root@flp fran]# ps ux USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.1 1060 112 ?S18:48 0:05 init root 2 0.0 0.0 00 ? SW 18:48 0:00 [kflushd] root 3 0.0 0.0 00 ?SW 18:48 0:00 [kupdate] root 4 0.0 0.0 00 ?SW 18:48 0:00 [kpiod] root 5 0.0 0.0 00 ?SW 18:48 0:02 [kswapd] root 6 0.0 0.0 00 ?SW 18:48 0:00 [mdrecoveryd] root 351 0.0 0.3 1116 208 ?S18:48 0:00 syslogd -m 0 root 361 0.0 0.7 1372 492 ?S18:48 0:00 klogd root 391 0.0 0.2 1272 168 ?S18:48 0:00 crond root 406 0.0 0.3 1080 196 ?S18:48 0:00 inetd root 421 0.0 0.1 1132 80 ?S18:48 0:00 lpd root 500 0.0 0.4 1584 288 ?S18:48 0:00 /usr/lib/postfix/root 522 0.0 0.1 1088 84 ttyS0S18:48 0:00 gpm -t ms root 588 0.0 2.1 3268 1396 ?S18:48 0:00 smbd -D root 598 0.0 0.9 1808 592 ?S18:48 0:00 nmbd -D root 628 0.0 0.0 1028 60 tty1 S18:48 0:00 /sbin/mingetty ttroot 629 0.0 0.0 1028 60 tty2 S18:48 0:00 /sbin/mingetty ttroot 630 0.0 0.0 1028 60 tty3 S18:48 0:00 /sbin/mingetty ttroot 631 0.0 0.0 1028 60 tty4 S18:48 0:00 /sbin/mingetty ttroot 632 0.0 0.0 1028 60 tty5 S18:48 0:00 /sbin/mingetty ttroot 633 0.0 0.0 1028 60 tty6 S18:48 0:00 /sbin/mingetty ttroot 634 0.0 0.3 6076 200 ? S18:48 0:00 kdm -nodaemon root 641 1.7 10.2 18540 6640 ? S18:48 5:06 /etc/X11/X -auth root 642 0.0 0.0 72600 ? SW 18:48 0:00 [kdm] root 727 0.0 1.4 6704 972 ?S 18:49 0:00 /usr/bin/kppp root 730 0.0 0.0 15040 ttyS1SW 18:50 0:00 [pppd] root 1071 0.5 1.4 2012 924 pts/0S23:39 0:00 su root 1074 1.1 1.9 2056 1268 pts/0S23:40 0:00 bash root 1089 0.0 1.4 2492 912 pts/0R23:40 0:00 ps ux [root@flp fran]# Can you make heads or tails out of that? :) Bambi Steve Fox wrote: Fran Parker wrote: Hi Pixel, got the ftp://ftp.mandrakesoft.com/pub/pixel/perl-Mysql-1.22_15-2mdk.i586.rpm and installed it, rebooted and got the following results (we are getting somewhere good, not all the way though): [fran@flp fran]$ su Password: -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker wrote: Hi Jean-Michel, I think I forgot one of the steps you suggested..here's output with the "chkconfig--add mysql" before running "/etc/rc.d/init.d/mysql start" [fran@flp fran]$ su Password: [root@flp fran]# chkconfig --add mysql [root@flp fran]# /etc/rc.d/init.d/mysql start [root@flp fran]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended That means it couldn't start up for some reason. Check /var/lib/mysql/mysqld.log for any errors. -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Thanks Pixel, Have downloaded and will try it out when I get home this evening. Will report back with results. Thanks again, Bambi Pixel wrote: Fran Parker [EMAIL PROTECTED] writes: Hi Francois, I went to the cooker site and downloaded what I believe is the latest one dated 8/29/2000 (perl-Mysql-1.22_15-1mdk.i586.rpm) and installed it. 2mdk is out. but the mirror pb keeps you away from it... if you're in a hurry, fetch it at ftp://ftp.mandrakesoft.com/pub/pixel/perl-Mysql-1.22_15-2mdk.i586.rpm
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Hi Pixel, got the ftp://ftp.mandrakesoft.com/pub/pixel/perl-Mysql-1.22_15-2mdk.i586.rpm and installed it, rebooted and got the following results (we are getting somewhere good, not all the way though): [fran@flp fran]$ su Password: [root@flp fran]# perl -e 'use DBD::mysql;'; [root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]# Still with this socket thingey! Any further suggestions...at least we got rid of the following :) [root@flp fran]# perl -e 'use DBD::mysql;'; Can't load '/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: pthread_key_create at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 200. at -e line 1 Compilation failed in require at -e line 1. BEGIN failed--compilation aborted at -e line 1. [root@flp fran]# that's a big step...at least I think so. Is there something I need to do that I don't know about to get it to work? Or is it a problem with this socket thingey? That is such an ambiguous error message...Error 2002...unknown error or something like that! Thanks, Bambi Pixel wrote: Fran Parker [EMAIL PROTECTED] writes: Hi Francois, I went to the cooker site and downloaded what I believe is the latest one dated 8/29/2000 (perl-Mysql-1.22_15-1mdk.i586.rpm) and installed it. 2mdk is out. but the mirror pb keeps you away from it... if you're in a hurry, fetch it at ftp://ftp.mandrakesoft.com/pub/pixel/perl-Mysql-1.22_15-2mdk.i586.rpm
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker wrote: Hi Pixel, got the ftp://ftp.mandrakesoft.com/pub/pixel/perl-Mysql-1.22_15-2mdk.i586.rpm and installed it, rebooted and got the following results (we are getting somewhere good, not all the way though): [fran@flp fran]$ su Password: [root@flp fran]# perl -e 'use DBD::mysql;'; [root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]# Usually that just means the the MySQL server isn't started. Are you absolutely sure it's running? What does 'ps ux' show? -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Hi Steve, ps ux as follows: [fran@flp fran]$ su Password: [root@flp fran]# ps ux USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.1 1060 112 ?S18:48 0:05 init root 2 0.0 0.0 00 ? SW 18:48 0:00 [kflushd] root 3 0.0 0.0 00 ?SW 18:48 0:00 [kupdate] root 4 0.0 0.0 00 ?SW 18:48 0:00 [kpiod] root 5 0.0 0.0 00 ?SW 18:48 0:02 [kswapd] root 6 0.0 0.0 00 ?SW 18:48 0:00 [mdrecoveryd] root 351 0.0 0.3 1116 208 ?S18:48 0:00 syslogd -m 0 root 361 0.0 0.7 1372 492 ?S18:48 0:00 klogd root 391 0.0 0.2 1272 168 ?S18:48 0:00 crond root 406 0.0 0.3 1080 196 ?S18:48 0:00 inetd root 421 0.0 0.1 1132 80 ?S18:48 0:00 lpd root 500 0.0 0.4 1584 288 ?S18:48 0:00 /usr/lib/postfix/root 522 0.0 0.1 1088 84 ttyS0S18:48 0:00 gpm -t ms root 588 0.0 2.1 3268 1396 ?S18:48 0:00 smbd -D root 598 0.0 0.9 1808 592 ?S18:48 0:00 nmbd -D root 628 0.0 0.0 1028 60 tty1 S18:48 0:00 /sbin/mingetty ttroot 629 0.0 0.0 1028 60 tty2 S18:48 0:00 /sbin/mingetty ttroot 630 0.0 0.0 1028 60 tty3 S18:48 0:00 /sbin/mingetty ttroot 631 0.0 0.0 1028 60 tty4 S18:48 0:00 /sbin/mingetty ttroot 632 0.0 0.0 1028 60 tty5 S18:48 0:00 /sbin/mingetty ttroot 633 0.0 0.0 1028 60 tty6 S18:48 0:00 /sbin/mingetty ttroot 634 0.0 0.3 6076 200 ? S18:48 0:00 kdm -nodaemon root 641 1.7 10.2 18540 6640 ? S18:48 5:06 /etc/X11/X -auth root 642 0.0 0.0 72600 ? SW 18:48 0:00 [kdm] root 727 0.0 1.4 6704 972 ?S 18:49 0:00 /usr/bin/kppp root 730 0.0 0.0 15040 ttyS1SW 18:50 0:00 [pppd] root 1071 0.5 1.4 2012 924 pts/0S23:39 0:00 su root 1074 1.1 1.9 2056 1268 pts/0S23:40 0:00 bash root 1089 0.0 1.4 2492 912 pts/0R23:40 0:00 ps ux [root@flp fran]# Can you make heads or tails out of that? :) Bambi Steve Fox wrote: Fran Parker wrote: Hi Pixel, got the ftp://ftp.mandrakesoft.com/pub/pixel/perl-Mysql-1.22_15-2mdk.i586.rpm and installed it, rebooted and got the following results (we are getting somewhere good, not all the way though): [fran@flp fran]$ su Password: [root@flp fran]# perl -e 'use DBD::mysql;'; [root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]# Usually that just means the the MySQL server isn't started. Are you absolutely sure it's running? What does 'ps ux' show? -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Sorry about the formatting Steve... It looked much better in the terminal window, nice columns :) Netscrappy did some strange stuff to it. Bambi Steve Fox wrote: Fran Parker wrote: Hi Pixel, got the ftp://ftp.mandrakesoft.com/pub/pixel/perl-Mysql-1.22_15-2mdk.i586.rpm and installed it, rebooted and got the following results (we are getting somewhere good, not all the way though): [fran@flp fran]$ su Password: [root@flp fran]# perl -e 'use DBD::mysql;'; [root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]# Usually that just means the the MySQL server isn't started. Are you absolutely sure it's running? What does 'ps ux' show? -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Hi Francois, I went to the cooker site and downloaded what I believe is the latest one dated 8/29/2000 (perl-Mysql-1.22_15-1mdk.i586.rpm) and installed it. I normally run in KDE but I checked in Gnome in the runlevel editor and the mysql daemon is running on all levels which is confirmed during boot as well. However, I still get the following errors when I try to run mysql. [fran@flp fran]$ su Password: [root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]# perl -e 'use DBD::mysql;'; Can't load '/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: pthread_key_create at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 200. at -e line 1 Compilation failed in require at -e line 1. BEGIN failed--compilation aborted at -e line 1. [root@flp fran]# what is the deal with this socket thing ... I searched my computer for /var/lib/mysql/mysql.sock and I don't find one. Also line 200 (and 201) of DynaLoader.pm states the following: my $libref = dl_load_file($file, $module-dl_load_flags) or croak("Can't load '$file' for module $module: ".dl_error()); Any help there? Did I get the latest one perl-Mysql that you were talking about? Thanks for any help on this. Bambi Francois Pons wrote: Fran Parker [EMAIL PROTECTED] writes: I went and installed all perl related items I could that didn't conflict with anything else and re-installed mysql and it still doesn't work. And I was incorrect about the perl-base...it was there but near the bottom of the perl rpm list. I will see whether a reboot helps any. None, I added a patch in perl-Mysql to add libpthread, this should be the problem, now it works for me. Can you test averything is right now ? And thanks a lot for the bug report, François.
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker [EMAIL PROTECTED] writes: Hi Francois, I went to the cooker site and downloaded what I believe is the latest one dated 8/29/2000 (perl-Mysql-1.22_15-1mdk.i586.rpm) and installed it. 2mdk is out. but the mirror pb keeps you away from it... if you're in a hurry, fetch it at ftp://ftp.mandrakesoft.com/pub/pixel/perl-Mysql-1.22_15-2mdk.i586.rpm
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
I went and installed all perl related items I could that didn't conflict with anything else and re-installed mysql and it still doesn't work. And I was incorrect about the perl-base...it was there but near the bottom of the perl rpm list. I will see whether a reboot helps any. Bambi Fran Parker wrote: This is the same info I sent under another heading call something is going on with perl. Placing here as well to see if anyone knows what is going on. Please see the original message entitled something is going on with perl for Stefan's quandry with perl as well. I replied under that subject with the following: Hi, I am in a similar quandry! Here is a message I wrote yesterday. Fran Parker wrote: I also have uninstalled the cooker mysql and installed the one from the stable current. Still doesn't work. This is what I get: [fran@flp fran]$ su Password: [root@flp fran]# cd / [root@flp /]# perl -e 'use DBD::mysql;'; Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: pthread_key_create at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at -e line 1 BEGIN failed--compilation aborted at -e line 1. [root@flp /]# This was the reply I got...which I took to heart and did: You need to upgrade to the latest Perl packages which will s/5.005/5.6.0/ I'd be willing to bet you'll find Mysql.pm in /usr/lib/perl5/site_perl/5.6.0/ or /usr/lib/perl5/site_perl/i386-linux/ -- Steve Fox http://k-lug.com Well...now perl still won't do it since upgraded to perl/5.6.0 I don't know what to do now! Here is what I get when I tried to do the same thing again after installing 5.6.0: [fran@flp fran]$ su Password: [root@flp fran]# perl -e 'use DBD::mysql;'; [root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]# This is the same error I was getting after successfully doing the data-ShowTable thingey...with previous version of perl, see below: All tests successful. Files=17, Tests=128, 10 wallclock secs ( 5.12 cusr + 1.83 csys = 6.95 CPU) /usr/bin/make test -- OK Running make install Installing /usr/lib/perl5/site_perl/5.005/Data/ShowTable.pm Installing /usr/man/man1/showtable.1 Installing /usr/lib/perl5/man/man3/Data::ShowTable.3 Installing /usr/bin/showtable Writing /usr/lib/perl5/site_perl/5.005/i386-linux/auto/Data/ShowTable/.packlist Appending installation info to /usr/lib/perl5/5.00503/i386-linux/perllocal.pod /usr/bin/make install -- OK [root@flp Msql-Mysql-modules-1.2211]# cd.. [root@flp fran]# cd / [root@flp /]# perl -e 'use DBD::mysql;'; [root@flp /]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) [root@flp /]# whoami root Any help on this would be helpful. Note: Mandrake site had the perl 5.6.0 but did not have the perl base for the same version anywhere on the site. I hope someone can help with this. I am just trying to change from .CSV to mysql for the database for Pronto! mail. .CSV is too slow. This has been a nightmare so far for 4 days now. I am at a loss as to what to do about this incompatibility thing. Thanks for anyhelp anyone can give on this. Bambi Steve Fox wrote: Fran Parker wrote: I also have uninstalled the cooker mysql and installed the one from the stable current. Still doesn't work. This is what I get: [fran@flp fran]$ su Password: [root@flp fran]# cd / [root@flp /]# perl -e 'use DBD::mysql;'; Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: pthread_key_create at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at -e line 1 BEGIN failed--compilation aborted at -e line 1. [root@flp /]# You need to upgrade to the latest Perl packages which will s/5.005/5.6.0/ I'd be willing to bet you'll find Mysql.pm in /usr/lib/perl5/site_perl/5.6.0/ or /usr/lib/perl5/site_perl/i386-linux/ -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker wrote: I also have uninstalled the cooker mysql and installed the one from the stable current. Still doesn't work. This is what I get: [fran@flp fran]$ su Password: [root@flp fran]# cd / [root@flp /]# perl -e 'use DBD::mysql;'; Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: pthread_key_create at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at -e line 1 BEGIN failed--compilation aborted at -e line 1. [root@flp /]# This is odd. If you've loaded the perl-5.6.0 rpm then it should be looking in the 5.6.0 directories, not the 5.005. What does `rpm -qa | grep perl` show? -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Fran Parker [EMAIL PROTECTED] writes: I went and installed all perl related items I could that didn't conflict with anything else and re-installed mysql and it still doesn't work. And I was incorrect about the perl-base...it was there but near the bottom of the perl rpm list. I will see whether a reboot helps any. None, I added a patch in perl-Mysql to add libpthread, this should be the problem, now it works for me. Can you test averything is right now ? And thanks a lot for the bug report, François.
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
This is very odd...I noted on boot that mysql daemon is loading. However, this is the response when I do `rpm -qa | grep perl` [fran@flp fran]$ su Password: [root@flp fran]# `rpm -qa | grep perl` bash: perlftlib-1.2-7mdk: command not found [root@flp fran]# I just don't get it. gnorpm shows that perlftlib is installed. I don't get it. Bambi Steve Fox wrote: Fran Parker wrote: I also have uninstalled the cooker mysql and installed the one from the stable current. Still doesn't work. This is what I get: [fran@flp fran]$ su Password: [root@flp fran]# cd / [root@flp /]# perl -e 'use DBD::mysql;'; Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: pthread_key_create at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at -e line 1 BEGIN failed--compilation aborted at -e line 1. [root@flp /]# This is odd. If you've loaded the perl-5.6.0 rpm then it should be looking in the 5.6.0 directories, not the 5.005. What does `rpm -qa | grep perl` show? -- Steve Fox http://k-lug.com
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
Great Francois...I will go and get the patch...hope it is in cooker :) Then I will report back...thank you so much! Bambi Francois Pons wrote: Fran Parker [EMAIL PROTECTED] writes: I went and installed all perl related items I could that didn't conflict with anything else and re-installed mysql and it still doesn't work. And I was incorrect about the perl-base...it was there but near the bottom of the perl rpm list. I will see whether a reboot helps any. None, I added a patch in perl-Mysql to add libpthread, this should be the problem, now it works for me. Can you test averything is right now ? And thanks a lot for the bug report, François.
Re: [Cooker] perl-mysql (was: mod_php-mysql bad)
This is the same info I sent under another heading call something is going on with perl. Placing here as well to see if anyone knows what is going on. Please see the original message entitled something is going on with perl for Stefan's quandry with perl as well. I replied under that subject with the following: Hi, I am in a similar quandry! Here is a message I wrote yesterday. Fran Parker wrote: I also have uninstalled the cooker mysql and installed the one from the stable current. Still doesn't work. This is what I get: [fran@flp fran]$ su Password: [root@flp fran]# cd / [root@flp /]# perl -e 'use DBD::mysql;'; Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: pthread_key_create at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at -e line 1 BEGIN failed--compilation aborted at -e line 1. [root@flp /]# This was the reply I got...which I took to heart and did: You need to upgrade to the latest Perl packages which will s/5.005/5.6.0/ I'd be willing to bet you'll find Mysql.pm in /usr/lib/perl5/site_perl/5.6.0/ or /usr/lib/perl5/site_perl/i386-linux/ -- Steve Fox http://k-lug.com Well...now perl still won't do it since upgraded to perl/5.6.0 I don't know what to do now! Here is what I get when I tried to do the same thing again after installing 5.6.0: [fran@flp fran]$ su Password: [root@flp fran]# perl -e 'use DBD::mysql;'; [root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]# This is the same error I was getting after successfully doing the data-ShowTable thingey...with previous version of perl, see below: All tests successful. Files=17, Tests=128, 10 wallclock secs ( 5.12 cusr + 1.83 csys = 6.95 CPU) /usr/bin/make test -- OK Running make install Installing /usr/lib/perl5/site_perl/5.005/Data/ShowTable.pm Installing /usr/man/man1/showtable.1 Installing /usr/lib/perl5/man/man3/Data::ShowTable.3 Installing /usr/bin/showtable Writing /usr/lib/perl5/site_perl/5.005/i386-linux/auto/Data/ShowTable/.packlist Appending installation info to /usr/lib/perl5/5.00503/i386-linux/perllocal.pod /usr/bin/make install -- OK [root@flp Msql-Mysql-modules-1.2211]# cd.. [root@flp fran]# cd / [root@flp /]# perl -e 'use DBD::mysql;'; [root@flp /]# mysql -u root ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) [root@flp /]# whoami root Any help on this would be helpful. Note: Mandrake site had the perl 5.6.0 but did not have the perl base for the same version anywhere on the site. I hope someone can help with this. I am just trying to change from .CSV to mysql for the database for Pronto! mail. .CSV is too slow. This has been a nightmare so far for 4 days now. I am at a loss as to what to do about this incompatibility thing. Thanks for anyhelp anyone can give on this. Bambi Steve Fox wrote: Fran Parker wrote: I also have uninstalled the cooker mysql and installed the one from the stable current. Still doesn't work. This is what I get: [fran@flp fran]$ su Password: [root@flp fran]# cd / [root@flp /]# perl -e 'use DBD::mysql;'; Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: pthread_key_create at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at -e line 1 BEGIN failed--compilation aborted at -e line 1. [root@flp /]# You need to upgrade to the latest Perl packages which will s/5.005/5.6.0/ I'd be willing to bet you'll find Mysql.pm in /usr/lib/perl5/site_perl/5.6.0/ or /usr/lib/perl5/site_perl/i386-linux/ -- Steve Fox http://k-lug.com