Login

Home Forum
Welcome, Guest
Please Login or Register.    Lost Password?

Table 'db_nagiosql_v3.tbl_settings' doesn't exist
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Table 'db_nagiosql_v3.tbl_settings' doesn't exist
#864
Table 'db_nagiosql_v3.tbl_settings' doesn't exist 1 Year, 3 Months ago Karma: 0
hello everyone,

i went through the installation wizard, but after creating the database and database user the wizard gives the following error:

Table 'db_nagiosql_v3.tbl_settings' doesn't exist

any hints for wrong settings that i got?

a screenshot is attached

thanks for your help!

EDIT: OS is Solaris 10. MySQL-Version is 5.0.77
ds_bsz
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2009/04/23 14:52 By ds_bsz.
The administrator has disabled public write access.
 
#865
Re:Table 'db_nagiosql_v3.tbl_settings' doesn't exist 1 Year, 3 Months ago Karma: 0
sorry, image was to large...
This image is hidden for guests. Please login or register to see it.
ds_bsz
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2009/04/23 14:35 By ds_bsz.
The administrator has disabled public write access.
 
#866
Re:Table 'db_nagiosql_v3.tbl_settings' doesn't exist 1 Year, 3 Months ago Karma: 2
Could you please check if the installer created a table tbl_settings
rouven
NagiosQL Developer
Posts: 255
graphgraph
User Offline Click here to see the profile of this user
47315142 Gender: Male NagiosQL Location: Hamburg, Germany Birthday: 03/19
The administrator has disabled public write access.
 
#867
Re:Table 'db_nagiosql_v3.tbl_settings' doesn't exist 1 Year, 3 Months ago Karma: 0
hmm, seems like it didn't:

Code:

mysqlshow -u root -p db_nagiosql_v3
Enter password: 
Database: db_nagiosql_v3
+--------+
| Tables |
+--------+
+--------+

ds_bsz
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#869
Re:Table 'db_nagiosql_v3.tbl_settings' doesn't exist 1 Year, 3 Months ago Karma: 2
are you trying to connect to a local or remote database?
rouven
NagiosQL Developer
Posts: 255
graphgraph
User Offline Click here to see the profile of this user
47315142 Gender: Male NagiosQL Location: Hamburg, Germany Birthday: 03/19
Last Edit: 2009/04/23 15:59 By rouven.
The administrator has disabled public write access.
 
#870
Re:Table 'db_nagiosql_v3.tbl_settings' doesn't exist 1 Year, 3 Months ago Karma: 0
a local database. but as i can see when i do:
Code:

mysql> SELECT user, host, password FROM mysql.user;



the installation wizard created the user and took as host name the ip of the server instead of localhost or his hostname!
ds_bsz
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12