[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: AssertException: Failed to start connection pool

From: Zippy Zeppoli
Subject: Re: AssertException: Failed to start connection pool
Date: Mon, 6 Aug 2012 16:08:26 -0700

In other words this is a completely different, independant server/mysql instance/mmonit install.

On Mon, Aug 6, 2012 at 4:07 PM, Zippy Zeppoli <address@hidden> wrote:
Hmm, looks like it's listening on all, definitely not a good practice, but should still work nonetheless:
tcp        0      0      *                   LISTEN      2671/mysqld        

I do have a dedicated instance on this host, mmonit isn't pointing anywhere else.

           <Realm url="" href="http://mmonit:address@hidden/mmonit" target="_blank">mmonit:address@hidden/mmonit"

On Mon, Aug 6, 2012 at 3:18 PM, Martin Pala <address@hidden> wrote:
The license problem would throw different error … the error message is related to MySQL reject.

You have mentioned that this is the second instance of M/Monit - the first one is running on different host OK. According to the message M/Monit is configured to use MySQL on localhost ( => you should have independent MySQL instance running on each host.
Is the "SHOW GRANTS" output from the same MySQL instance/host where M/Monit throws error or is it from the first host, where M/Monit is running already?



On Aug 6, 2012, at 11:32 PM, Zippy Zeppoli <address@hidden> wrote:

Something else going on.
Could this happen due to a wrong license?

mysql>         SHOW GRANTS FOR 'mmonit'@''
    -> ;
| Grants for address@hidden                                                                                   |
| GRANT ALL PRIVILEGES ON `monit`.* TO 'mmonit'@''                                                     |
2 rows in set (0.00 sec)

mysql> use mmonit
Database changed
mysql> show tables;
| Tables_in_mmonit  |
| actionrow         |
| event             |
| eventnotice       |
| groupedhost       |
| groupedservices   |
| host              |
| hostgroup         |
| jabberserver      |
| mailserver        |
| message           |
| messageformat     |
| messagequeue      |
| messagerecipients |
| mmonit            |
| name              |
| roles             |
| rule              |
| rulerow           |
| service           |
| servicegroup      |
| session           |
| userroles         |
| users             |
23 rows in set (0.00 sec)

On Fri, Aug 3, 2012 at 5:01 AM, Martin Pala <address@hidden> wrote:

you can verify the permissions this way (do it on the mysql instance which is running on the same machine as M/Monit, as the message hints that M/Monit is connecting via

        SHOW GRANTS FOR 'mmonit'@''

Also verify that the mmonit database exists on this mysql instance.

To create the database and user:

 1) Create the mmonit database: mysqladmin create mmonit -u root -p

 2) Create the mmonit user and grant access to the mmonit database, for example if the database server is running on the same machine as M/Monit (connecting via
    GRANT ALL ON mmonit.* to address@hidden identified by '<password>'

 3) Create the schema: mysql -u mmonit mmonit -p < mmonit-schema.mysql


On Aug 3, 2012, at 5:35 AM, Zippy Zeppoli <address@hidden> wrote:

> Hi List,
> I have a working mmonit configuration on another server, but when I try to replicate the same configuration to a copy, I get the following problem.
> var/lib/mmonit/bin/mmonit -i -c /var/lib/mmonit/conf/server.xml -d
> Start parsing the server xml file
> AssertException: Failed to start connection pool -- Access denied for user 'mmonit'@'' to database 'mmonit'
>  -- in '/var/lib/mmonit-2.4/conf/server.xml' near line 198
>  raised in Build_parse at src/kernel/Build.c:197'
> Strange thing is that I am able to connect to mysql just fine using those credentials.
> Thanks in advance,
> Z
> --
> To unsubscribe:

To unsubscribe:

To unsubscribe:

To unsubscribe:

reply via email to

[Prev in Thread] Current Thread [Next in Thread]