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