Centova Technologies Forum
Centova Cast v3 => Bugs and issues => Topic started by: zoomradio on January 21, 2014, 05:08:00 am
-
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.....