Re: AssertException: Failed to start connection pool

[Zippy Zeppoli]

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

mysql>         SHOW GRANTS FOR 'mmonit'@'127.0.0.1'
    -> ;
+---------------------------------------------------------------------------------------------------------------+
| Grants for address@hidden                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mmonit'@'127.0.0.1' IDENTIFIED BY PASSWORD '*123' |
| GRANT ALL PRIVILEGES ON `monit`.* TO 'mmonit'@'127.0.0.1'                                                     |
+---------------------------------------------------------------------------------------------------------------+
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:

Hello,

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 127.0.0.1):

        SHOW GRANTS FOR 'mmonit'@'127.0.0.1'

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 127.0.0.1):
    GRANT ALL ON mmonit.* to address@hidden identified by '<password>'

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


Regards,
Martin

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'@'127.0.0.1' 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:
> https://lists.nongnu.org/mailman/listinfo/monit-general


--
To unsubscribe:
https://lists.nongnu.org/mailman/listinfo/monit-general