DATABASE

Author	« Topic »
egrussell Advanced Member USA 108 Posts Pre-sales questions only (More Details...)	Posted - 06/10/2019 : 08:10:06 I have installed a generic version at subfolder /cart I have setup a database in cPanel using PHPMyAdmin I have setup /cart/createdb.php with the correct settings When I browse to /cart/vsadmin/admin.php I get the following error: Database Connect Error (1045) Access denied for user 'onlineic_ectun1'@'localhost' (using password: YES) You need to set your database connection in vsadmin/db_conn_open.php When I view the new database setup using PHPMyAdmin the database is there but shows no tables.
Andy ECT Moderator 95440 Posts	Posted - 06/10/2019 : 08:14:17 Hi Ear Can you check the user onlineic_ectun1 has full permissions for the database and that the db_host is definitely localhost (it probably is but you can check that as well) Andy Please feel free to review / rate our software
egrussell Advanced Member USA 108 Posts Pre-sales questions only (More Details...)	Posted - 06/10/2019 : 11:24:51 I have created a database in cPanel using phpMyAdmin with localhost, username, dbname and password and gave it full permissions. The database and username shows up in the cPanel correctly, but when I open phpMyAdmin, it lists the new database, but I get a "No tables found in database" message for the new database.
Andy ECT Moderator 95440 Posts	Posted - 06/10/2019 : 11:43:40 Did you open createdb.php in the browser and run that? Andy Please feel free to review / rate our software
egrussell Advanced Member USA 108 Posts Pre-sales questions only (More Details...)	Posted - 06/10/2019 : 11:52:40 I ran /cart/createdb.php and got the same errors!
Andy ECT Moderator 95440 Posts	Posted - 06/10/2019 : 12:17:03 You haven't mentioned editing db_conn_open.php with db name, username etc. Did you do that? Andy Please feel free to review / rate our software
egrussell Advanced Member USA 108 Posts Pre-sales questions only (More Details...)	Posted - 06/11/2019 : 05:47:53 I deleted the original database and user last night. This morning I created a database with new db name, new DB user, new db password and using local host and updated /vsadmin/db_conn_open.php. This worked and the ECT tables were installed! Next I browsed to: /cart/vsadmin/admin.php and the login request for username and password appeared. I can't figure out what they are. How do I get the correct admin username and password? Btw, https://onlineinspectorcertifications.com/cart/index.php now also works!
Andy ECT Moderator 95440 Posts	Posted - 06/11/2019 : 05:50:31 The default is User: mystore Password: changeme Andy Please feel free to review / rate our software
egrussell Advanced Member USA 108 Posts Pre-sales questions only (More Details...)	Posted - 06/11/2019 : 06:00:12 Everything is now working, thanks for all of your help! I guess you work long hours also!
	« Topic »