OpenVZ Forum: Support » WIKI - Shared webhosting

Home » General » Support » WIKI - Shared webhosting - problem with mysql socket

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: WIKI - Shared webhosting - problem with mysql socket [message #23305 is a reply to message #23281]

Thu, 15 November 2007 12:10

curx
Messages: 739
Registered: February 2006
Location: Nürnberg, Germany

Senior Member

Hi,

1) ssh connection VE -> VE0

A wrapper, when restarting a mysql-server in VE, a predefined ssh connetion to VE0, maybe different port , which invoke the ln sequence.

* setup a nonpasswd ssh connection with authorizeds_keys
* maybe start a non-sshd-port sshd (port 22!) daemon on VE0, with sshd_option
"PermitRootLogin forced-commands-only"

and a ssh connection like:

VE# ssh -p <PORT> root@<VE0_IP_or_NAME> 'ln /var/lib/vz/root/<VEID_mysqld>/var/run/mysql/mysql.sock /var/lib/vz/root/<VEID_NON_mysqld>/var/run/mysql/mysql.sock'

2) setup a shared folder with mount -o bind ...

3) setup mysqld with connection settings and limit the IP, which can connect to mysqld with iptables or tcpd-wrapper

Report message to a moderator

[Message index]

		WIKI - Shared webhosting - problem with mysql socket By: tauren on Wed, 14 November 2007 07:15
		Re: WIKI - Shared webhosting - problem with mysql socket By: curx on Thu, 15 November 2007 06:56
		Re: WIKI - Shared webhosting - problem with mysql socket By: tauren on Thu, 15 November 2007 08:32
		Re: WIKI - Shared webhosting - problem with mysql socket By: curx on Thu, 15 November 2007 12:10
		Re: WIKI - Shared webhosting - problem with mysql socket By: tauren on Fri, 16 November 2007 01:58
		Re: WIKI - Shared webhosting - problem with mysql socket By: sudhaker on Wed, 14 May 2008 18:12

Previous Topic:	HN-based firewall dns problems
Next Topic:	Why CentOS 5 VE templates not official

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Oct 02 03:40:52 GMT 2025

Total time taken to generate the page: 0.08934 seconds