Re: AssertException: Failed to start connection pool

[Martin Pala]

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