Results 1 to 5 of 5

Thread: mysql.server is not running - ZCS 7 on Ubuntu 10.04

  1. #1
    jernej is offline New Member
    Join Date
    Feb 2011
    Posts
    3
    Rep Power
    4

    Default mysql.server is not running - ZCS 7 on Ubuntu 10.04

    Hello,

    I made a fresh install of Ubuntu server 10.04 (64bit) as a KVM virtual machine.
    I installed only base system and needed libraries for zimbra.
    Then I installed ZCS 7 and everything went smooth...
    The problem is when I ckeck the zmcontrol staus I get:

    mailbox Stopped
    mysql.server is not running.

    If I do ps au | grep msql i get this:

    zimbra 1744 0.0 0.0 4112 668 ? S 10:00 0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --external-locking --log-error=/opt/zimbra/log/mysql_error.log --ledir=/opt/zimbra/mysql/libexec
    zimbra 1911 0.1 4.2 862184 87056 ? Sl 10:00 0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --external-locking --log-error=/opt/zimbra/log/mysql_error.log --pid-file=/opt/zimbra/db/mysql.pid --socket=/opt/zimbra/db/mysql.sock --port=7306
    root 3752 0.0 0.0 7628 988 pts/0 S+ 10:05 0:00 grep --color=auto mysql

    I'm a bit lost.... Can please someone point me to the right direction? Many thanks!

    Jernej

  2. #2
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,585
    Rep Power
    57

    Default

    Quote Originally Posted by jernej View Post
    I'm a bit lost.... Can please someone point me to the right direction? Many thanks!
    The information you've posted tells us nothing other than a service isn't running, look in the log files and see what errors are there when you try and start Zimbra.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    jernej is offline New Member
    Join Date
    Feb 2011
    Posts
    3
    Rep Power
    4

    Default mysql.server running, but zimbra can't authenticate

    Quote Originally Posted by phoenix View Post
    The information you've posted tells us nothing other than a service isn't running, look in the log files and see what errors are there when you try and start Zimbra.
    I have checked the log files and it seems that mysql is running under user zimbra. What i found in mailbox.log is a bunch of errors like:

    Caused by: java.sql.SQLException: Access denied for user 'zimbra'@'localhost' (using password: YES)

    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC onnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

    Caused by: java.net.ConnectException: Connection refused

    I tried to connect manually to mysql zserver using zimbra user and zimbra password, but i get the
    ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)

    I also tried to run "mysqld_safe --skip-grant-tables" to try to reset the password, but it doesn't play that way...

    Any help would be appreciated. Thank you in advance!

    Jernej

  4. #4
    kashifali is offline Junior Member
    Join Date
    Oct 2009
    Location
    Toronto
    Posts
    8
    Rep Power
    5

    Default

    try this
    as [zimbra] shutdown zimbra " zmcontrol stop"
    then as root run, chown -R zimbra:zimbra /opt/zimbra

    then [as zimbra usera] start zimbra " zmcontrol start"

    hope it helps
    -kashif

  5. #5
    jernej is offline New Member
    Join Date
    Feb 2011
    Posts
    3
    Rep Power
    4

    Default

    Thank you Kashifali for your suggestion. I did what you said (and indeeed there were some folders inside /opz/zimbra/ that were owned by root:root and others by zimbra:zimbra) but unfortunately when I start zimbra (zmcontrol start) I still get the
    mailbox Stopped
    mysql.server is not running.
    I think that mysql server is actually running, but there is something wrong with authentication. If I run:
    Code:
    zimbra@mailserver:~$ mysql -u root -p
    and put in password "zimbra", I get
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    Walking in dark. Any suggestion or hint is appreciated!

    Jernej

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 02-18-2011, 03:49 PM
  2. zmmailboxdctl is stopped frequently..
    By tamilnandhu in forum Installation
    Replies: 13
    Last Post: 04-12-2008, 08:59 AM
  3. Replies: 4
    Last Post: 11-14-2007, 02:19 PM
  4. Replies: 41
    Last Post: 10-29-2007, 02:36 PM
  5. Trouble sending mail from Outlook
    By czaveri in forum Users
    Replies: 15
    Last Post: 07-24-2006, 11:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •