Author Topic: Unable to connect to the MySQL sever  (Read 3566 times)

Chris Computing

  • Sr. Member
  • ****
  • Posts: 25
Unable to connect to the MySQL sever
« on: January 12, 2013, 01:39:01 AM »
Upgraded the Qube GUI, Core, and Supervisor on our supervisor server for Qube.
Now when I launch the Qube icon on the desktop this is what I get. Please help!

Testing connection to the DataWarehouse server: user=qube_readonly, host=
Unable to retrieve the configuration from the supervisor.  Is it down?
qb.supervisorconfig() function not available to query qb_supervisor, reverting to scanning C:\ProgramData\Pfx\Qube\qb.conf
qb.supervisorconfig() function not available to query database_port, reverting to scanning C:\ProgramData\Pfx\Qube\qb.conf
Unable to determine database port
Unable to connect to the MySQL sever on host ren-supervisor.exp.edu
Cannot connect to Qube DataWarehouse MySQL database, charting is disabled.
Disabling "ALL items" automatic refresh timer.
Disabling "SELECTED items" automatic refresh timer.
Unable to retrieve the configuration from the supervisor.  Is it down?
qb.supervisorconfig() function not available to query qb_supervisor, reverting to scanning C:\ProgramData\Pfx\Qube\qb.conf
qb.supervisorconfig() function not available to query database_port, reverting to scanning C:\ProgramData\Pfx\Qube\qb.conf
Unable to determine database port
Unable to connect to the MySQL sever on host ren-supervisor.exp.edu
Cannot directly connect Supervisor MySQL database, so all queries will go through Supervisor. 'NoneType' object has no attribute 'get_host_info'
Unable to retrieve user permission values
MySQLdb and/or qb.query modules not loaded or previous connection attempt failed.
Unable to efficiently determine the total job count, "Total in Qube" will be displayed as "n/a".

jburk

  • Administrator
  • *****
  • Posts: 484
Re: Unable to connect to the MySQL sever
« Reply #1 on: January 12, 2013, 01:41:52 AM »
Was your supervisor running when you started the QubeGUI?  Can you get an answer back from QubeGUI->Admin->Ping Supervisor?

Is your supervisor still on ren-supervisor.exp.edu?

Chris Computing

  • Sr. Member
  • ****
  • Posts: 25
Re: Unable to connect to the MySQL sever
« Reply #2 on: January 12, 2013, 02:29:05 AM »
The attached is what i get when i ping. The supervisor is still on ren-supervisor.exp.edu

Thank you for your continuing help, it's very greatly appreciated (very very).

[attachment deleted by admin]