Page 3 of 3 FirstFirst 123
Results 21 to 25 of 25

Thread: Logger

  1. #21
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Howdy,
    I tried to run logmysql.server start with grant tables.

    [root@tusd-exch01 zcs]# Starting mysqld daemon with databases from /var/lib/mysql
    STOPPING server from pid file /var/run/mysqld/mysqld.pid
    060330 12:58:50 mysqld ended


    So, I thought I'd take a look at the mysqld.log

    060330 12:58:49 mysqld started
    060330 12:58:50 [ERROR] /opt/zimbra/logger/mysql/bin/mysqld: unknown variable 'defaults-file=/opt/zimbra/conf/my.logger.cnf'

    060330 12:58:50 mysqld ended

    So I decided to look at the my.logger file.

    Code:
    [mysqld]
    
    basedir      = /opt/zimbra/logger/mysql
    datadir      = /opt/zimbra/logger/db/data
    socket       = /opt/zimbra/logger/db/mysql.sock
    pid-file     = /opt/zimbra/logger/db/mysql.pid
    bind-address = localhost
    port         = 7307
    
    skip-external-locking
    
    log-slow-queries = /opt/zimbra/log/logger_myslow.log
    long-query-time  = 1
    log-long-format
    log-queries-not-using-indexes
    log-bin
    
    thread_cache      = 10
    max_connections   = 10
    
    # We do a lot of writes, query cache turns out to be not useful.
    query_cache_type = 0
    
    [mysqld_safe]
    
    err-log = /opt/zimbra/log/logger_mysqld.log
    Does this log look correct?

    thx

  2. #22
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    Did you try to start it as root?
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  3. #23
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    The way noted above is as root. Should I try as Zimbra?

  4. #24
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Can someone post their my.logger.cnf file?

    thanks

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

    Default

    What you've posted above is what I have in my.logger.cnf
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Page 3 of 3 FirstFirst 123

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 28
    Last Post: 05-21-2008, 12:04 PM
  2. logger stopped by itself
    By zzzzsg in forum Administrators
    Replies: 23
    Last Post: 08-15-2007, 03:55 PM
  3. logger installed twice
    By bowergo in forum Installation
    Replies: 1
    Last Post: 03-24-2007, 12:48 PM
  4. Logger not working in 4.0 RC1
    By jdell in forum Administrators
    Replies: 11
    Last Post: 08-24-2006, 07:50 PM
  5. Replies: 18
    Last Post: 03-20-2006, 02:22 PM

Posting Permissions

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