Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Upgrading from 7.718 to 7.727 in Centos Pandora ISO.
#7
(10-03-2018, 12:07 PM)alberto.sanchez Wrote:
(10-03-2018, 07:14 AM)saleh Wrote:
(10-02-2018, 11:34 AM)alberto.sanchez Wrote:
(10-01-2018, 09:47 AM)saleh Wrote:
(10-01-2018, 09:00 AM)alberto.sanchez Wrote: Good morning saleh,

As we can see first off all, next time try to start the Pandora server before you start de agent.

Secondly, we can see in the logs that the problem is in the connection of the server with the database. Can you please try to log in the database with the credentials of the .conf of the server?

Best regards,

Alberto

I cant login to DB, strange, I was able to; before the upgrade!, now I'm getting this error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Good morning saleh,

There are 2 possible solutions to your problem:

1- Install Pandora 727 with the ISO, doing a previous backup of the different ".conf" that you can use after.
2- Try to log to the database with: user->root pass->pandora. If this makes you access to the database, you only have to  change that info in the .conf of the server anc config.php. Remember to start the services with this order:
  • Mysql
  • Httpd(apache)
  • Console
  • Pandora Server
  • Pandora Agent.
Best regards,

Alberto

I can't log in using root in 727.

Let me back a little bit, first I had production server running 718, using Pandora Docs, I backed up everything, alongside the DB; like so:
mysqldump -u root -p pandora > backup_pandora_X.Y.sql
Note: notice using root to login.
on lap running 2 vms, first 718, i restored the DB to it and upgraded to 727, second vm; 727 i directly restored the DB to it.
in booth cases pandora server gives errors, furthermore, i changed DB username to root in both vm, still getting error, changes made in config.php and pandora_server.conf.
Note: how to stop and start the console??

Good morning saleh,

Sometimes the DB only creates the user wit "root" and no pass, please try it that way and tell us how did it go.

P.D: It was a failure telling you about the start and stop of the console, there is no actions like that. Sorry

Alberto

on booth 718 and 727 and on fresh installed iso and the ones that has DB recovered, strange i guess its always: pandora,pandora for mysql login.

[[email protected] ~]# mysql -n root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
 Reply

(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes