Opened 4 years ago
Closed 4 years ago
#1486067 closed Bugs (fixed)
Password Plugin SQL driver
| Reported by: | rosali | Owned by: | |
|---|---|---|---|
| Priority: | 5 | Milestone: | 0.3-stable |
| Component: | Plugins | Version: | 0.3-rc1 |
| Severity: | normal | Keywords: | |
| Cc: |
Description
The password plugin does not work properly if the database connection is not persistent ($rcmail_configdb_persistent? = FALSE;).
Reason: RoundCube session management tries to access "mailserver" database.
MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]n[Last executed query: PREPARE mdb2_statement_mysql_3b18ec83f9ffe2b61cece10f4255b9aea2f7f71ee FROM 'SELECT vars FROM session
n WHERE sess_id=?']n[Native code: 1146]n[Native message: Table 'mailserver.session' doesnt exist]n, referer: http://domain.net/?_task=settings&_action=plugin.password
See (German): http://www.roundcubeforum.net/deutsch/5186-passwort-aendern-ohne-logout.html
Change History (7)
comment:1 Changed 4 years ago by alec
comment:2 Changed 4 years ago by rosali
Does not work for me and others with MySQL on Windows (see link to forum).
The code below does the trick for me ...
if (!$rcmail->config->get('db_persistent')) {
if ($dsn = $rcmail->config->get('db_dsnw')) {
$rcmail->db = new rcube_mdb2($dsn, , FALSE);
}
}
comment:3 Changed 4 years ago by alec
This could help to fix this http://pear.php.net/bugs/bug.php?id=15232
comment:4 follow-up: ↓ 5 Changed 4 years ago by alec
I'm using postgres, so get me to know if adding "?new_link=true" to password_db_dsn fixes this issue.
comment:5 in reply to: ↑ 4 ; follow-up: ↓ 6 Changed 4 years ago by rosali
Replying to alec:
I'm using postgres, so get me to know if adding "?new_link=true" to password_db_dsn fixes this issue.
Yes, it looks like this fixes the issue. I have posted on forum and hope to get a further confirmation.
comment:6 in reply to: ↑ 5 Changed 4 years ago by rosali
Replying to rosali:
Replying to alec:
I'm using postgres, so get me to know if adding "?new_link=true" to password_db_dsn fixes this issue.
Yes, it looks like this fixes the issue. I have posted on forum and hope to get a further confirmation.
OK, the we have second confirmation that adding "?new_link=true" to password_db_dsn fixes this issue.
comment:7 Changed 4 years ago by alec
- Resolution set to fixed
- Status changed from new to closed
Fixed in [add99238].

Works for me with true and false.