Re: [Pacemaker] failed actions: insufficient privileges

2011-06-12 Thread Alfredo Parisi
Hi Jeff, i've repeated the steps and finally it works. I've installed Drupal on the db and all works fine. thanks a lot for your help. Best regards, A. Parisi. 2011/6/12 imnotpc > On Sunday, June 12, 2011 11:36:54 Alfredo Parisi wrote: > > sorry but i've wrote wrong in the last msg. all folders

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-12 Thread imnotpc
On Sunday, June 12, 2011 11:36:54 Alfredo Parisi wrote: > sorry but i've wrote wrong in the last msg. all folders and files are in > the /data/mysql but it won't works > in the primitive if i setting /var/lib/mysql it works fine but if i change > it, it won't work! I'm not sure why pacemaker can r

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-12 Thread Alfredo Parisi
sorry but i've wrote wrong in the last msg. all folders and files are in the /data/mysql but it won't works in the primitive if i setting /var/lib/mysql it works fine but if i change it, it won't work! 2011/6/12 imnotpc > On Sunday, June 12, 2011 10:12:40 Alfredo Parisi wrote: > > Hi Jeff, > > i

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-12 Thread imnotpc
On Sunday, June 12, 2011 10:12:40 Alfredo Parisi wrote: > Hi Jeff, > i've changed all the primitives and i've returned to the initial > configuration and added the line on my.cnf and it works. > If i modify datadir on the primitive with /data/mysql (in this directory > there is /var/lib/mysql) it d

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-12 Thread Alfredo Parisi
Hi Jeff, i've changed all the primitives and i've returned to the initial configuration and added the line on my.cnf and it works. If i modify datadir on the primitive with /data/mysql (in this directory there is /var/lib/mysql) it doesn't works I need to share the database because after I'll insta

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-12 Thread imnotpc
On Sunday, June 12, 2011 07:35:25 Alfredo Parisi wrote: > This is my file my.cnf > # > # The MySQL database server configuration file. > # > # You can copy this to one of: > # - "/etc/mysql/my.cnf" to set global options, > # - "~/.my.cnf" to set user-specific options. > # > # One can use all long o

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-12 Thread Alfredo Parisi
This is my file my.cnf # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread imnotpc
On Saturday, June 11, 2011 18:01:35 Alfredo Parisi wrote: > yes, i'm using the same my.cnf and i'm working on ubuntu 10.10 server. > i've removed the mysql startup (update-rc.d -f mysql remove), so mysql is > managed only by pacemaker. > i've installed mysql-server by myself with phpmyadmin and php

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread Alfredo Parisi
yes, i'm using the same my.cnf and i'm working on ubuntu 10.10 server. i've removed the mysql startup (update-rc.d -f mysql remove), so mysql is managed only by pacemaker. i've installed mysql-server by myself with phpmyadmin and php5. on each mode there is an installation of mysql-server but the s

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread imnotpc
On Saturday, June 11, 2011 14:29:54 Alfredo Parisi wrote: > If I start on mysql, in the /var/run/mysqld there is the .sock file...so I > think that the path is correct How are you starting mysql? I thought you said mysql couldn't write to that directory and you had to create the file yourself to

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread Alfredo Parisi
If I start on mysql, in the /var/run/mysqld there is the .sock file...so I think that the path is correct 2011/6/11 imnotpc > On Saturday, June 11, 2011 13:45:18 Alfredo Parisi wrote: > > not installed on my servers. and now? Thanks again.. > > Are you sure your mysql daemon is writing the socke

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread imnotpc
On Saturday, June 11, 2011 13:45:18 Alfredo Parisi wrote: > not installed on my servers. and now? Thanks again.. Are you sure your mysql daemon is writing the socket to /var/run/mysqld? That's normally the place the pid file goes. By default most distros use /var/lib/mysql/ for sockets. ___

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread Alfredo Parisi
not installed on my servers. and now? Thanks again.. 2011/6/11 Vladislav Bogdanov > 11.06.2011 20:13, Alfredo Parisi wrote: > > Thanks again for the response. > > Actually these are my permissions on /var/run/mysqld > > > > root@server1:/var/run# ls -l | grep mysql > > drwxr-xr-x 2 mysql ro

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread Vladislav Bogdanov
11.06.2011 20:13, Alfredo Parisi wrote: > Thanks again for the response. > Actually these are my permissions on /var/run/mysqld > > root@server1:/var/run# ls -l | grep mysql > drwxr-xr-x 2 mysql root 40 2011-06-11 19:06 > > they are correct for mysql on pacemaker?thanks Yes. Please

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread Alfredo Parisi
Thanks again for the response. Actually these are my permissions on /var/run/mysqld root@server1:/var/run# ls -l | grep mysql drwxr-xr-x 2 mysql root 40 2011-06-11 19:06 they are correct for mysql on pacemaker?thanks 2011/6/11 Vladislav Bogdanov > 11.06.2011 19:01, Alfredo Parisi

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread Vladislav Bogdanov
11.06.2011 19:01, Alfredo Parisi wrote: > Hi and thanks for the reply. > I've found the problem, pacemaker haven't the privileges for create the > file mysqld.sock, infact if I stop one server and create mysqld.sock > with 777 and own mysql:mysql, after restart corosync, it works... > but this is o

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-11 Thread Alfredo Parisi
Hi and thanks for the reply. I've found the problem, pacemaker haven't the privileges for create the file mysqld.sock, infact if I stop one server and create mysqld.sock with 777 and own mysql:mysql, after restart corosync, it works... but this is only a temporary solution because when corosync is

Re: [Pacemaker] failed actions: insufficient privileges

2011-06-10 Thread Dejan Muhamedagic
Hi, On Fri, Jun 10, 2011 at 05:43:17PM +0200, Alfredo Parisi wrote: > Hi at all, > I've a problem on crm_mon. I've configured apache, drbd and mysql with the > guide of cluster labs(Cluster from Scratch) and mysql.com ( > http://dev.mysql.com/doc/refman/5.6/en/ha-drbd-install-mysql.html). > I've c

[Pacemaker] failed actions: insufficient privileges

2011-06-10 Thread Alfredo Parisi
Hi at all, I've a problem on crm_mon. I've configured apache, drbd and mysql with the guide of cluster labs(Cluster from Scratch) and mysql.com ( http://dev.mysql.com/doc/refman/5.6/en/ha-drbd-install-mysql.html). I've copied /var/lib/mysql and my.cnf on drbd device, created a symbolic link on /etc