Author Topic: Can not connect to MySQL  (Read 11047 times)

Chris Computing

  • Sr. Member
  • ****
  • Posts: 25
Can not connect to MySQL
« on: September 11, 2013, 10:17:46 PM »
When the Qube supervisor starts up I get this:

Supervisor time offset with client unspecified. Defaulting to 0.
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'

Any ideas?

jburk

  • Administrator
  • *****
  • Posts: 493
Re: Can not connect to MySQL
« Reply #1 on: September 11, 2013, 10:44:19 PM »
It seems that the issue isn't actually an inability to connect to the MySQL database, it's
a more basic inability to connect to the supervisor host at all.

    Unable to retrieve the configuration from the supervisor.  Is it down?

Is there a supervisor running on the host "ren-supervisor.exp.edu" ?

Can you ping that host from your workstation?

Chris Computing

  • Sr. Member
  • ****
  • Posts: 25
Re: Can not connect to MySQL
« Reply #2 on: September 11, 2013, 11:56:52 PM »
Ya, that computer i got that from is the supervisor itself.

[attachment deleted by admin]
« Last Edit: September 12, 2013, 12:02:05 AM by Chris Computing »

jburk

  • Administrator
  • *****
  • Posts: 493
Re: Can not connect to MySQL
« Reply #3 on: September 12, 2013, 01:47:56 AM »
Is the Qube supervisor service running on that host?

Try qbping -supe localhost

Chris Computing

  • Sr. Member
  • ****
  • Posts: 25
Re: Can not connect to MySQL
« Reply #4 on: September 12, 2013, 04:51:24 PM »
Yes. That's the server it runs on.