AW: Got an error reading communication packets
hi van thank you for responding. but i have gcc-2.95.2-149 installed (a suse 7.1 version). so i think this isn't the problem... i tried several other things: i changed to other auth_mysql modules for apache: didn't help i used apache 1.3.17: didn't help i tried it first with php 4.0.4pl1: didn't help (by the way: is there any way to get the zend optimizer for php 4.0.5pl1?) so, any new idea? steven -Ursprngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Van Gesendet: Dienstag, 20. Mrz 2001 04:47 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: Got an error reading communication packets Steven Glogger wrote: after upgrading to 3.23.35 (from 3.22.32) i've got several times: 010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication packets) it's running on a productive server, but it's not working correctly. some infos: apache 1.3.19, Linux 2.2.18-SMP #1 SMP Sat Jan 20 07:41:17 GMT 2001 i686 unknown, PHP 4.0.5 RC1 any idea what it is? greetings steven Steven: Check your compiler. I was getting this when compiling with egcs-2.91. Upgraded to 2.95.2 and all is happy, now. Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: Got an error reading communication packets
Steven Glogger wrote: hi van thank you for responding. but i have gcc-2.95.2-149 installed (a suse 7.1 version). so i think this isn't the problem... i tried several other things: i changed to other auth_mysql modules for apache: didn't help i used apache 1.3.17: didn't help i tried it first with php 4.0.4pl1: didn't help (by the way: is there any way to get the zend optimizer for php 4.0.5pl1?) so, any new idea? steven Steven: I'm still getting the same on my production server, but, the queries and updates are still working. It isn't your applications, it's your db. Don't work with the Apache/auth_mysql modules. They're not the problem. Curious... That's a pretty long stretch from 3.22.32 to 3.23.35. Did you shutdown the dbases and do an isamchk /path-to-mysql-dbs/*/*ISD or myisamchk /path-to-mysql-dbs/*/*MYI ? MyISAM's better. Good options when making such an upgrade are: {My db's are on their own partition /mysql} myisamchk -o /mysql/*/*MYI myisamchk -evi /mysql/*/*MYI Anyone else want to chime in, go for it. Might help. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: AW: AW: Got an error reading communication packets
hi van ok, here we are: CONFIGURE/INSTALLATION === i installed it with: ./configure --datadir=/usr/local/mysql/data --localstatedir=/www/server/dat abases make make install cd scripts ./mysql_install_db cd ../support-files chmod 755 mysql.server cp mysql.server /etc/rc.d/mysql.server STARTING THE DAEMON /etc/rc.d/mysql.server start root@wpm(/usr/local/mysql) ps ax | grep mysql 12488 ?S 0:00 sh /usr/local/bin/safe_mysqld --user=root --pid-file=/www/server/databases/wpm. pid --datadir=/www/server/databases 12512 ?S 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/www/server/databas es --user=root --pid-file=/www/server/databases/wpm.pid --skip-locking 12514 ?S 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/www/server/databas es --user=root --pid-file=/www/server/databases/wpm.pid --skip-locking 12515 ?S 0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/www/server/databas es --user=root --pid-file=/www/server/databases/wpm.pid --skip-locking 23390 pts/3S 0:00 grep mysql = /etc/my.cnf === # Example mysql config file. # You can copy this to one of: # /usr/local/etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/var) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password = my_password port= 3306 socket = /tmp/mysql.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] #port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= max_connections=1024 set-variable= wait_timeout=600 # Start logging #log [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=16M LOG FILE = 010303 18:30:11 Aborted connection 1727 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication pa ckets) 010303 18:33:11 Aborted connection 1729 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication pa ckets) 010303 18:33:17 Aborted connection 1730 to db: 'server_admin' user: 'admin' host: `localhost' (Got an error reading communication p ackets) 010303 18:33:17 Aborted connection 1731 to db: 'server_admin' user: 'admin' host: `localhost' (Got an error reading communication p ackets) [this message is what i got all 3 minutes (ok, my whatsup is checking every 3 minutes if the daemon is working, but he is connecting only with a mysql-client to see, if its working)] i think maybe it's a problem with the libraries. but i tried it on 2 different linux (suse 7.1 and 6.4) systems, both smp systems, and on both i got the same error... sounds strange to me greetings thank you -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Van Sent: Tuesday, March 20, 2001 10:31 AM To: [EMAIL PROTECTED] Subject: Re: AW: AW: Got an error reading communication packets Steven Glogger wrote: hi van thank you for the tip. on a test server i installed a fresh version of mysql 3.23.35. so... i think dont have to myisamchk the files mysql has been compiled with a simple ./configure; make; make install procedure but the result is: not working... this is a strange error. i found many mailinglist entries about this problem, but no one seems to have solved this problem... any futher ideas? steven Steven: Gotta call it a night, but, if you can send some snippets from the logs, I could probably help you. Strip the passwords out. I don't wanna see 'em. In the configure did you set a --localstatedir=/somedir/ directive? If so, you'll see a log entry. Do you have an /etc/my.cnf file? Do you start with mysqld or safe_mysqld? ps ax | grep mysql Flash that output strip passwds echo `I don\'t want \'em` These'll help. I don't do RedHat, but, understand it pretty well, but, the issue we're working with is pretty insidious. I still get 'em on my server in MI. I'm okay w' it since the li'l bastard is still doing his job 155 days after his last reboot, but, I really want to get a bead on this lost communications packets problem. I'm pretty sure it's a library issue. Let me know what you find. As-a-gwin' ta sleep. Peace, Van -- = Linux rocks!!! http://www.dedserius.com
Re: AW: AW: Got an error reading communication packets
Steven Glogger wrote: LOG FILE = 010303 18:30:11 Aborted connection 1727 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication pa ckets) 010303 18:33:11 Aborted connection 1729 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication pa ckets) 010303 18:33:17 Aborted connection 1730 to db: 'server_admin' user: 'admin' host: `localhost' (Got an error reading communication p ackets) 010303 18:33:17 Aborted connection 1731 to db: 'server_admin' user: 'admin' host: `localhost' (Got an error reading communication p ackets) [this message is what i got all 3 minutes (ok, my whatsup is checking every 3 minutes if the daemon is working, but he is connecting only with a mysql-client to see, if its working)] i think maybe it's a problem with the libraries. but i tried it on 2 different linux (suse 7.1 and 6.4) systems, both smp systems, and on both i got the same error... sounds strange to me greetings thank you Steven: Don't see anything wrong with your installation. Most likely library problem. Check that you have the most current GLIBC-2.2. Also, on slackware I upgraded the following packages in order to get my Glibc-2.1.3 Slackware 7.0 current enough to run MySQL-3.23.33. -rw-r--r-- 1 root root 3386217 Dec 30 22:12 gcc.tgz -rw-r--r-- 1 root root 1851876 Dec 30 22:14 ncurses.tgz -rw-r--r-- 1 root root 27932668 Jan 29 10:12 glibc.tgz -rw-r--r-- 1 root root 4002594 Jan 29 10:13 glocale.tgz -rw-r--r-- 1 root root 385188 Mar 2 22:06 gettext.tgz -rw-r--r-- 1 root root 270797 Mar 2 22:07 readline.tgz There's one other I need to get, but, the server's running and can't mess with it for a few more days. Not sure what the remaining package is, but, hopefully when you do your rpm -Uvh's, it will tell you. I'd be interested to know. BTW, the GLIBC-2.2 was a security fix for all Linux distros. Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php