View Single Post
  #13  
Old 4th July 2013, 18:23
onastvar onastvar is offline
Senior Member
 
Join Date: Apr 2008
Location: U.S.A.
Posts: 192
Thanks: 61
Thanked 12 Times in 12 Posts
Default

I'm trying Setting Up The Two Base Systems using this tutorial.

http://www.howtoforge.com/installing...th-ispconfig-3

I'm having the same issues when I add following to /etc/mysql/my.cnf

Code:
[mysqld]
server-id = 1
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 1

master-host = 192.168.0.106
master-user = slaveuser
master-password = mypassword
master-connect-retry = 60

expire_logs_days        = 10
max_binlog_size         = 500M
log_bin                 = /var/log/mysql/mysql-bin.log
After I add above to /etc/mysql/my.cnf I cannot start mysqld
"Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!"

When I run: grep mysql /var/log/syslog I get:

Jul 4 10:58:42 moon mysqld: 130704 10:58:42 [Note] /usr/sbin/mysqld: Normal shutdown
Jul 4 10:58:42 moon mysqld:
Jul 4 10:58:42 moon mysqld: 130704 10:58:42 [Note] Event Scheduler: Purging the queue. 0 events
Jul 4 10:58:42 moon mysqld: 130704 10:58:42 InnoDB: Starting shutdown...
Jul 4 10:58:43 moon mysqld: 130704 10:58:43 InnoDB: Shutdown completed; log sequence number 249666817
Jul 4 10:58:43 moon mysqld: 130704 10:58:43 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 4 10:58:43 moon mysqld:
Jul 4 10:58:43 moon mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jul 4 10:58:44 moon mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 [Note] Plugin 'FEDERATED' is disabled.
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 InnoDB: The InnoDB memory heap is disabled
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 InnoDB: Compressed tables use zlib 1.2.7
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 InnoDB: Using Linux native AIO
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 InnoDB: Initializing buffer pool, size = 128.0M
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 InnoDB: Completed initialization of buffer pool
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 InnoDB: highest supported file format is Barracuda.
Jul 4 10:58:44 moon mysqld: 130704 10:58:44 InnoDB: Waiting for the background threads to start
Jul 4 10:58:45 moon mysqld: 130704 10:58:45 InnoDB: 5.5.31 started; log sequence number 249666817
Jul 4 10:58:45 moon mysqld: 130704 10:58:45 [ERROR] /usr/sbin/mysqld: unknown variable 'master-host=192.168.0.105'
Jul 4 10:58:45 moon mysqld: 130704 10:58:45 [ERROR] Aborting
Jul 4 10:58:45 moon mysqld:
Jul 4 10:58:45 moon mysqld: 130704 10:58:45 InnoDB: Starting shutdown...
Jul 4 10:58:46 moon mysqld: 130704 10:58:46 InnoDB: Shutdown completed; log sequence number 249666817
Jul 4 10:58:46 moon mysqld: 130704 10:58:46 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 4 10:58:46 moon mysqld:
Jul 4 10:58:46 moon mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jul 4 10:58:58 moon /etc/init.d/mysql[14199]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 4 10:58:58 moon /etc/init.d/mysql[14199]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 4 10:58:58 moon /etc/init.d/mysql[14199]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 4 10:58:58 moon /etc/init.d/mysql[14199]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 4 10:58:58 moon /etc/init.d/mysql[14199]:

Both server are identical (Debian 7.0 and MySQL 5.5)
What was the solution, could you please share?

Thank You
__________________
ISPConfig 3.0.5.4p5 | Debian Wheezy | BIND | Dovecot 2.1.7 | Apache 2.2.22 | MySQL 5.5.38 | PHP 5.3.22

Last edited by onastvar; 5th July 2013 at 00:13.
Reply With Quote