#1  
Old 22nd September 2007, 19:31
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
Default mysql replication

Hello i try to do a database replication as i described at:

http://www.howtoforge.com/mysql_database_replication


but when i type this to mycnf

log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db=exampledb
server-id=1


the mysql doesnt start

Ofcourse i have the right values at these fields.
Any suggestion?
Thank you.
Reply With Quote
Sponsored Links
  #2  
Old 23rd September 2007, 19:15
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Do you see any error messages? Are there any errors in your logs?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 25th September 2007, 21:27
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
Default

i think that this is from log:


070922 19:10:25 [Note] /usr/libexec/mysqld: Normal shutdown

070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:27 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:10:27 mysqld ended

070922 19:10:28 mysqld started
/usr/libexec/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
070922 19:10:28 [ERROR] Aborting

070922 19:10:28 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:10:28 mysqld ended

070922 19:11:10 mysqld started
/usr/libexec/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
070922 19:11:10 [ERROR] Aborting

070922 19:11:10 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:11:10 mysqld ended

070922 19:12:09 mysqld started
070922 19:12:09 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
070922 19:18:19 [Note] /usr/libexec/mysqld: Normal shutdown

070922 19:18:19 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:18:21 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:18:21 mysqld ended

070922 19:18:21 mysqld started
error: Found option without preceding group in config file: /etc/my.cnf at line: 15
Fatal error in defaults handling. Program aborted
070922 19:18:22 mysqld ended

070922 19:19:15 mysqld started
070922 19:19:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
070922 19:25:01 [Note] /usr/libexec/mysqld: Normal shutdown

070922 19:25:01 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:25:01 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:25:03 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:25:03 mysqld ended

070922 19:25:04 mysqld started
/usr/libexec/mysqld: File '/var/log/mysqld.index' not found (Errcode: 13)
070922 19:25:04 [ERROR] Aborting

070922 19:25:04 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:25:04 mysqld ended

070922 19:25:57 mysqld started
070922 19:25:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Reply With Quote
  #4  
Old 26th September 2007, 15:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

What's the output of
Code:
ls -l /var
and
Code:
ls -l /var/log
? I think it could be a permissions problem.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 26th September 2007, 16:29
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
Default

ok this is


