I'm running Pandora 4.02 on Ubuntu server 12.04 and all of my devices instead of showing the blue bar displaying the time for the next contact agent show a red field that says "out of limits". Not sure whats the issue. I read some about it and i thought it would be link to the timestamp depencies on the server but all of that its install in the pandora server. I would really appreciate any contribution. Thanks before hand and God Bless.
"next contact agent" -out of limits issue-
gabriel-m · 13 nov 2012, 0:15 · 17 mensajes · 58 visitas
- Inicio del debate
2012-09-19 09:57:00 pandora [V1] Pandora FMS Server 'pandora' unhandled error. 2012-09-19 10:10:48 pandora [V1] Launching 4.0.2 120626 2012-09-19 10:10:48 pandora [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 1, Server Threshold at 5 sec, verbosity at 1, Alert Threshold at 60, ServerName is 'pandora' 2012-09-19 10:10:48 pandora [V1] [E] 'pandora': DBI connect('pandora:localhost:3306','pandora',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/lib/perl5/PandoraFMS/DB.pm line 86 2012-09-19 09:56:59 - pandora Starting Pandora FMS Server. Error logging activated. DBI connect('pandora:localhost:3306','pandora',...) failed: Access denied for user 'pandora'@'localhost' (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 86 2012-09-19 10:10:48 - pandora Starting Pandora FMS Server. Error logging activated. DBI connect('pandora:localhost:3306','pandora',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/lib/perl5/PandoraFMS/DB.pm line 86
Hi Gabriel M. It seems that Pandora FMS can not access mysql server. Run the next command:
# cat /etc/pandora_server/pandora_server.conf | grep dbNow, access to mysql server:
# msyql -uroot -pAnd create a new user with the data above: mysql> GRANT ALL PRIVILEVES ON dbname.* TO 'dbuser'@'localhost' identified by 'dbpass'; Try to start Pandora FMS server:
# /etc/init.d/pandora_server startTest if the agents start reporting. Cheers.
I did exactly what you suggested and still no luck, i just looked at the server log again and stills say the same thing about access denied. Since I installed the last time it always show the agent information check the picture name "CCA NMS" in the attachment but in the main console the time is it right. do you think the issue is related?
[

](//pandorafms.com/community/media/forum/0/14072=314-CCA-NMS.png)
[

](//pandorafms.com/community/media/forum/0/14072=315-Console-nms.png)
Hi Gabriel M. Paste the output of this command:
# cat /etc/pandora_server/pandora_server.conf | grep dbAnd the output of:
mysql -u_dbuser_ -p_dbpass_ dbname -h dbhost
Thank you.
here are the screen-shots from my terminal
[

](//pandorafms.com/community/media/forum/0/14079=316-cat-Command.png)
[

](//pandorafms.com/community/media/forum/0/14079=317-grantoutput.png)
Hi, Now, try to connect mysql in this way:
mysql -upandora -pplcvdkgr nsm -h localhostAnd paste its output, please.
Hello Gabriel, There is a mistake in the mysql connect command. Rename database name nsm to nms. Check if pandora_server.conf has the same problem (dbname), and try to start it again:
# /etc/init.d/pandora_server startRegards.
Yeah i noticed the typo to late..sorry about that
[

](//pandorafms.com/community/media/forum/0/14087=321-Mysql-pandora-user.png)
Fine... Then, is pandora_server started?
I check the server config file and everything seems fine, i also restart the server with # /etc/init.d/pandora_server restart and it says that is running
[

](//pandorafms.com/community/media/forum/0/14090=320-pandora-svr_config.png)
sorry if im posting to many screenshots, but this fail error keeps showing in the audit, do you think is related? failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
[

](//pandorafms.com/community/media/forum/0/14091=322-Pandora-FMS-log.png)
But these log lines are from September, If /etc/init.d/pandora_server start works fine, then you have pandora server running. It returns a valid PID number? You could see server status in web console, clicking in Systems: Ready Cheers.
Oh My God It work, i feel so dumb we were focusing the the wrong issue. Let me break it down and yes if it wasnt for your help i wouldnt havent been able to solve this issue. 1.The main issue i was having was the red label that said contact out of limits every time i clicked on the agent. 2. I didnt realize the date of the server logs were old. when i scrolled down the logs showed real issue. 3. And Finally, the whole red label was a setup issue in the web console. Under Administration/setup there is a time zone, Im on selma Alabama and the console comes with a Berlin time zone as default. So all i had to do is change it to " America/Chicago" and the display for contacting the next agent is working perfectly. Thank you so much Mr. Luismi (admin) and I feel like i was wasting your time. Im so sorry
[

](//pandorafms.com/community/media/forum/0/14094=323-out-of-limit.png)
[

](//pandorafms.com/community/media/forum/0/14094=324-logs.png)
[

](//pandorafms.com/community/media/forum/0/14094=325-Pandora-timezone.png)
[

](//pandorafms.com/community/media/forum/0/14094=326-agent-time.png)
Don't worry Gabriel, Im so happy you have found the problem and solve it. Now you have Pandora FMS working like a charm. Cheers.
yes, Pandora is an awesome software, my boss made me try quite a few but non of them really compare to it. And i have to straight out a lil detail with SNMP, but yes for the most is working like a clock work. Thanks y arriva Espana!
Thank you Gabriel!!! We always try to do things better.
Entra en tu cuenta para publicar.











