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/3 S 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 > ========================================================================= > --------------------------------------------------------------------- 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
