View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06223 | Bug reports | Authentication | public | 2012-06-16 17:00 | 2012-06-19 13:01 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.92+ | ||||
Fixed in Version | 1.92+ | ||||
Summary | 06223: admin login dows not work with postgres | ||||
Description | I installed limesurvey using postgresql as database, and the install-tool finished successfully. But the admin-login always says "Incorrect username and/or password", even when I did not change the default admin / password combination. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 120613 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | PostgreSQL 9.1.1 | ||||
Server OS (if known) | Debian | ||||
Webserver software & version (if known) | nginx 1.2.0 | ||||
PHP Version | 5.4.5 | ||||
Can you please post the config.php section where username and password and DB details (no DB password!) are listed? |
|
// Basic Setup $databasetype = 'postgres'; // ADOdb database driver - valid values are mysql, mysqli, odbc_mssql, mssql_n, odbtp or postgres $databasename = 'umfragepiratenndsde'; // The name of the database that we will create $dbprefix = 'lime'; // A global prefix that can be added to all LimeSurvey tables. Use this if you are sharing // File Locations $rootdir = dirname(FILE); // This is the physical disk location for your limesurvey installation. Normally you don't have to touch this // Installation Setup // Debug Settings |
|
ok, try the following: delete all tables from the existing database, restore the /admin/install dir. Before line: insert the following line: echo $connect->pgVersion; die(); When starting the installation now and it is trying to populate the data it should now show some kind of information. |
|
Feedback please? |
|
9.1 |
|
Thank you. Now move the inserted line right after the line. $connect->execute("ALTER DATABASE {$dbname} SET bytea_output='escape';"); and run the install again. Do you still get the same output? |
|
Yes, still the same output. |
|
OK, revert all changes and run the command on your Postgres LimeSurvey database manually. ALTER DATABASE {$dbname} SET bytea_output='escape'; Replace {$dbname} with your actual limesurvey database name. Let us know if you get any errors if you run this. If you get not error run the installation again (make sure the database exists and is empty) and check if you can login now. |
|
Ok, I got an error, because the user was not owner of the database. Maybe you could add an output for database errors, so the user is notified of these mishaps. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8785 |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2012-06-16 17:00 |
|
New Issue | |
2012-06-16 17:00 |
|
File Added: limesurvey_postgres.backup | |
2012-06-16 17:01 | Mazi | Assigned To | => c_schmitz |
2012-06-16 17:01 | Mazi | Status | new => assigned |
2012-06-16 17:02 | Mazi | Note Added: 19291 | |
2012-06-16 17:02 | Mazi | Status | assigned => feedback |
2012-06-16 17:06 |
|
Note Added: 19292 | |
2012-06-16 17:06 |
|
Status | feedback => assigned |
2012-06-18 15:27 | c_schmitz | Note Added: 19311 | |
2012-06-18 15:27 | c_schmitz | Status | assigned => feedback |
2012-06-19 10:03 | c_schmitz | Note Added: 19334 | |
2012-06-19 10:23 |
|
Note Added: 19336 | |
2012-06-19 10:23 |
|
Status | feedback => assigned |
2012-06-19 11:05 | c_schmitz | Note Added: 19338 | |
2012-06-19 11:17 |
|
Note Added: 19339 | |
2012-06-19 11:33 | c_schmitz | Note Added: 19340 | |
2012-06-19 11:34 | c_schmitz | Note Edited: 19340 | |
2012-06-19 11:34 | c_schmitz | Note Edited: 19340 | |
2012-06-19 11:53 |
|
Note Added: 19341 | |
2012-06-19 12:20 | c_schmitz | Status | assigned => closed |
2012-06-19 12:20 | c_schmitz | Resolution | open => fixed |
2012-06-19 12:20 | c_schmitz | Fixed in Version | => 1.92+ |
2012-06-19 13:01 | c_schmitz | Changeset attached | => LimeSurvey master e3012338 |
2012-06-19 13:01 | c_schmitz | Note Added: 19356 |