Struggling w/ DotProject

[tstarkey]

Hello,
Let me begin by saying I am new to dotproject, and in fact, I am new to the whole open source arena. I have been strictly an M$ guy for a number of years now, but looking through SourceForge for a good project management tool, I came across this and it looked very promising.

So I went out and installed Apache (2.0.54) and PHP (4.3.11) and MySQL (4.1). I walked through an Apache installation document showing what settings to make where in the configuration files, and likewise for PHP, including creating the index.php file and opening it in my browser to ensure it was configured properly with Apache, and it was.

I opened up the install page for dotproject in the browser and went to install but I got an error. I can't recall what it was now, but I have spent the better part of two days now trying to figure out what I have configured incorrectly and am still coming up empty. It's some type of permissions issue for sure, but I can't say what. I had one error once that led me to believe it had to do with the recent MySQL encryption not being understood, and tried using some OLD_PASSWORD function to setup another user but still no go. Now, I am consistently getting the following when trying to "upgrade" dotproject from the install page:

Applying database updates
There were 198 errors in 198 SQL statements
There were 6 errors in 7 SQL statements
There were 7 errors in 8 SQL statements
There were 2 errors in 2 SQL statements
Applying data modifications
FATAL ERROR: Connection to database server failed


Thats if I use the new user I created with the old password encryption. If I use the root user I get the following:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\dotproject\lib\adodb\drivers\ adodb-mysql.inc.php on line 327


It's been a tiring process, but I am determined to get this thing up and running. So any help would be greatly appreciated.


Tony

[pedroa]

If you want to solve it easily, just use mySQL 4.0 instead of 4.1
Just for you to know 4.1 uses a different password hashing procedure and therefore you would have to follow these instructions to solve it with 4.1 http://dev.mysql.com/doc/mysql/en/old-client.html.

By the way if you wanted the whole thing to be easier you should have searched for a WAMP (Windows Apache MySQL PHP) package in SourceForge like The Saint WAMP with PHP4 and it installed it all for you ready to go.
I installed mine from a vTigerCRM compiled package for Windows with everything included, and pretty well configured.

You would then just have to bother with the dP installation.

By the way I am gradually throwing my IE away for Firefox, and Office had to go too for OpenOffice 2 Beta.

Welcome to Open Source and I hope you just come to like it has much as I do.

Pedro A.

[caseydk]

What's IE? ;)

Tony, it looks like your problem is entirely a connection issue to the database. The SQL is good.

[tstarkey]

As I noted, I tried using the OLD_PASSWORD method to bypass the MySQL 4.1 new encryption algorithm, but still no luck. I went ahead and uninstalled 4.1 and tried installing 4.0, but something must be corrupt with the installer because it doesn't install a MySQL service or create program icons or anything.

[tstarkey]

Okay, got a little further moving back to MySQL 4.0, but still getting errors. Here is what happens after trying to go through dotproject/install:

Applying database updates
There were 63 errors in 198 SQL statements
There were 4 errors in 7 SQL statements
There were 4 errors in 8 SQL statements
There were 0 errors in 2 SQL statements
Applying data modifications
ERROR: C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php(61): Error executing: SELECT project_id, project_departments, project_contacts FROM projects
Backtrace:
0 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php:61 dprint('C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\includes\\db_a dodb.php',61,0,'Error executing: SELECT project_id, project_departments, project_contacts FROM projects')
1 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_connec t.php:131 db_exec('SELECT project_id, project_departments, project_contacts FROM projects')
2 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\db\upgrade_to_201. php:42 db_loadlist('SELECT project_id, project_departments, project_contacts FROM projects')
3 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\install\do_install _db.php:182 dpupgrade('1.0.2','2.0.1','')
ERROR: Table 'lufkin.projects' doesn't exist
ERROR: C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php(61): Error executing: SELECT task_id, task_departments, task_contacts FROM tasks
Backtrace:
0 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php:61 dprint('C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\includes\\db_a dodb.php',61,0,'Error executing: SELECT task_id, task_departments, task_contacts FROM tasks')
1 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_connec t.php:131 db_exec('SELECT task_id, task_departments, task_contacts FROM tasks')
2 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\db\upgrade_to_201. php:74 db_loadlist('SELECT task_id, task_departments, task_contacts FROM tasks')
3 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\install\do_install _db.php:182 dpupgrade('1.0.2','2.0.1','')
ERROR: Table 'lufkin.tasks' doesn't exist
Converting users to contacts
ERROR: C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php(61): Error executing: SELECT * FROM users
Backtrace:
0 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php:61 dprint('C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\includes\\db_a dodb.php',61,0,'Error executing: SELECT * FROM users')
1 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_connec t.php:131 db_exec('SELECT * FROM users')
2 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\db\upgrade_contact s.php:8 db_loadlist('SELECT * FROM users')
3 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\db\upgrade_to_201. php:100 include('C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\db\\upgrade_co ntacts.php')
4 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\install\do_install _db.php:182 dpupgrade('1.0.2','2.0.1','')
ERROR: Table 'lufkin.users' doesn't exist
Creating new Permissions objects
Converting admin user permissions to Administrator Role
ERROR: C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php(61): Error executing: SELECT user_id, user_username, permission_id from users
LEFT JOIN permissions ON permission_user = users.user_id and permission_grant_on = 'all'
AND permission_item = -1 and permission_value = -1
Backtrace:
0 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php:61 dprint('C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\includes\\db_a dodb.php',61,0,'Error executing: SELECT user_id, user_username, permission_id from users
LEFT JOIN permissions ON permission_user = users.user_id and permission_grant_on = \'all\'
AND permission_item = -1 and permission_value = -1')
1 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\db\upgrade_permiss ions.php:153 db_exec('SELECT user_id, user_username, permission_id from users
LEFT JOIN permissions ON permission_user = users.user_id and permission_grant_on = \'all\'
AND permission_item = -1 and permission_value = -1')
2 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\db\upgrade_to_201. php:101 include('C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\db\\upgrade_pe rmissions.php')
3 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\install\do_install _db.php:182 dpupgrade('1.0.2','2.0.1','')
Searching for add-on modules to add to new permissions
ERROR: C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php(61): Error executing: SELECT mod_directory, mod_name, permissions_item_table
FROM modules
WHERE mod_ui_active = 1
AND mod_type = 'user'
Backtrace:
0 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_adodb. php:61 dprint('C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\includes\\db_a dodb.php',61,0,'Error executing: SELECT mod_directory, mod_name, permissions_item_table
FROM modules
WHERE mod_ui_active = 1
AND mod_type = \'user\'')
1 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\includes\db_connec t.php:131 db_exec('SELECT mod_directory, mod_name, permissions_item_table
FROM modules
WHERE mod_ui_active = 1
AND mod_type = \'user\'')
2 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\db\upgrade_permiss ions.php:170 db_loadlist('SELECT mod_directory, mod_name, permissions_item_table
FROM modules
WHERE mod_ui_active = 1
AND mod_type = \'user\'')
3 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\db\upgrade_to_201. php:101 include('C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\db\\upgrade_pe rmissions.php')
4 C:\Program Files\Apache Group\Apache2\htdocs\dotproject\install\do_install _db.php:182 dpupgrade('1.0.2','2.0.1','')
ERROR: Table 'lufkin.modules' doesn't exist
Updating version information
Creating config

[pedroa]

Drop your lufkin db, delete includes/config.php and try the installer again.
Verify that is doing a fresh install and not an upgrade.

Pedro A.

[tstarkey]

Terrific! I'm up and running...now the REAL fun begins! ;)

Thanks.