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.....
     
    #1 cpane1, Sep 16, 2007
  2. cPanelKenneth

    cPanelKenneth cPanel Development Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,574
    Likes Received:
    46
    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...
     
    #3 cpane1, Sep 19, 2007
  4. cPanelKenneth

    cPanelKenneth cPanel Development Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,574
    Likes Received:
    46
    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:
    551
    Likes Received:
    2
    Trophy Points:
    168
    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:
    551
    Likes Received:
    2
    Trophy Points:
    168
    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,574
    Likes Received:
    46
    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
     
    #8 cpane1, Sep 24, 2007
(You must log in or sign up to post here.)
Loading...
Similar Threads - eximstats clustered mysql
  1. Raymond Hayes

    SOLVED Backup services and Eximstats Database

    Raymond Hayes, May 6, 2019, in forum: Database Discussion
    Replies:
    7
    Views:
    162
    cPanelLauren
    May 20, 2019 at 9:57 AM
  2. MrJingles

    SOLVED Querying the Eximstats database - file is encrypted or is not a database

    MrJingles, Feb 18, 2019, in forum: Database Discussion
    Replies:
    7
    Views:
    330
    cPanelMichael
    Apr 16, 2019
  3. Kamil Brand Nova

    SOLVED [CPANEL-22678] eximstats_spam_check errors

    Kamil Brand Nova, Nov 28, 2018, in forum: Security
    Replies:
    3
    Views:
    737
    cPanelMichael
    Dec 29, 2018
  4. goodmove

    Question about eximstats_spam_check

    goodmove, Aug 27, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    228
    cPanelLauren
    Aug 27, 2018
  5. stbolen

    /var/cpanel/eximstats_db.sqlite3 size issue

    stbolen, Aug 7, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    918
    cPanelLauren
    Aug 8, 2018

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