From: Werner Schalk (werner_schalk_at_gmx.de)
Date: Mon 16 May 2005 - 10:31:04 BST
Hi,
> You'll have to bind it to the ip you gave your vserver instead of
> localhost, it should be somewhere in the configfiles, googling for it might
> help too ;)
well of course I tried this as well but it did not work for some bizarre
reason. I tried to run MySQL inside the vserver with the option
"skip-networking" which should disable all TCP/IP connections:
# mysqld --skip-innodb --user=mysql --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock --log-error=/var/log/mysql/mysqld.err
--basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp
--language=/usr/share/mysql/english --skip-locking
--set-variable=key_buffer=16M --set-variable=max_allowed_packet=1M
--set-variable=thread_stack=128K --skip-networking
--log=/var/log/mysql/mysql.log --console --log-warnings
However I still get this error message:
050526 3:07:16 Can't start server : Bind on unix socket: Permission denied
050526 3:07:16 Do you already have another mysqld server running on
socket: /var/run/mysqld/mysqld.sock ?
050526 3:07:16 Aborting
050526 3:07:16 mysqld: Shutdown Complete
Now I tried to bind MySQL to the IP (10.0.1.20) of the vserver:
# mysqld --skip-innodb --user=mysql --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock --log-error=/var/log/mysql/mysqld.err
--basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp
--language=/usr/share/mysql/english --skip-locking
--set-variable=key_buffer=16M --set-variable=max_allowed_packet=1M
--set-variable=thread_stack=128K --bind-address=10.0.1.20 --port=3306
--log=/var/log/mysql/mysql.log --console --log-warnings
And the result is still the same:
050526 3:07:21 Can't start server : Bind on unix socket: Permission denied
050526 3:07:21 Do you already have another mysqld server running on
socket: /var/run/mysqld/mysqld.sock ?
050526 3:07:21 Aborting
050526 3:07:21 mysqld: Shutdown Complete
Any more ideas? Anyone got this working alright?
Thanks a lot.
Bye,
Werner.
_______________________________________________
Vserver mailing list
Vserver_at_list.linux-vserver.org
http://list.linux-vserver.org/mailman/listinfo/vserver