Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

eximstats and clustered mysql server

Discussion in 'Bind/DNS/Nameserver' started by cpane1, Sep 16, 2007.

  1. cpane1

    cpane1 Well-Known Member

    Joined:
    Jun 10, 2007
    Messages:
    56
    Likes Received:
    0
    Trophy Points:
    156
    Hello,

    okay, this is a bit strange issue....

    scenario:

    2 servers, one is the remote mysql server for another...

    server1 has been set up with a remote mysql server with server2

    now, when we try and update stats for a particular client on server1 we get the below error.

    =============================================================

    root@server1 [/tmp]# /scripts/runweblogs joelgj
    Log checker loaded ok..
    cpbandwd is already running.
    (internal warning while parsing ) Sun Sep 16 15:23:03 2007 [5171] warn: DBI connect('eximstats:"server2 IP"','eximstats',...) failed: Unknown MySQL server host '"server2 IP"' (1) at /usr/local/cpanel/cpanellogd line 1145
    at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBI.pm line 652
    DBI::__ANON__('undef', 'undef') called at /usr/lib/perl5/site_perl/5.8.8/i686-linux/DBI.pm line 706
    DBI::connect('DBI', 'DBI:mysql:eximstats:"server2 IP"', 'eximstats', 'undef') called at /usr/local/cpanel/cpanellogd line 1145
    main::dbconnect() called at /usr/local/cpanel/cpanellogd line 177


    (internal warning while parsing ) Sun Sep 16 15:23:03 2007 [5171] warn: Can not connect at /usr/local/cpanel/cpanellogd line 1147.
    at /usr/local/cpanel/cpanellogd line 1147
    main::dbconnect() called at /usr/local/cpanel/cpanellogd line 177


    [an error occurred while processing this directive][an error occurred while processing this directive]Processing joelgj...
    Run Logs domain: domainname.com BW Limit: 26214400000 Domains: [domainname.com]
    Update status for /var/cpanel/bandwidth/joelgj-http.rrd: (42)
    Update status for /var/cpanel/bandwidth/joelgj-all.rrd: (42)
    WEBLANG english
    Archive Status: 0
    About to fork for joelgj [ALL DOMAINS: domainname.com]
    Complete


    ==============================================================

    one of many questions:
    the eximstats uses the /root/.my.cnf file for the mysql server details which on our server happens to be the remote server entries... is this correct ? does the eximstats user connect to the remote server ?

    in short who to resolve this issue..

    Please help.....
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 cpane1, Sep 16, 2007
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    42
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    It does use /root/.my.cnf to connect to the remote host. Is there a corresponding eximstats database on the remote MySQL server? Does the eximstats user on the local cPanel server have sufficient rights on the remote MySQL server? Try the following code as a test script:

    Code:
    #!/usr/bin/perl

use strict;
use warnings;
use DBI;

my $db = DBI->connect("DBI:mysql:mysql:__IP_ADDRESS__", 'eximstats', __EXIMSTATS_PWORD__ );
    Replace the placeholders (e.g. __IP_ADDRESS__) with your particular configuration. YOu can find the password for eximstats in /var/cpanel/eximstatspass
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelKenneth, Sep 17, 2007
  3. cpane1

    cpane1 Well-Known Member

    Joined:
    Jun 10, 2007
    Messages:
    56
    Likes Received:
    0
    Trophy Points:
    156
    Hello,

    Sorry been so late to this....but yes, there is a remote eximstats database (database is located on both the servers) with the same password....

    I will try connecting using the test script supplied, but can you confirm that where should I use this script on ? Server1 or server2 ?

    Also will upcp --force resolve the issue ? is there any script that I can use to resolve this issue...

    Many thanks for your reply...
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cpane1, Sep 19, 2007
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    42
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    If server1 is the remote MySQL server, and server2 is the local cPanel user, then run the test script on server2.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelKenneth, Sep 19, 2007
  5. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    532
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Brno, Czech Republic
    i have the same issue.

    i modified the /var/cpanel/eximstatspass on the front end servers to the password from the /var/cpanel/eximstatspass on the db server, but it still says failed. i will see with remote hosts . maybe that's the culprit
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 katmai, Sep 20, 2007
  6. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    532
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Brno, Czech Republic
    yes so it seems. besides the hostname which is added in the privileges, add the ips of the front end servers with the same privileges to the eximstats . careful not to change the password.


    now it works.


    UPDATE: it doesn't work. still failed. is it possible to see some eximstats log? or to see where is it trying to connect to?

    UPDATE2 : it started working by some miracle lol.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 katmai, Sep 20, 2007
    Last edited: Sep 20, 2007
  7. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    42
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    eximstats is in /usr/local/cpanel/bin

    You can run it manualy with --debug, but I usually add my own debugging code for better reporting.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 cPanelKenneth, Sep 20, 2007
  8. cpane1

    cpane1 Well-Known Member

    Joined:
    Jun 10, 2007
    Messages:
    56
    Likes Received:
    0
    Trophy Points:
    156
    Hi every one,

    In response to my initial query I got the issue resolved. I got the entry for the remote mysql server host IP commented in the /root/.my.cnf file. After doing this, I was able to run the /script/runweblog script successfully without any error messages for the user.



    Thank you so much "cpanelkenneth" for looking into this for me. Much appreciated.

    cpane1
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cpane1, Sep 24, 2007
(You must log in or sign up to post here.)
Loading...
Similar Threads - eximstats clustered mysql
  1. stbolen

    /var/cpanel/eximstats_db.sqlite3 size issue

    stbolen, Aug 7, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    56
    cPanelLauren
    Aug 8, 2018
  2. ruiz

    Change eximstats_spam_check in crontab

    ruiz, Jul 29, 2018, in forum: E-mail Discussion
    Replies:
    3
    Views:
    68
    cPanelMichael
    Aug 2, 2018
  3. smartrange

    warn [eximstats_spam_check]

    smartrange, May 24, 2018, in forum: E-mail Discussion
    Replies:
    6
    Views:
    211
    cPanelLauren
    Jun 5, 2018
  4. swbrains

    SOLVED [CPANEL-20345] eximstats_spam_check cron job always sends root notification

    swbrains, Apr 2, 2018, in forum: E-mail Discussion
    Replies:
    14
    Views:
    1,150
    cPanelMichael
    Aug 7, 2018
  5. rinkleton

    Maintenance ended due to eximstats error

    rinkleton, Nov 14, 2017, in forum: General Discussion
    Replies:
    5
    Views:
    473
    cPanelMichael
    Nov 21, 2017

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice