I reboot my server and now I am getting this error


Fatal error: Uncaught exception 'Exception' with message 'Could not connect to database: No such file or directory' 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

Luckily a friend of mine was able to fix this issue.  It had to do with an IP loopback not being configed correctly.

So when the server was rebooted it didnt save the previous ip settings.

I can get exact details to what he did if anyone is interested

Here is what he did to fix it.


first make sure they ping your machine i.e. "ping localhost" or "ping 127.0.0.1"

if the ip resolves but timesout THEN you want to edit/add The following steps below.

if the server does NOT timeout then the issue is something else

first edit this file:
nano /etc/network/interfaces

then at top of file enter this:

auto lo
iface lo inet loopback

I have the same type error, but there is nothing wrong with my loopback.

Fatal error: Uncaught exception 'Exception' with message 'Could not connect to database: No such file or directory' 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/class_CCSQL.php(41): CCSQL->__construct() #2 /usr/local/centovacast/web/install.php(108): CCSQL::singleton() #3 /usr/local/centovacast/web/install.php(394): install_database() #4 {main} thrown in /usr/local/centovacast/system/class_CCSQL.php on line 32

Anyone have any suggestions?

are you sure Mysql is running?

Yes I restarted it, now I get this error.

Fatal error: Uncaught exception 'Exception' with message 'Could not connect to database: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file' 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/class_CCSQL.php(41): CCSQL->__construct() #2 /usr/local/centovacast/web/install.php(108): CCSQL::singleton() #3 /usr/local/centovacast/web/install.php(394): install_database() #4 {main} thrown in /usr/local/centovacast/system/class_CCSQL.php on line 32


I am trying to finish the install, putting in the passwords, database name etc.  Through the web interface. I went into mysql set passwords etc. flushed privledges. I did let centovacast install the mysql database, I checked for mysql update after, there are none. This is all on a fresh Centos system with nothing installed prior. Should I uninstall and try again?

wish I could help. My knowledge is limited.

Well I re-installed the mySQL 5.095 DB and server. Re-installed centovacast 3.0. During centovacast install it gave me an error about a bad gateway. That I needed to connect to the web interface to finish even though I added all that info in the command line for the install.sh script The web interface just said 502 bad gateway.  So I rebooted the whole server, the bad gateway went away, now I have the same error as before.

I've went in a complete circle. lol

Anyway I've been trying since the 8th of November off and on to install this 3.0.

I've installed the other versions without a hitch, even with control panels installed prior with tons of other things installed.

This server is brand new, with only mySQL and mySQL server installed, and it says centova cast is installed all except for the remaining database setup, which I can't seem to complete. It will not connect to it. I've even manually went into the mysql database and placed all the user, grants on database information there to see if that'd work to complete install. SET PASSWORD  manually as well. I would like to install and test it before the trial runs out. Any guru with secret knowledge out there?

I worry because I noticed they'll discontinue the one I'm using now and I can't get this new one installed.

I just can't believe I cannot install it. I thought that would be much easier this time than before. Surely I am doing something wrong or something is wrong somewhere of course. How else can I narrow down the error?

are you sure you're connected to the correct nic?

when my instal happened initially it was connected to my private ip and not the public.

this might be causing the bad gateway?

I don't think that is the reason. I did double check all that after you mentioned it. I wnet ahead and did my FQDN while I was at it.

I did find out my database wasn't doing the proper Hash.
I had to disable legacy passwords flag in the my.cnf so the database WOULD do the hashing.
So I re-installed again I suppose I got further along.
I got the following...

./install.sh --shoutcast2 --sctrans2 --deps --admin-email=my@email.com --admin-pass=123456789 --dbname=stream --dbuser=streamer --dbpass=987654321 --dbhost=localhost


===== Centova Cast Installation ==========================================

Installing package dependencies ...
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
 * base: mirrors.loosefoot.com
 * extras: dallas.tx.mirror.xygenhosting.com
 * updates: mirror.team-cymru.org
Setting up Install Process
Package mysql-server-5.0.95-5.el5_9.i386 already installed and latest version
Package 1:findutils-4.2.27-6.el5.i386 already installed and latest version
Package wget-1.11.4-3.el5_8.2.i386 already installed and latest version
Package 2:tar-1.15.1-32.el5_8.i386 already installed and latest version
Package gzip-1.3.5-13.el5.centos.i386 already installed and latest version
Package unzip-5.52-3.el5.i386 already installed and latest version
Package sed-4.1.5-8.el5.i386 already installed and latest version
Package grep-2.5.1-55.el5.i386 already installed and latest version
Package gawk-3.1.5-16.el5.i386 already installed and latest version
Package rsync-3.0.6-4.el5_7.1.i386 already installed and latest version
Package gcc-4.1.2-54.el5.i386 already installed and latest version
Package gcc-c++-4.1.2-54.el5.i386 already installed and latest version
Package 1:make-3.81-3.el5.i386 already installed and latest version
Package which-2.16-7.i386 already installed and latest version
Nothing to do


