Re: AssertException: Failed to start connection pool

[Zippy Zeppoli]

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 0.0.0.0:3306                0.0.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 (127.0.0.1) => 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?

Yes

Regards,

Martin

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'@'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

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

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