I cannot create the DB

[arieldoucette]

I tried installing dotproject (windows server 2003, hosted by someone else..., with php and mysql enabled) but the installer could not create the database.
How do I resolve this?

Here is the error:


Warning: mysql_connect(): Access denied for user: 'dp_user@localhost' (Using password: YES) in C:\Domains\myDomainName.com}\wwwroot\dotproject\li b\adodb\drivers\adodb-mysql.inc.php on line 327
dotProject Logo dotProject Installer
Progress:

Creating config


Database Installation Feedback: Not Created
No Database Connection available! Access denied for user: 'dp_user@localhost' (Using password: YES)
Please note that errors relating to dropping indexes during upgrades are NORMAL and do not indicate a problem.
Config File Creation Feedback: Config file written successfully

Login and Configure the dotProject System Environment

--end error message

So, what do I do to fix this?
Thanks,
Ariel

[pedroa]

Hi,

It seems the username and password you supplied to dP for mysql database creation and connection does not give you enough rights to the mysql server or does not exist at all.
You should verify this with you host service provider.

Pedro A.

[arieldoucette]

So, I am aware that these are newbie questions, but:
I sent a support email to my webhost asking for a MySQL username and password so that I can create and modify MySQL databases. Is this the correct thing to ask?

Will dotproject's install actually create the MySQL database for me? Is there anything I'll need to do for this outside of the dotproject installer, like in my web-site control panel?

Also, on my site, the folder hierarchy is like this:
siteroot
--db
--logs
--wwwroot
----dotproject

So, where will dotproject put the DB by default? Will it go into the db folder?

And can I rename the folder that dotproject is in before I install it (or, also, after I install dotproject)? So, could it be in, say, a folder wwwroot/projview so that I could access it at www.{mywebsite}.com/projview ?

Sorry about all the noob questions,
Ariel

[pedroa]

Hi,

1) Your question is right.
2) If the mysql username and password is right, dP will create the db and the tables for you by the installer.
3) mySQL server determines where databases are created if your host provider defined the db folder as the databases destination then yes. I think that's so.
4) Before you install, if you change the folder name, I am sure everythinhg will be ok, dP determines it's own folder place at runtime, and so it is not dependent of a folder name. If you change the folders name after installing, dP will continue to know it's place so it could work. My advice is change it before you install. If you want to test it, then change it if it doesn't work, rename it again, remove it, drop the database and reinstall it again in place where you want.

Pedro A.

[arieldoucette]

OK,
I got the webhost to give me a MySQL database and a username and password
but I still can't get it to work...
I still get the same error as I posted above.
What could be the problem

[arieldoucette]