Code:
Last login: Wed Sep 26 11:10:03 2007 from athedsl-258585.home.otenet.gr
[root@GTO003 ~]# ls -l /var
total 172
drwxr-xr-x  2 root root  4096 Jan 23  2007 account
drwxr-xr-x 11 root root  4096 Aug 20 19:04 cache
drwxr-xr-x  2 root root  4096 Aug 20 19:04 crash
drwxr-xr-x  2 root root  4096 Oct 29  2006 cvs
drwxr-xr-x  3 root root  4096 Aug 20 18:51 db
drwxr-xr-x  3 root root  4096 Aug 20 18:50 empty
drwxr-xr-x  2 root root  4096 Oct 11  2006 games
drwxr-xr-x 19 root root  4096 Aug 21 15:19 lib
drwxr-xr-x  2 root root  4096 Oct 11  2006 local
drwxrwxr-x  5 root lock  4096 Sep 26 05:10 lock
drwxr-xr-x  9 root root  4096 Sep 23 05:09 log
lrwxrwxrwx  1 root root    10 Aug 20 18:44 mail -> spool/mail
drwxr-x---  4 root named 4096 Aug 20 19:05 named
drwxr-xr-x  2 root root  4096 Oct 11  2006 nis
drwxr-xr-x  2 root root  4096 Oct 11  2006 opt
drwxr-xr-x  2 root root  4096 Oct 11  2006 preserve
drwxr-xr-x  2 root root  4096 Oct  1  2006 racoon
drwxr-xr-x 20 root root  4096 Sep 26 15:48 run
drwxr-xr-x 13 root root  4096 Aug 20 18:50 spool
drwxrwxrwt  2 root root  4096 Aug 21 18:05 tmp
drwxr-xr-x  6 root root  4096 Jun 26 16:11 www
drwxr-xr-x  3 root root  4096 May 10 15:33 yp
[root@GTO003 ~]# ls -l /var/log
total 38076
-rw-r----- 1 root  root      2219 Sep 19 23:21 acpid
-rw------- 1 root  root    101375 Aug 20 18:51 anaconda.log
-rw------- 1 root  root     26898 Aug 20 18:51 anaconda.syslog
-rw------- 1 root  root         0 Sep 23 05:09 boot.log
-rw------- 1 root  root         0 Sep 16 05:10 boot.log.1
-rw------- 1 root  root         0 Sep  9 05:09 boot.log.2
-rw------- 1 root  root         0 Sep  2 05:09 boot.log.3
-rw------- 1 root  root         0 Aug 26 05:09 boot.log.4
-rw------- 1 root  utmp  19238784 Sep 26 16:16 btmp
-rw------- 1 root  root    138223 Sep 26 16:20 cron
-rw------- 1 root  root    230473 Sep 23 05:08 cron.1
-rw------- 1 root  root    276878 Sep 16 05:10 cron.2
-rw------- 1 root  root    279695 Sep  9 05:08 cron.3
-rw------- 1 root  root    185262 Sep  2 05:08 cron.4
drwxr-xr-x 2 lp    sys       4096 Sep 23 05:09 cups
-rw-r--r-- 1 root  root     21376 Sep 19 23:18 dmesg
-rw------- 1 root  root       672 Aug 21 15:19 faillog
drwx------ 2 root  root      4096 Jun 26 16:11 httpd
-rw-r--r-- 1 root  root     22776 Sep 26 16:23 lastlog
drwxr-xr-x 2 root  root      4096 Aug 20 18:49 mail
-rw------- 1 root  root    304830 Sep 26 15:01 maillog
-rw------- 1 root  root    394856 Sep 23 05:09 maillog.1
-rw------- 1 root  root    338814 Sep 16 05:10 maillog.2
-rw------- 1 root  root    604735 Sep  9 05:09 maillog.3
-rw------- 1 root  root   1459745 Sep  2 05:09 maillog.4
-rw------- 1 root  root        47 Sep 23 05:09 messages
-rw------- 1 root  root    112630 Sep 19 22:57 messages.1
-rw------- 1 root  root    216010 Sep 14 17:50 messages.2
-rw------- 1 root  root        47 Sep  2 05:09 messages.3
-rw------- 1 root  root        47 Aug 26 05:09 messages.4
-rw-r----- 1 mysql mysql    25679 Sep 26 11:16 mysqld.log
drwx------ 2 root  root      4096 Dec  1  2006 ppp
drwxr-xr-x 2 root  root      4096 Aug 21 13:09 prelink
-rw-r--r-- 1 root  root     15022 Sep 26 05:12 rpmpkgs
-rw-r--r-- 1 root  root     15022 Sep 22 05:10 rpmpkgs.1
-rw-r--r-- 1 root  root     15022 Sep 15 05:10 rpmpkgs.2
-rw-r--r-- 1 root  root     15022 Sep  8 05:10 rpmpkgs.3
-rw-r--r-- 1 root  root     15022 Sep  1 05:50 rpmpkgs.4
drwx------ 2 root  root      4096 Jun  5 16:39 samba
-rw------- 1 root  root   1420814 Sep 26 16:23 secure
-rw------- 1 root  root   4264096 Sep 23 05:08 secure.1
-rw------- 1 root  root   2244942 Sep 16 03:56 secure.2
-rw------- 1 root  root   3002081 Sep  9 05:04 secure.3
-rw------- 1 root  root   3575088 Sep  2 03:10 secure.4
-rw------- 1 root  root         0 Sep 23 05:09 spooler
-rw------- 1 root  root         0 Sep 16 05:10 spooler.1
-rw------- 1 root  root         0 Sep  9 05:09 spooler.2
-rw------- 1 root  root         0 Sep  2 05:09 spooler.3
-rw------- 1 root  root         0 Aug 26 05:09 spooler.4
-rw------- 1 root  root         0 Aug 20 18:59 tallylog
drwxr-xr-x 2 root  root      4096 Jul 19  2006 vbox
-rw-rw-r-- 1 root  utmp     87936 Sep 26 16:23 wtmp
-rw-rw-r-- 1 root  utmp     38016 Aug 31 12:31 wtmp.1
-rw-r--r-- 1 root  root     12191 Aug 21 18:05 yum.log
[root@GTO003 ~]#
[root@GTO003 ~]#
Reply With Quote
  #6  
Old 27th September 2007, 16:01
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Please try this:
Code:
mkdir /var/log/mysql
touch /var/log/mysql/mysql-bin.log
chown -R mysql:mysql /var/log/mysql
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
mysql replication issues Jamesk5 Server Operation 8 23rd September 2006 14:40
MySQL Replication neil6179 Server Operation 1 12th September 2006 15:50
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 06:18.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.