Login Failed to admin/passwd on Fresh Install

[TheJoshua]

Hello, people

I´ve tried to install dP several times, some upgrading my old dP, some of them fresh (backed-up and deleted both database and directory). I still can´t log in with admin user using the default passwd.

Most my installations are quite easy and clean. I´ve tried changing the session.autostart, using Firefox instead of IE, even hacking upgrade_permissions.php to run manually - nothing worked out.

Some of my settings (from my all-OK /docs/check.php)
> MySQL Server Version:4.0.20'-Max'
> Web Server:Apache-AdvancedExtranetServer/2.0.50 (Mandrakelinux/7.2.101mdk) mod_ssl/2.0.50 OpenSSL/0.9.7d PHP/4.3.8
session.auto_start: Disabled OK
session.save_handler: files
session.save_path: /tmp OK
session.serialize_handler: php
session.use_cookies: Enabled OK
session.use_trans_sid: Disabled OK
file_uploads: Enabled OK
/locales/en directory writable: Yes OK
/files directory writable: Yes OK
/files/temp directory writable: Yes

I keep on getting the same error on screen:
> Login Failed
and on my log file:
> dotproject/classes/ui.class.php(668): Permission check failed

If nobody can help me with this problem thru Install, can anyone explain what those gacl tables mean, so I can try to fix them?

Thanks!

[pedroa]

After your install, do you have any records in the gacl_* tables?

Pedro A.

[TheJoshua]

Yes,

I have records on several tables:

gacl_acl = 6 records
gacl_acl_sections = 2 records
gacl_aco = 6 records
gacl_aco_map = 15 records
gacl_aco_sections = 2 records
gacl_aro = 1 record (name = 'admin',section_value = 'user', value=1)
gacl_aro_groups = 5 records
gacl_aro_groups_map = 6 records
gacl_aro_map = 0 records (can this be a problem?)
gacl_aro_sections = 1 record
gacl_axo = 18 records
gacl_axo_groups = 4 records
gacl_axo_groups_map = 4 record
gacl_axo_map = 1 record
gacl_axo_sections = 2 records
gacl_groups_aro_map = 1 record
gacl_groups_axo_map = 34 records

I couldn´t figure out until now what each table mean..

:shock:

[pedroa]

Reference:

http://phpgacl.sourceforge.net/demo/phpgacl/docs/manual.html

Now, see what are the records in the users table? What's the password hash for user "admin"?

Pedro A.

[TheJoshua]

Table [users] is OK.
The Hash is '76a2173be6393254e72ffa4d6df1030a'

I´ve put some logs in the PHP code on the authentication classes and found the password verification is OK. Everything blows inside the checkLogin method.

[TheJoshua]

I've managed to understand the ACL stuff and found it was set up just right.
I was beginning to despair when I remembered someone somewhere said the debug level could go beyond 7.
I have raised the debug level to 10, and found this little beauty:

> permissions.class.php(816): acl_query (): database error: Can't create/write to file '/root/tmp/#sql_4107_0.MYI' (Errcode: 13) (1)

It was just a little bit hard to point out the exact cause why this particular temp file was being created, but all I had to do was create a new my.cnf on my /etc/ pointing MySQL temp files elsewhere where it could write (in my case /var/tmp) and voila!

Thanks to everyone for your kind help.
Hope this experience is useful to help others.

[]s