View Full Version : Can't create the database
I've got all the files onto my cgi... location and when I click the 'Install db & write cfg' button I get the following error:
Fatal error: Cannot instantiate non-existent class: installerui in /files/home2/heeley/dotproject/install/do_install_db.php on line 15
Can someone help me get to the bottom of the error?
BTW, I'm using:
Win XP home with sp2
php 4.1.0 (?)
ISP = Plus.net - if that helps identify the above
Is this error because I already have a database created and I cannot have more than one? I don't have the rights to create a database.
I need to add the appropriate tables. Is this possible through a manual process?
17-05-05, 05:01 PM
The problem is that it is not determining the current directory correctly and so not loading the install support routines. The error is as a result of not having the code for class InstallerUI available. Since dP does a lot of including of support files, this is likely to be a bigger problem than just the installer.
You might want to run the docs/check.php to see what information that returns.
Thanks for the help, here is the message I get:
dotProject System Checks
Warning: main(/files/home2/heeley/dotproject/includes/config.php): failed to open stream: No such file or directory in /files/home2/heeley/dotproject/docs/check.php on line 25
Fatal error: main(): Failed opening required '/files/home2/heeley/dotproject/includes/config.php' (include_path='.:/usr/local/share/pear') in /files/home2/heeley/dotproject/docs/check.php on line 25
Please can anyone give me some pointers as to what I need to do?
I really, really, really what to give dotproject a go ...
21-05-05, 02:17 AM
It looks like there isn't a config.php file.
There should be a config-dist.php. Copy that file and rename it to config.php and try again.
Now I get a
Fatal: Check host, username and password
error when I run check.php for the
MySQL Database Connection
This is indicating that you don't have the database connection details set up in your config.php file.
Reading back through all of this I'm sorry but I can't tell - did you actually ever manage to complete the installation process? If not, it might be worth going back to the start.
Karen - Many thanks for the response.
I could never get the installation to configure my connection.
I did go into the config.php file directly and edit the connection settings (I know I shouldn't have!) and the system 'worked' - telling me that a field wasn't present in one of the tables - which is exactly what you would expect!
I deleted all the files in frustration - but can try again. I'll post all the steps I follow and the messages I get if that will help.
Well here goes....
1. Copied the extracted files to my cgi webspace using latest version of Filezilla.
2. Ran the install using IE and fixed all the error messages. Then I noticed the IE warning so closed down and ran Firefox.
3. Got the text in the Warning section displayed below when I tried to access the dotproject area on my cgi webspace.
4. Removed the bulk of the files (couldn't remove the adodb directory as there is a persistent file in there)
5. Copied files over again and ran the install, fixed the errors using Firefox.
6. After a few seconds the following messages appeared:
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
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /files/home2/heeley/dotproject/lib/adodb/drivers/adodb-mysql.inc.php on line 327
FATAL ERROR: Connection to database server failed
7. Now I get the Warning section whenever I try to access the dotproject area on my cgi webspace.
I just upgraded from 2.0.0 to 2.0.1 on IIS. Got lots of errors that turned out to be file related to file permissions. Went through the file directory and manually added the IIS permisisons to all the new files and it worked a treat.
I'm sorry but I have decided to give up the ghost and not try to configure dotproject again.
I've tried several times and although a newbie to this area of computing - I view myself as techically savvie and cannot succeed in installing properly.
It's a shame because I would really have liked to get the software running.
Hi, I've got this issue too when I try to install dotproject (when I click on "upgrade db & write cfg" button).
Here's my issue :
Here's the configuration I've got :
I wish you will be able to help me :grin:
Point your browser to docs/ and see the System Checks page.
Results on MySql connectivity?
Thanks for your answer.
In fact, I get the following result :
MySQL was installed with my Red Hat ES3 but not correctly so I've downloaded the 4.1.13 version in order to install it but I don't know how to do because I'm not really a linux user.
So if you could tell how to proceed, I would be perfect.
Thanks in advance
I've searched on mysql website in order to know how to proceed and they say to use RPM but I don't have that and I don't know were I could find that
This does seem to be a MySql Problem...
I would advise to use 4.0 (the most recent subversion) instead of 4.1 because of possible password hashing problems (this can lead you to Old Client mysql errors).
Verify that your php is compiled with mysql support.
If these don't work then a LAMP package could be the way to go, since they are normally allready configured out of the box. Verify the documentation site for version requirements.
Once this connectivity issue is resolved everything should be ok.
ok thanks I will check that.
In order to correct this issue, I've formated and tried to install dotproject.
Now I get this issue :
thanks in advance
Does the checks look right this time?
Do you have mysql server running?
Does the username/password you gave on install have the necessary mysql permissions?
Also see http://www.dotproject.net/vbulletin/showthread.php?t=2831&highlight=database+connection+failed
I've tried with root user but it doesn't work. I don't know how to proceed to create a new user. I've search on the web and the creation seems to work but given that there isn't any user table in dotproject database, the user is not created.
How must I proceed please?
Chips checks now say that you have mysql connection?
If so delete the includes/config.php
If you have a db created, drop it.
Go to the install/ with your browser, it will trigger the installer.
dP creates an Admin user by default with passwd as password.
Follow the installer instructions.
in fact, the mysql connection is not really good and I thought that It came from a user issue. Given that I don't have any yser except root, when I try to create install db with dp_user it tells me that :
I think that the user is not created and not recognized.
That's why I thought that I would have to create it first with all privileges before installing db.
The installer does not create a mysql user, it must be you to provide one.
It can perfectly be your mysql root user.
Also notice that some directories must be writeable, it is the case of the includes folder and some others, please refer to the documentation site for dP 2.0 installation procedures and requirements.
...and try again...
I had most of the same error messages when I first tried to install. It wasn't until I read the following comments in config-dist.php that I realised that dp_user and dp_pass actually refer to mysql username and password. The terminology seems a bit misleading, and isn't explained on the setup page like it is in config-dist.php
I originally thought that dp_user and dp_pass were defaults that I could happily leave as is, but after 5 failed installs I discovered differently
As soon as I used my mysql username and password, (which are totally independent of dotproject) in place of dp_user and dp_pass, I had complete success with the install, and am now dotprojecting away to my hearts content.
Could I suggest a clearer explanation on the setup page regarding this? I don't have much experience with mysql and php, but there are a lot of people with less.
(extract from config-dist.php which clearly explains what is needed)
// DATABASE ACCESS INFORMATION [DEFAULT example]
// Modify these values to suit your local settings
$dPconfig['dbtype'] = "mysql"; // ONLY MySQL is supported at present
$dPconfig['dbhost'] = "localhost";
$dPconfig['dbname'] = "dotproject"; // Change to match your DotProject Database Name
$dPconfig['dbuser'] = "dp_user"; // Change to match your MySQL Username
$dPconfig['dbpass'] = "dp_pass"; // Change to match your MySQL Password
By the way, while I'm here, I had to change write permissions on a few directories as per the installer instructions, (great installer by the way), but I could have done with a bit more information. I changed them from 755 to 777, which is world-writable, but wasn't sure if that was necessary. I also got messages from the installer that the temp directory was not writable, (fatal error) even though on checking it was. The install, and operation so far, went ok however. Would the effect of a non-writable temp directory show up straight away?
In a new module we have created we wanna insert in one passe all datas in the database :
$insert_dp1="INSERT INTO document_phases VALUES (1,'Qualification', NULL, NULL, 2, 'locked', 1)";
$insert_dp1.="INSERT INTO `document_phases` VALUES (2, 'Acquisition', NULL, NULL, 3, 'locked', 1)";
but we have error message as follow :
Error ine 'INSERT INTO document_phases VALUES (2, 'Acquisition', NULL, NULL' line 1 Module installed
dmaodo you are in the wrong place, pal.
Try another forum... for other modules...
20-09-05, 09:10 PM
I have met the various pre-installation requirements. I have created the appropriate MySQL user and reloaded my privileges in MySQL (a vital step that is rarely mentioned and often forgotten).
However, I still get the following error:
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
Although the privileges are in place no db or tables have been created. This software doesn't seem to work?
21-09-05, 02:14 PM
The software works fine, the database connection doesn't. Check that you have the correct database server and database user and database name. Make sure if you are using localhost as your database host that the database server supports local (UNIX sockets) connections. If you are not using localhost check that MySQL is set to accept network connections. Make sure your user privileges match the user on the host that is running the webserver.
If all else fails run docs/check.php and see if it gives any more details.
Reloading privileges is only required if you manually update the user/host tables. If you use the GRANT method of creating a user then the privileges are automatically updated.
21-09-05, 06:12 PM
My database connection was working fine.
It turns out the problem was that I hadn't manually created the database 'dotproject'.
All this hassle could have been saved if it had STATED CLEARLY ON THE INSTALL SCREEN which parts of the process I was expected to do manually. As it is, it gives the impression that the installer is about to create the database and required user too.
I can see I now have another issue: Creating a database called 'dotproject' is fine on my local dev machine, but when I go to run it on the live server my web host won't let me do that. I only get one database. That is fine, but it would be VERY useful if dotproject allowed me to add a prefix to its table names to avoid conflicts with existing tables in that database. Pretty much essential for anyone using 3rd party hosting.
22-09-05, 10:06 AM
First things first - by database connection I meant the connection to the database, not the database server. By your own admission that was most definitely not working. But that aside. If you look at the messages you received it is clearly showing this as an upgrade not an install. This would occur if you manually created the config.php file or if you were upgrading an existing system. If there isn't a config.php file then it would have installed the database for you. Since there was one - or at least there was at the time it was doing the upgrade - it would not try and create a database that should already be there. Pretty much all of this, and how to cope with db users who don't have CREATE DATABASE privilege, is explained in the installation instructions on docs.dotproject.net.
Table prefixes is a known issue and is being worked on. At the moment it won't be available until version 3.
26-09-05, 12:35 AM
Thanks for your reply, and glad to hear that table prefixes are in the wings :)
Just to clarify my original situation: I wasn't doing an upgrade really, I have never installed the software before. However I had a couple of failed attempts to install, so there was already a config.php file being found (wasn't sure where this was to delete it)... so the installer prompted me to upgrade instead.
It makes sense that it wouldn't create the db if doing an upgrade. My original failed install was due to me believing that it would also create the db username specified in the box. This may be explained in the docs but the installer seemed otherwise quite simple and user friendly and it didn't look like I would need to read them just yet.
Some small changes to the wording on this screen would have made it clear - I mean, that short and all important sentance in the docs would be much more useful on the install screen.
Alternatively, a more specific error message would have quickly alerted me to my mistake. For example, instead of (or as well as) 'There were 198 errors in 198 SQL statements,' which only tells me something is wrong, it could have said 'database not found' or 'insufficient privileges' and I would have had a clue where to look.
Don't take this as criticism, my point is just that minor user interface issues like these can make the difference between a smooth and easy experience or a frustrating and difficult one.
I have it working now! I persevered because it looks like the best software for the job... thanks!
28-09-05, 02:22 AM
I have an existing user table in my database and seeing as I can only have one database with my web host, is there a workaround for this? I can't delete the old one, but was hoping to insert dotProject user data on top or into this existing table without messing the current one up already. Can anybody help on this? thanks
Your best shot is too evaluate which tables are to colide and work out the sql accordingly.
vBulletin® v3.6.4, Copyright ©2000-2013, Jelsoft Enterprises Ltd.