| Anonymous | Login | 2010-09-10 03:23 SAST |
| Main | My View | View Issues | Change Log | Roadmap |
| Viewing Issue Simple Details [ Jump to Notes ] | [ View Advanced ] [ Issue History ] [ Print ] | ||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||
| 0000185 | [NagiosQL 3.x] Database | block | always | 2009-01-28 00:41 | 2009-02-26 16:53 | ||
| Reporter | cyruspy | View Status | public | ||||
| Assigned To | rouven | ||||||
| Priority | normal | Resolution | fixed | ||||
| Status | closed | Product Version | 3.0.1 | ||||
| Summary | 0000185: After installation, NagiosQL tries to connect to MySQL in localhost, even it should connect somewhere else | ||||||
| Description |
Fresh installation of v3.0.1. In the installer a remote host is specified as mysql server, the database is created but on first launch after installation I get: SELECT `category`,`name`,`value` FROM `tbl_settings`Error[3]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) |
||||||
| Additional Information |
config/settings.php states ------ [db] server = mysql_host port = 3306 database = db_nagiosql_v3 username = nagiosql_user ------ |
||||||
| Tags | No tags attached. | ||||||
| Attached Files | |||||||
|
|
|||||||
 Relationships |
|
|
Notes |
|
|
(0000303) cyruspy (reporter) 2009-01-28 15:43 |
Estimated release time?, or interim patch for 3.0.1? |
|
(0000304) rouven (administrator) 2009-01-28 16:42 |
Hi, as soon as I have the time to look at that, I will provide a patch. The patch will also be included in 3.0.2. If you want to make things faster, pay us and we might quit our current jobs ;-) Rouven |
|
(0000305) cyruspy (reporter) 2009-01-29 03:15 |
Apparently the installation script doesn't set the permissions like nagiosql_user@'%', so it can't access the database and (apparently) tries to connect lo local host. Fixing mysql user permission after installation allows it to work with a remote database. |
|
(0000310) rouven (administrator) 2009-02-02 10:04 |
Hi, NagiosQL sets the database user like the following that should be fine: GRANT USAGE ON *.* TO '".$dbuser."'@'".$dbhost."' IDENTIFIED BY '".$dbpass I am currently researching why there is any kind of local access somewhere... |
|
(0000312) cyruspy (reporter) 2009-02-02 14:26 |
Well, that seems to be a issue, i'm not connecting from the dbhost, i have a separate web server... That grant assumes the application will be connecting from the same machine that hosts the DB |
|
(0000331) rouven (administrator) 2009-02-26 16:53 |
fixed in SVN 667 |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-01-28 00:41 | cyruspy | New Issue | |
| 2009-01-28 00:41 | cyruspy | Status | new => assigned |
| 2009-01-28 00:41 | cyruspy | Assigned To | => martin |
| 2009-01-28 14:38 | rouven | Assigned To | martin => rouven |
| 2009-01-28 14:39 | rouven | Category | Core => Database |
| 2009-01-28 14:39 | rouven | Target Version | => 3.0.2 |
| 2009-01-28 15:43 | cyruspy | Note Added: 0000303 | |
| 2009-01-28 16:42 | rouven | Note Added: 0000304 | |
| 2009-01-29 03:15 | cyruspy | Note Added: 0000305 | |
| 2009-02-02 10:04 | rouven | Note Added: 0000310 | |
| 2009-02-02 14:26 | cyruspy | Note Added: 0000312 | |
| 2009-02-02 14:35 | rouven | Note Added: 0000313 | |
| 2009-02-24 16:50 | rouven | Note Deleted: 0000313 | |
| 2009-02-26 16:53 | rouven | Status | assigned => closed |
| 2009-02-26 16:53 | rouven | Note Added: 0000331 | |
| 2009-02-26 16:53 | rouven | Resolution | open => fixed |
| 2009-02-26 16:53 | rouven | Fixed in Version | => 3.0.2 |
| Copyright © 2000 - 2009 Mantis Group |  |
