Database Help!!

phpVMS Legacy Support
21

I am having the same error trying to install the tables to my database.

I am using a paid service (HostGator), have the database and user set up properly, and getting the error

Fatal error : Uncaught <blockquote><font face=arial size=2 color=000099><b>Last Error –</b> [<font color=000000><b>Access denied for user ‘ova’@‘localhost’ (using password: YES) (1045)</b></font>]<br />[<font color=000000></font>]</font><p> </blockquote><hr noshade color=dddddd size=1> thrown in /home2/spin/public_html/Aviation/phpVMS/core/classes/ezdb/ezdb_mysql.class.php on line 99

I click “Check Database Connection” and nothing happens.

I click “Next Step” and get the error above.

I have verified the password, even copied-and-pasted it into the installer form.

The error message looks like it is accessing a file on my computer. Is that correct? It is in the folder specified.

What should I be looking for?

22

Oops - I had it backwards. Here is the path.

core/local.config.php

Look for the section below.

define(‘DBASE_USER’, ‘xxxxxxxxxxxx’);
define(‘DBASE_PASS’, ‘xxxxxxxxxxxx’);
define(‘DBASE_NAME’, ‘xxxxxxxxxxx’);
define(‘DBASE_SERVER’, ‘localhost’);
define(‘DBASE_TYPE’, ‘mysql’);

Interesting. Mine just says:

<?php

I copied and pasted the lines from your quote and entered he information, and still got the error.

I hope to have this up and running while on vacation this week. Does anyone know how to get this to work?

23

local.config.php is empty because you have not processed with the phpVMS installation. Re-upload the files, visit your website url and follow the installation steps in this page.

24

I deleted the old phpVMS folder from the host and posted a fresh install, and following the phpvms for Dummie’s Guide, ran the install.php file, and get

Fatal error : Class ‘DB’ not found in /home2/spin/public_html/Aviation/phpVMS/core/common/SettingsData.class.php on line 28

26

I read through all of those links, but couldn’t find that error code or any way of fixing it.

One thing I notice that may be causing a problem is the installer is looking for a database with the “phpvms_” prefix, while my host names databases with my “userid_”. Would that make a difference? Does the installer only recognize db’s with the phpvms_ prefix?

I hope I can get my VA back in the air soon, hopefully with phpvms.

27

I read through all of those links, but couldn’t find that error code or any way of fixing it.

One thing I notice that may be causing a problem is the installer is looking for a database with the “phpvms_” prefix, while my host names databases with my “userid_”. Would that make a difference? Does the installer only recognize db’s with the phpvms_ prefix?

I hope I can get my VA back in the air soon, hopefully with phpvms.

I had this error and I had to give permission for the database to give access to the website domain. This is done through the your hosting service. Let me know if that works.

28

OK tried that and got this errorI might have to try a different program

Fatal error : Uncaught <blockquote><font face=arial size=2 color=000099><b>Last Error –</b> [<font color=000000><b>Access denied for user ‘spin_ova’@‘localhost’ to database ‘spin_phpvbs_ova’ (1044)</b></font>]<br />[<font color=000000></font>]</font><p> </blockquote><hr noshade color=dddddd size=1> thrown in /home2/spin/public_html/Aviation/phpVMS/core/classes/ezdb/ezdb_mysql.class.php on line 140

I might have to try a different program

29

Make sure that your password for your database user inside the file of core/local.config.php is set properly.

In regards to your table prefix question, you can change it upon setup via the installer, just change it from phpvms_ to userid_

local.config.php should look like this

define('DBASE_USER', 'DATABASEUSERHERE');
define('DBASE_PASS', 'DATABASEPASSWORDHERE');
define('DBASE_NAME', 'DATABASENAMEHERE');
define('DBASE_SERVER', 'localhost'); // change localhost if your hosting uses a different server
define('DBASE_TYPE', 'mysqli'); // if you're using Simpilot's phpvms 5.5.x use mysqli, otherwise use mysql
define('TABLE_PREFIX', 'phpvms_'); // change phpvms_ to userid_ if you have setup all your tables that way
Change DATABASEUSERHERE, DATABASEPASSWORDHERE, DATABASENAMEHERE to the correct information specified in cPanel (or similar)
30

local.config.php just had a couple characters in it, so I pasted the text above into it, and changed the parameters.

That info is also entered in /phpVMS/install/install.php when I try to run it.

I get the same error message, ending in " ezdb_mysql.class.php on line 140"

The database is on the same hosting service as the site I am installing from. That shouldn’t be an issue.

31

local.config.php just had a couple characters in it,

Do you mind pasting in your local.config.php (the whole file) or http://pastebin.com/ it?

And please XXXX the sensitive information (database info)

I had this error and I had to give permission for the database to give access to the website domain

trygeboy has a point, make sure that your database user has the correct password for the user you are using, if not it might be worthwhile changing it and keeping a first-hand copy to make sure that the information for the user is correct.

32

All it says is

<?php

even after I run the installer.

Now, the only thing I see that could be causing a problem is HostGator uses my userid as a prefix for the database name spin_phpvbs_xxxxx and I don’t think this program recognizes it. Even if I try to rename it, it still has the spin_ prefix.