Hi

Today we have this problem.. :

 Fatal error: Uncaught exception 'Exception' with message 'Could not connect to database: Connection refused' in /usr/local/centovacast/system/class_CCSQL.php:32 Stack trace: #0 /usr/local/centovacast/system/class_CCSQL.php(32): CCSQL::__construct() #1 /usr/local/centovacast/web/login/index.php(39): CCSQL->__construct() #2 {main} thrown in /usr/local/centovacast/system/class_CCSQL.php on line 32

Someone help me ?

Thanks !

It looks like your database problem, NOT Centova Cast,

Check that your database is up and running, and see if login details are correct.

What type of database do you use ?

Hi,

i don't know

We have paid for installation in december 2013 with centova because we can't do that....

All work since december but know.. no... and we can't understand why...

we have found this :

===== Centova Cast version API call ===================================================

Fatal error: Uncaught exception 'Exception' with message 'Could not connect to database: Connection refused' in /usr/local/centovacast/system/class_CCSQL.php:32
Stack trace:
#0 /usr/local/centovacast/system/class_CCSQL.php(32): CCSQL::__construct()
#1 /usr/local/centovacast/system/ccmanage.php(82): CCSQL->__construct()
#2 {main}
  thrown in /usr/local/centovacast/system/class_CCSQL.php on line 32

Is MYSQL running? Could you have rebooted your server and it not automatically started?

try running
/etc/init.d/mysqld restart
OR IF WON'T START
sudo service mysql start   

If the server is not set to automatically start MYSQL on boot I think the below command should correct that
chkconfig --level 2345 mysqld on

Hi

i have this message

Stopping mysqld:                                           [  OK  ]
Another MySQL daemon already running with the same unix socket.
Starting mysqld:                                           [FAILED]


and if i try start or restart centova this :

/etc/init.d/centovacast start
Starting Centova Cast: cc-control Invalid option: -F
Usage: /usr/local/centovacast/sbin/cc-control [options]

Control server options:
  -b ADDR  bind to IP address ADDR
  -c NUM   set concurrent connection limit to NUM
  -g GROUP run as group GROUP
  -i NUM   set per-IP connection limit to NUM
  -o       disable chroot
  -p PORT  bind to port PORT
  -u USER  run as user USER

Advanced options:
  -D       ignore DNS resolution failures at startup

General options:
  -f       foreground operation (do not daemonize)
  -l KEY   set license key for this daemon to KEY
  -m FILE  specify the path for the master log
  -r PATH  specify root path
  -s FILE  write PID to FILE; enforce single instance
  -v[v...] increase verbosity
  -V       display version number
- failed

Please run

ps aux|grep mysql ....
if you see something like
[root@HunPoFo ~]# ps aux|grep mysql
root     14751  0.1  0.0 108172  1600 pts/0    S    17:11   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql    14969  0.5  0.2 572460 41596 pts/0    Sl   17:11   0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock

Then mysql is running and is there is another issue with the server...

If you see'

[root@HunPoFo ~]# ps aux|grep mysql
root     15064  0.0  0.0 103248   844 pts/0    S+   17:12   0:00 grep mysql

run rm -rf /var/lib/mysql/mysql.sock and then service mysqld start


This should clear up the issue

hi


i have try this and nothing...

and after i try  restart and :


 /etc/init.d/centovacast restart                             Stopping Centova Cast: cc-ftpd (not running) cc-web (not running) cc-appserver (not running) cc-control (not running) cc-imaged (not running)
Starting Centova Cast: cc-control Invalid option: -F
Usage: /usr/local/centovacast/sbin/cc-control [options]

Control server options:
  -b ADDR  bind to IP address ADDR
  -c NUM   set concurrent connection limit to NUM
  -g GROUP run as group GROUP
  -i NUM   set per-IP connection limit to NUM
  -o       disable chroot
  -p PORT  bind to port PORT
  -u USER  run as user USER

Advanced options:
  -D       ignore DNS resolution failures at startup

General options:
  -f       foreground operation (do not daemonize)
  -l KEY   set license key for this daemon to KEY
  -m FILE  specify the path for the master log
  -r PATH  specify root path
  -s FILE  write PID to FILE; enforce single instance
  -v[v...] increase verbosity
  -V       display version number
- failed

Stupid question have you tried updating the control panel ? By running /usr/local/centovacast/sbin/update in command line?

Fatal error: Uncaught exception 'Exception' with message 'Could not connect to database: Connection refused'

Headshaker's response is 100% correct.  This definitely and unequivocally means that MySQL is not running or is (for some other reason) not accepting connections. 

No matter how many times you restart Centova Cast it's not going to fix this because this has nothing to do with Centova Cast; the problem is with MySQL.

Starting Centova Cast: cc-control Invalid option: -F
Usage: /usr/local/centovacast/sbin/cc-control [options]

This is a different and completely unrelated issue; it seems you have somehow done a partial upgrade to 3.0.6. (Maybe the upgrade failed halfway through?  Perhaps it failed *because* of the MySQL problem above?)

In any case, you need to get MySQL running again (and to be clear: you MUST get MySQL running FIRST), and then run /usr/local/centovacast/sbin/update again to finish upgrading Centova Cast.

problem solved with :

stop and start mysql
update centova
restart centova.....