View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04783 | Bug reports | [All Projects] Installation | public | 2010-12-03 12:54 | 2010-12-15 13:43 |
| Reporter | filhocf | ||||
| Assigned To | c_schmitz | ||||
| Priority | normal | Severity | block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.90+ | ||||
| Target Version | Fixed in Version | 1.90+ | |||
| Summary | 04783: Error in the first login - username/password wrong | ||||
| Description | After create tables in database, in a PgSQL 9.0, renamed the folder app/admin/install -> install.old and tried to connect as admin, with the password "password", return the message "wrong user or password". Following a tip in this site[1], i logged in, changed the password by admin interface, and restored the changes. When i tried again, return the same error. [1]http://notepad.patheticcockroach.com/264/lost-your-admin-password-in-limesurvey/ I installed the mysql, and was as described in the wiki[2]. [2]http://docs.limesurvey.org/tiki-index.php?page=Installation | ||||
| Steps To Reproduce | 1) download the tar.bz2; 2) uncompress in /var/www; 3) chown www-data.www-data /var/www/limesurvey (is a Debian box); 4) created the limesurvey database in PgSQL, with owner called "limesurvey" and password "limesurvey" (confirmed the access by $psql -h localhost limesurvey limesurvey" (and pw "limesurvey")); 4) changed the file /var/www/limesurvey/config.php to: $databasetype = "postgres" $databaselocation = "localhost" $databasename = "limesurvey" $databaseuser = "limesurvey" $databasepass = "limesurvey" 5) Accessed the page "http://localhost/limesurvey/admin/install" and pressed the button "Populate database"; 6) Renamed the folder install -> install.old 7) Entered in the login page, putting user = "admin" and pass = "password" | ||||
| Tags | No tags attached. | ||||
| Complete LimeSurvey version number (& build) | 9561 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox 3.6 and 4 | ||||
| Database & DB-Version | PostgreSQL 9.0 | ||||
| Operating System (Server) | Debian | ||||
| Webserver software & version | Apache 2.2.16 | ||||
| PHP Version | 5.3.3 | ||||
|
|
I can install just fine here on Postgres. Can you provide a dump of the installed Postgres database and attach it to this issue? |
|
|
Attached dump of PgSQL after processed the population of database. |
|
|
Run the following statement on Postgres after or before installation: ALTER DATABASE <your limesurvey database name> SET bytea_output='escape'; |
|
|
I did this before the population of database and is ok, now. I logged in, changed the pword, logout, and relogged with the new pword. Thanks. |
|
|
Released in 1.90+ version. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-12-03 12:54 | filhocf | New Issue | |
| 2010-12-04 01:51 | c_schmitz | Assigned To | => c_schmitz |
| 2010-12-04 01:51 | c_schmitz | Status | new => assigned |
| 2010-12-09 15:43 | c_schmitz | Note Added: 13734 | |
| 2010-12-09 15:43 | c_schmitz | Status | assigned => feedback |
| 2010-12-09 18:32 | filhocf | File Added: dump_after_install.sql.gz | |
| 2010-12-09 18:33 | filhocf | Note Added: 13736 | |
| 2010-12-09 18:33 | filhocf | Status | feedback => assigned |
| 2010-12-10 22:35 | c_schmitz | Note Added: 13747 | |
| 2010-12-10 22:35 | c_schmitz | Status | assigned => resolved |
| 2010-12-10 22:35 | c_schmitz | Fixed in Version | => 1.90+ |
| 2010-12-10 22:35 | c_schmitz | Resolution | open => fixed |
| 2010-12-10 22:35 | c_schmitz | File Deleted: dump_after_install.sql.gz | |
| 2010-12-11 13:04 | filhocf | Note Added: 13754 | |
| 2010-12-15 13:43 | c_schmitz | Note Added: 13792 | |
| 2010-12-15 13:43 | c_schmitz | Status | resolved => closed |
