Relationship Graph
View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
05721 | Bug reports | Authentication | public | 2012-01-30 15:16 | 2012-03-03 02:25 |
Reporter | jhubbs | Assigned To | c_schmitz | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.92RC3 | ||||
Fixed in Version | 1.91+ | ||||
Summary | 05721: Login with admin and deafault password doesn't work | ||||
Description |
After installation of LimeSurvey, I can't get logged using | ||||
Steps To Reproduce | I did the following:
I attempt to login using the config.php using the admin user and the default password that I set. I've attempted this on chrome/firefox/safari. It doesn't work. | ||||
Additional Information | Possibly related to bug 05710 | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 12204 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | all | ||||
Database type & version | Postgresql 9.1.2 | ||||
Server OS (if known) | Fedora 16 | ||||
Webserver software & version (if known) | Apache 2.2.21 | ||||
PHP Version | 5.3.9 | ||||
Can this be a Postgres issue? Because at MySQL it seems to work fine?! jhubbs, can you attach an SQL dump of the database? |
|
It probably is a Postgresql. It was mentioned that the tables had been modified and that perhaps the code hadn't been audited for case sensitivity for the various changes. |
|
I don't understand how this is a duplicate of 5710? It might be related but the file that I attached in 5710 doesn't fix this problem. |
|
Sorry, but we did not use your file. I fixed it before seeing your patch - and it also fixed this one. |
|
I'm running the development tree. It's not fixed |
|
It works just fine here. Did you try to install on a clean, newly created database? |
|
Yes. Part of my process is to update the dev tree checkout I have and drop/create database. |
|
Well, I just tested it again here, works just fine. No matter if I do it on Postgres 8.x or 9.x. So unless you give me access to such a system to debug I am afraid I can't do anything and have to close this issue. |
|
I can provide you with access since it's running in a VM. I'll need an email. Is there anything about installation/configuration that the wiki instructions haven't documented? |
|
jhubbs, you can send the details to Carsten using carsten.schmitz(at)limesurvey.org |
|
Yep :-) |
|
jhubbs, did you send anything? Because I did not get anything. |
|
I sent an email Feb 2 around 18:51 UTC to the address listed on the web page which matches Mazi's post. I'll upgrade to the latest and re-send the login info again. |
|
I went through the usercontrol.php file and pulled out the password comparison. When I dumped them to the output I received the following output. As you can see the two values are drastically different. Is there encoding value that I didn't set properly somewhere? The database is set for UTF-8. The database setup files in the limesurvey files are using UTF8 for encoding. Using the SHA256::hashing($_POST['password']) from the database |
|
Run the following SQL command ALTER DATABASE limesurvey SET bytea_output='escape'; and check if it fixes your problem. This is usually executed automatically in createdb.php , around line 42
I guess it is no executed on your database during installation. Please find out why by dumping $connect->pgVersion |
|
$connect->pgVersion == '9.1' on my setup. I modified the file to add a check for 9.1. I'm able to login as admin now. Thank you for the assistance. |
|
1.92 released |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2012-01-30 15:16 | jhubbs | New Issue | |
2012-01-30 15:26 | Mazi | Assigned To | => c_schmitz |
2012-01-30 15:26 | Mazi | Status | new => assigned |
2012-01-30 15:27 | Mazi | Note Added: 17055 | |
2012-01-30 15:27 | Mazi | Status | assigned => feedback |
2012-01-30 16:53 | jhubbs | File Added: limesurvey_192rc3_pgdump.sql.gz | |
2012-01-30 16:57 | jhubbs | Note Added: 17056 | |
2012-01-30 16:57 | jhubbs | Status | feedback => assigned |
2012-01-30 18:39 | c_schmitz | Relationship added | duplicate of 05710 |
2012-01-30 18:39 | c_schmitz | Status | assigned => resolved |
2012-01-30 18:39 | c_schmitz | Resolution | open => duplicate |
2012-01-30 18:40 | c_schmitz | File Deleted: limesurvey_192rc3_pgdump.sql.gz | |
2012-01-30 18:40 | c_schmitz | Status | resolved => closed |
2012-01-30 19:08 | jhubbs | Note Added: 17091 | |
2012-01-30 19:08 | jhubbs | Status | closed => feedback |
2012-01-30 19:08 | jhubbs | Resolution | duplicate => reopened |
2012-01-30 21:16 | c_schmitz | Note Added: 17093 | |
2012-01-30 21:16 | c_schmitz | Status | feedback => closed |
2012-01-30 21:16 | c_schmitz | Resolution | reopened => duplicate |
2012-01-31 15:36 | jhubbs | Note Added: 17103 | |
2012-01-31 15:36 | jhubbs | Status | closed => feedback |
2012-01-31 15:36 | jhubbs | Resolution | duplicate => reopened |
2012-02-06 13:58 | c_schmitz | Note Added: 17241 | |
2012-02-06 14:21 | jhubbs | Note Added: 17244 | |
2012-02-06 14:21 | jhubbs | Status | feedback => assigned |
2012-02-06 17:43 | c_schmitz | Additional Information Updated | |
2012-02-06 22:14 | c_schmitz | Note Added: 17265 | |
2012-02-06 22:14 | c_schmitz | Status | assigned => feedback |
2012-02-07 03:06 | jhubbs | Note Added: 17269 | |
2012-02-07 03:06 | jhubbs | Status | feedback => assigned |
2012-02-07 09:24 | Mazi | Note Added: 17273 | |
2012-02-07 09:24 | Mazi | Status | assigned => feedback |
2012-02-07 12:10 | c_schmitz | Note Added: 17275 | |
2012-02-27 01:31 | c_schmitz | Note Added: 17661 | |
2012-02-28 17:10 | jhubbs | Note Added: 17680 | |
2012-02-28 17:10 | jhubbs | Status | feedback => assigned |
2012-02-28 20:58 | jhubbs | Note Added: 17681 | |
2012-02-29 00:40 | c_schmitz | Note Added: 17684 | |
2012-02-29 00:41 | c_schmitz | Status | assigned => feedback |
2012-02-29 15:20 | jhubbs | Note Added: 17690 | |
2012-02-29 15:20 | jhubbs | Status | feedback => assigned |
2012-03-01 09:27 | c_schmitz | Status | assigned => resolved |
2012-03-01 09:27 | c_schmitz | Fixed in Version | => 1.91+ |
2012-03-01 09:27 | c_schmitz | Resolution | reopened => fixed |
2012-03-03 02:25 | c_schmitz | Note Added: 17729 | |
2012-03-03 02:25 | c_schmitz | Status | resolved => closed |