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? Regards, Martin On Aug 6, 2012, at 11:32 PM, Zippy Zeppoli <zippyzepp...@gmail.com> wrote: > Something else going on. > Could this happen due to a wrong license? > > mysql> SHOW GRANTS FOR 'mmonit'@'127.0.0.1' > -> ; > +---------------------------------------------------------------------------------------------------------------+ > | Grants for mmonit@127.0.0.1 > | > +---------------------------------------------------------------------------------------------------------------+ > | 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 <mart...@tildeslash.com> 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 mmonit@localhost 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 <zippyzepp...@gmail.com> 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