===== Centova Cast Installation ==========================================

Downloading installation system ...
Verifying archive integrity ...
Unpacking archive ...
Beginning installation ...

Checking Centova Cast Common Files ...
Downloading Centova Cast Common Files ...

Verifying archive integrity ...
Unpacking archive ...

Installing Centova Cast Common Files ...

Installation successful

Checking Centova Cast Application Server ...
Downloading Centova Cast Application Server ...

Verifying archive integrity ...
Unpacking archive ...

Installing Centova Cast Application Server ...

Stopping any existing Centova Cast application server service ...
Attempting to stop app: cc-appserver (not running)
Upgrading database ...

Warning: Invalid argument supplied for foreach() in /usr/local/centovacast/system/upgrade/updates/2.1.0.inc.php on line 8
Error: Upgrade failed.  69 error(s) occurred; upgrade codes:

1.1.0-0-0 - Could not execute query: Table 'stream.accounts' do ...
1.1.0-1-1 -
1.1.0-2-0 - Could not execute query: Table 'stream.settings' do ...
1.1.0-3-0 - Could not execute query: Table 'stream.accounts' do ...
1.1.1-0-0 - Could not execute query: Table 'stream.accounts' do ...
1.1.1-1-0 - Could not execute query: Table 'stream.emails' does ...
1.1.1-2-0 - Could not execute query: Table 'stream.settings' do ...
1.1.1-3-1 -
1.1.1-4-1 -
1.1.2-0-0 - Could not execute query: Table 'stream.accounts' do ...
1.1.2-1-0 - Could not execute query: Table 'stream.accounts' do ...
2.0.0b1-0-0 - Could not execute query: Table 'stream.accounts' do ...
2.0.0b1-1-0 - Could not execute query: Table 'stream.accounts' do ...
2.0.0b1-2-1 -
2.0.0b1-3-0 - Could not execute query: Table 'stream.emails' does ...
2.0.0b1-4-1 -
2.0.0b1-5-0 - Could not execute query: Table 'stream.hourlystats' ...
2.0.0b1-6-1 -
2.0.0b1-7-1 -
2.0.0b1-8-1 -
2.0.0b1-9-1 -
2.0.0b1-10-0 - Could not execute query: Table 'stream.settings' do ...
2.0.0b1-11-1 -
2.0.0b1-12-1 -
2.0.0b1-13-1 -
2.0.0b1-14-1 -
2.0.0b1-15-1 -
2.0.0b1-16-0 - Could not execute query: Table 'stream.settings' do ...
2.0.0b1-17-3 -
2.0.0b1-18-0 - Could not execute query: Table 'stream.settings' do ...
2.0.0b1-19-1 -
2.0.0b1-20-0 - Could not execute query: Table 'stream.emails' does ...
2.0.0b1-22-1 -
2.0.0-0-0 - Could not execute query: Table 'stream.settings' do ...
2.0.0-1-1 -
2.0.0-2-0 - Could not execute query: Table 'stream.settings' do ...
2.1.0-0-0 - Could not execute query: Table 'stream.accounts' do ...
2.1.0-1-0 - Could not execute query: Table 'stream.accounts' do ...
2.1.0-2-1 -
2.1.0-3-0 - Could not execute query: Table 'stream.accounts' do ...
2.1.0-4-1 -
2.1.0-5-1 -
2.1.0-6-1 -
2.1.0-7-0 - Could not execute query: Table 'stream.settings' do ...
2.1.0-8-1 -
2.1.0-9-0 - Could not execute query: Table 'stream.settings' do ...
2.1.0-10-1 -
2.1.0-12-1 -
2.1.1-0-3 -
2.1.1-1-3 -
2.1.1-2-0 - Could not execute query: Table 'stream.accounts' do ...
2.1.1-3-0 - Could not execute query: Table 'stream.accounts' do ...
2.1.1-4-0 - Could not execute query: Table 'stream.settings' do ...
2.1.1-5-0 - Could not execute query: Table 'stream.settings' do ...
2.1.1-6-1 -
2.1.2-0-0 - Could not execute query: Table 'stream.accounts' do ...
2.1.2-1-0 - Could not execute query: Table 'stream.accounts' do ...
2.1.2-2-1 -
2.1.2-3-0 - Could not execute query: Table 'stream.settings' do ...
2.1.2-5-1 -
2.1.3-0-0 - Could not execute query: Table 'stream.settings' do ...
2.1.3-1-0 - Could not execute query: Table 'stream.settings' do ...
2.1.3-2-0 - Could not execute query: Table 'stream.settings' do ...
2.2.0-0-0 - Could not execute query: Table 'stream.accounts' do ...
2.2.0-1-0 - Could not execute query: Table 'stream.emails' does ...
2.2.0-2-1 -
2.2.0-3-1 -
2.2.0-4-1 -
2.2.0-5-1 -
2.2.0-6-0 - Could not execute query: Table 'stream.settings' do ...
2.2.0-7-0 - Could not execute query: Table 'stream.settings' do ...
2.2.0-8-0 - Could not execute query: Table 'stream.settings' do ...
2.2.0-9-0 - Could not execute query: Table 'stream.settings' do ...
2.2.0-10-0 - Could not execute query: Table 'stream.settings' do ...
2.2.0-11-1 -
2.2.0-12-1 -
2.2.0-13-1 -
2.2.0-14-1 -
2.2.0-15-1 -
2.2.0-16-0 - Could not execute query: Table 'stream.emails' does ...
2.2.0-17-1 -
2.2.0-18-1 -
2.2.0-19-1 -
2.2.0-20-1 -
2.2.0-21-1 -
2.2.0-22-1 -
2.2.0-23-1 -
2.2.0-24-1 -
2.2.0-25-0 - Could not execute query: Table 'stream.settings' do ...
2.2.0-26-1 -
2.2.0-28-1 -
2.2.1-0-0 - Could not execute query: Table 'stream.settings' do ...
2.2.1-1-0 - Could not execute query: Table 'stream.settings' do ...
2.2.2-0-0 - Could not execute query: Table 'stream.settings' do ...
2.2.2-1-0 - Could not execute query: Table 'stream.settings' do ...
2.2.2-2-0 - Could not execute query: Table 'stream.accounts' do ...
2.2.3rc2-0-0 - Could not execute query: Table 'stream.settings' do ...
2.2.3rc2-1-0 - Could not execute query: Table 'stream.settings' do ...
2.2.5-0-0 - Could not execute query: Table 'stream.settings' do ...
2.2.5-1-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.0b2r1561-0-0 - Could not execute query: Table 'stream.settings' do ...
3.0.0b2r1561-1-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.0b2r1561-2-1 -
3.0.0b2r1561-3-1 -
3.0.0b2r1561-4-1 -
3.0.0b2r1561-5-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.0b2r1561-6-1 -
3.0.0b2r1561-7-0 - Could not execute query: Table 'stream.settings' do ...
3.0.0b2r1561-8-1 -
3.0.0b2r1561-9-0 - Could not execute query: Table 'stream.settings' do ...
3.0.0b2r1561-10-1 -
3.0.0b2r1737-0-0 - Could not execute query: Table 'stream.rpchosts' do ...
3.0.0b2r1737-1-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.0b2r1784-0-0 - Could not execute query: Table 'stream.settings' do ...
3.0.0b2r1908-0-0 - Could not execute query: Table 'stream.rpchosts' do ...
3.0.0b2r1908-1-1 -
3.0.0b2r1908-2-1 -
3.0.0b2r1908-3-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.0b2r1908-5-1 -
3.0.1r2264-0-0 - Could not execute query: Table 'stream.rpchosts' do ...
3.0.2r2310-0-0 - Could not execute query: Table 'stream.djaccounts'  ...
3.0.3r2380-0-1 -
3.0.3r2391-0-1 -
3.0.3r2391-1-1 -
3.0.3r2391-2-0 - Could not execute query: Table 'stream.rpchosts' do ...
3.0.3r2394-0-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.4r2479-0-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.4r2479-1-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.4r2507-0-0 - Could not execute query: Table 'stream.accounts' do ...
3.0.4r2533-0-0 - Could not execute query: Table 'stream.rpchosts' do ...
3.0.5r2551-1-1 -

If you require assistance, please provide the above codes in your support ticket to Centova Cast support.
Database upgrade failed
Installer exited with error, aborting
Installer exited with error, aborting


So checking the mySQL database I have these tables installed.
mysql> show tables;
+--------------------------+
| Tables_in_stream    |
+--------------------------+
| account_templates        |
| amazon_image_cache       |
| apiclusterusers          |
| cronjobs                 |
| eventlog                 |
| genres                   |
| id3cache                 |
| login_bans               |
| logins                   |
| ondemand_xfer            |
| playbackstats_tracks     |
| playlist_priorities      |
| playlist_tracks          |
| playlist_tracks_requests |
| playlists                |
| progress                 |
| regions                  |
| remoteservers            |
| servertypes              |
| sourcetypes              |
| ssokeys                  |
| track_albums             |
| track_artists            |
| track_history            |
| track_queue              |
| tracks                   |
| visitorstats_agents      |
| visitorstats_sessions    |
+--------------------------+
28 rows in set (0.00 sec)

Wasn't trying to upgrade really,there was only an empty database there with no tables, not sure why it was doing that.

Now what I wonder?
Should I contact support?

lol yea just put in a ticket.