Error connecting to database [Unknown database 'osmiy']

[dcrandall]

After upgrade from beta12 to 1.1 I keep getting this in the webinterface:

Error connecting to database [Unknown database 'osmiy']

wtf?

[donjjones]

Did you edit the db.inc.php file?

[dantheman]

did you copy the database configuration file from the beta frontend to the 1.1? or at least set your database configuration again for the new frontend? there is a file in the includes directory db.inc.php I think it is.

[dcrandall]

Ok, apparently 'osmiy' forgot that most us don't have a database called that.
In zabbix1.1 in the webserver frontend files, include/db.inc.php has the database set to "osmiy". I changed it to zabbix and the web interface started working again.

One thing I wondering. Sometimes I test changes or zabbix backups by creating a different database like "zabbix2" load the schema, restore the data, and check it in the web interface after setting the database to zabbix2 in the zabbix_server.config.

With it hard coded in db.inc.php, doesn't that make this impossible now?

daniel

[dcrandall]

Hi,
wrote my update before I saw your responses. Thanks!

I've never had to edit the db.inc.php file in the past.

[dantheman]

I know that the db.inc.php file has needed that set, for sure since Beta9.. That's the first version I tried. But you always change the database name in both places if you wanted to test on a different database.

[dcrandall]

Hm.
I was doing that very thing in beta11 and beta12 and the only place I had to change the database name was in zabbix_server.conf.
This seems to me like it was an oversite on the part of whomever is writing the php code.

[krusty]

@dcrandall,

you must be joking. You even have to change the database name and password on zabbix_server.conf file and into the php source (include/db.inc.php).

[dcrandall]

No I'm not joking.

I was having database issues with beta11 and beta12, where whenever I would start the server it would start updating the db and the db would crash then the server would crash (turned out to be db corrption)

I created a new database called zabbix2, built it out from dumps of database zabbix tables and the default schema.sql file for the tables that were corrupt, changed the db name in zabbix_server.conf to zabbix2 and it worked.

That's why I was thrown off when I upgraded to 1.1 and the web interface started complaining about the database name being osimy.