GOt the DB nailed down. Yeah!
But, now, when setup finished, I got the following errors: (I'll have to use 2 posts...)

dotProject Logo dotProject Installer
Progress:

Applying database updates
There were 87 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:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php(61): Error executing:

SELECT project_id, project_departments, project_contacts FROM projects


Backtrace:
0 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php:61 dprint(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
1 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_connect.php:131 db_exec(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
2 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_to_201.php:42 db_loadlist('C:\\Domains\\{my_website_name_here}.c om\\wwwroot\\dotproject\\includes\\db_adodb.php',6 1,0,'Error executing:

SELECT project_id, project_departments, project_contacts FROM projects

')
3 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\install\do_install_db.php:182 dpupgrade('SELECT project_id, project_departments, project_contacts FROM projects')
ERROR: Table 'dotproject.projects' doesn't exist


Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_to_201.php on line 51

ERROR: C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php(61): Error executing:

SELECT task_id, task_departments, task_contacts FROM tasks


Backtrace:
0 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php:61 dprint(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
1 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_connect.php:131 db_exec(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
2 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_to_201.php:74 db_loadlist('C:\\Domains\\{my_website_name_here}.c om\\wwwroot\\dotproject\\includes\\db_adodb.php',6 1,0,'Error executing:

SELECT task_id, task_departments, task_contacts FROM tasks

')
3 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\install\do_install_db.php:182 dpupgrade('SELECT task_id, task_departments, task_contacts FROM tasks')
ERROR: Table 'dotproject.tasks' doesn't exist


Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_to_201.php on line 83

Converting users to contacts

ERROR: C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php(61): Error executing:

SELECT * FROM users


Backtrace:
0 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php:61 dprint(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
1 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_connect.php:131 db_exec(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
2 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_contacts.php:8 db_loadlist(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
3 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_to_201.php:100 include('C:\\Domains\\{my_website_name_here}.com\\ wwwroot\\dotproject\\db\\upgrade_contacts.php')
4 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\install\do_install_db.php:182 dpupgrade('C:\\Domains\\{my_website_name_here}.com \\wwwroot\\dotproject\\includes\\db_adodb.php',61, 0,'Error executing:

SELECT * FROM users

')
ERROR: Table 'dotproject.users' doesn't exist


Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_contacts.php on line 9

Creating new Permissions objects
Converting admin user permissions to Administrator Role

ERROR: C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\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:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php:61 dprint(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
1 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_permissions.php:153 db_exec(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
2 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_to_201.php:101 include('C:\\Domains\\{my_website_name_here}.com\\ wwwroot\\dotproject\\db\\upgrade_permissions.php')
3 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\install\do_install_db.php:182 dpupgrade('C:\\Domains\\{my_website_name_here}.com \\wwwroot\\dotproject\\includes\\db_adodb.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

')
Searching for add-on modules to add to new permissions

ERROR: C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\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:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php:61 dprint(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
1 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_connect.php:131 db_exec(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
2 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_permissions.php:170 db_loadlist(

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\main_functions.php on line 538

)
3 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_to_201.php:101 include('C:\\Domains\\{my_website_name_here}.com\\ wwwroot\\dotproject\\db\\upgrade_permissions.php')
4 C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\install\do_install_db.php:182 dpupgrade('C:\\Domains\\{my_website_name_here}.com \\wwwroot\\dotproject\\includes\\db_adodb.php',61, 0,'Error executing:

SELECT mod_directory, mod_name, permissions_item_table
FROM modules
WHERE mod_ui_active = 1
AND mod_type = \'user\'

')
ERROR: Table 'dotproject.modules' doesn't exist

[arieldoucette]

Warning: Invalid argument supplied for foreach() in C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\db\upgrade_permissions.php on line 171

Updating version information
Creating config


Database Installation Feedback: DB setup incomplete - the following errors occured:
Table 'dotproject.projects' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.user_tasks' doesn't exist
Table 'dotproject.users' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.tasks' doesn't exist
Table 'dotproject.files' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.syskeys' doesn't exist
Table 'dotproject.syskeys' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'task_contacts' already exists
Table 'task_departments' already exists
Table 'project_contacts' already exists
Table 'project_departments' already exists
Table 'dotproject.user_tasks' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.users' doesn't exist
Table 'dotproject.user_preferences' doesn't exist
Table 'dotproject.user_preferences' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'user_access_log' already exists
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.task_log' doesn't exist
Table 'dotproject.task_log' doesn't exist
Table 'dotproject.task_log' doesn't exist
Table 'user_task_pin' already exists
Table 'gacl_acl' already exists
Table 'gacl_acl_sections' already exists
Table 'gacl_aco' already exists
Table 'gacl_aco_map' already exists
Table 'gacl_aco_sections' already exists
Table 'gacl_aro' already exists
Table 'gacl_aro_groups' already exists
Table 'gacl_aro_groups_map' already exists
Table 'gacl_aro_map' already exists
Table 'gacl_aro_sections' already exists
Table 'gacl_axo' already exists
Table 'gacl_axo_groups' already exists
Table 'gacl_axo_groups_map' already exists
Table 'gacl_axo_map' already exists
Table 'gacl_axo_sections' already exists
Table 'gacl_groups_aro_map' already exists
Table 'gacl_groups_axo_map' already exists
Table 'gacl_phpgacl' already exists
Table 'dotproject.companies' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.tasks' doesn't exist
Table 'dotproject.tasks' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.files' doesn't exist
Table 'dotproject.files' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.syskeys' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.tasks' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.forum_watch' doesn't exist
Table 'dotproject.forum_watch' doesn't exist
Table 'dotproject.files_index' doesn't exist
Table 'dotproject.files_index' doesn't exist
Table 'dotproject.files_index' doesn't exist
Table 'dotproject.files_index' doesn't exist
Table 'dotproject.files_index' doesn't exist
Table 'dotproject.files_index' doesn't exist
Table 'dotproject.files_index' doesn't exist
Table 'dotproject.files_index' doesn't exist

Please note that errors relating to dropping indexes during upgrades are NORMAL and do not indicate a problem.
Config File Creation Feedback: Config file written successfully

Login and Configure the dotProject System Environment
C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php(61): Error executing:

SELECT project_id, project_departments, project_contacts FROM projects

C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php(61): Error executing:

SELECT task_id, task_departments, task_contacts FROM tasks

C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\includes\db_adodb.php(61): Error executing:

SELECT * FROM users

C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\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

C:\Domains\{my_website_name_here}.com\wwwroot\dotp roject\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'





So, what is all this?
Ariel

[arieldoucette]

OK,
have the DB up and running.
But, when I install, the web-browser (ie or moz) freezes at "installing database".
But the DB gets made (all 28 tables, are there only 28 tables?) and I have to re-run install to get the config file made.
But, then I can't log in. And so, I've put that into another post.