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

Works for me with true and false.

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: 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: 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].

Note: See TracTickets for help on using tickets.