How do i get out of this mess added a user to the data base cause clearly i have been issues with updating well went to update and used the new user and pass with all privledges. error screen came up saying to change debug to true so i did and got all this
Message:
SQLSTATE[28000] [1045] Access denied for user '*************'@'localhost' (using password: YES)
File:
/home/jodyhuth69/public_html/ow_core/database.php
Line:
226
Trace:
#0 /home/jodyhuth69/public_html/ow_core/database.php(256): OW_Database->__construct(Array)
#1 /home/jodyhuth69/public_html/ow_core/ow.php(239): OW_Database::getInstance(Array)
#2 /home/jodyhuth69/public_html/ow_core/base_dao.php(47): OW::getDbo()
#3 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_dao.php(66): OW_BaseDao->__construct()
#4 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_dao.php(55): BOL_ConfigDao->__construct()
#5 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_service.php(69): BOL_ConfigDao::getInstance()
#6 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_service.php(58): BOL_ConfigService->__construct()
#7 /home/jodyhuth69/public_html/ow_core/config.php(48): BOL_ConfigService::getInstance()
#8 /home/jodyhuth69/public_html/ow_core/config.php(68): OW_Config->__construct()
#9 /home/jodyhuth69/public_html/ow_core/ow.php(176): OW_Config::getInstance()
#10 /home/jodyhuth69/public_html/ow_core/ow.php(106): OW::getConfig()
#11 /home/jodyhuth69/public_html/ow_core/ow.php(151): OW::detectContext()
#12 /home/jodyhuth69/public_html/index.php(47): OW::getApplication()
#13 {main}
Type:
InvalidArgumentException
and now the site is stuck with the error screen
changed debug back to false and went back to where i started with this error
Something went wrong!
To get the error details follow these steps:
- Open ow_includes/config.php file and set DEBUG_MODE to true
- Reproduce your last action.
how can you reproduce the last action if you cant get back to where you started?
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
errors when updating | Forum
Leader Senior Developer
Mar 21 '17
Hi jody huth!
This is the error:Access denied for user '*************'@'localhost' (using password: YES)
1.- The new user must have read/write privileges for that database, make sure the new user does have such privileges.
2.- Double check that you entered the correct new user/password in ow_includes/config.php
Senior Developer.
The Forum post is edited by Senior Developer Mar 21 '17
jody huth
Mar 21 '17
I went ahead and deleted that user from the data base the original user is still there whats a solution to bring the site back to view able? here is the url http://www.stangdrvn.us
Leader Senior Developer
Mar 21 '17
The website is still giving error 500.
Please do this:
1.- Open ow_includes/config.php file and set DEBUG_MODE to true
2.- Open the index page http://www.stangdrvn.us
Copy and paste the error that will be displayed.
If the error remains the same, double check that you have the original database's user/password in ow_includes/config.php and that the user still does have read/write permissions
I think that now is a good time to make a full backup of all your files and database just in case somethinggoes wrong.
The Forum post is edited by Senior Developer Mar 21 '17
jody huth
Mar 21 '17
Message:
SQLSTATE[28000] [1045] Access denied for user 'i1786220_oxwa1'@'localhost' (using password: YES) File: /home/jodyhuth69/public_html/ow_core/database.php Line: 226 Trace: #0 /home/jodyhuth69/public_html/ow_core/database.php(256): OW_Database->__construct(Array) #1 /home/jodyhuth69/public_html/ow_core/ow.php(239): OW_Database::getInstance(Array) #2 /home/jodyhuth69/public_html/ow_core/base_dao.php(47): OW::getDbo() #3 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_dao.php(66): OW_BaseDao->__construct() #4 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_dao.php(55): BOL_ConfigDao->__construct() #5 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_service.php(69): BOL_ConfigDao::getInstance() #6 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_service.php(58): BOL_ConfigService->__construct() #7 /home/jodyhuth69/public_html/ow_core/config.php(48): BOL_ConfigService::getInstance() #8 /home/jodyhuth69/public_html/ow_core/config.php(68): OW_Config->__construct() #9 /home/jodyhuth69/public_html/ow_core/ow.php(176): OW_Config::getInstance() #10 /home/jodyhuth69/public_html/ow_core/ow.php(106): OW::getConfig() #11 /home/jodyhuth69/public_html/ow_core/ow.php(151): OW::detectContext() #12 /home/jodyhuth69/public_html/index.php(47): OW::getApplication() #13 {main} Type: InvalidArgumentException
ok in the config .php file the pass is different for the data base is that due to md5 ?
SQLSTATE[28000] [1045] Access denied for user 'i1786220_oxwa1'@'localhost' (using password: YES) File: /home/jodyhuth69/public_html/ow_core/database.php Line: 226 Trace: #0 /home/jodyhuth69/public_html/ow_core/database.php(256): OW_Database->__construct(Array) #1 /home/jodyhuth69/public_html/ow_core/ow.php(239): OW_Database::getInstance(Array) #2 /home/jodyhuth69/public_html/ow_core/base_dao.php(47): OW::getDbo() #3 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_dao.php(66): OW_BaseDao->__construct() #4 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_dao.php(55): BOL_ConfigDao->__construct() #5 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_service.php(69): BOL_ConfigDao::getInstance() #6 /home/jodyhuth69/public_html/ow_system_plugins/base/bol/config_service.php(58): BOL_ConfigService->__construct() #7 /home/jodyhuth69/public_html/ow_core/config.php(48): BOL_ConfigService::getInstance() #8 /home/jodyhuth69/public_html/ow_core/config.php(68): OW_Config->__construct() #9 /home/jodyhuth69/public_html/ow_core/ow.php(176): OW_Config::getInstance() #10 /home/jodyhuth69/public_html/ow_core/ow.php(106): OW::getConfig() #11 /home/jodyhuth69/public_html/ow_core/ow.php(151): OW::detectContext() #12 /home/jodyhuth69/public_html/index.php(47): OW::getApplication() #13 {main} Type: InvalidArgumentException
ok in the config .php file the pass is different for the data base is that due to md5 ?
Leader Senior Developer
Mar 21 '17
You have to set your correct values in ow_includes/config.php
define('OW_DB_USER', 'yourDatabaseUser');
define('OW_DB_PASSWORD', 'yourDatabasePassword');
This values are the database user and database password.
I have one question, did you make changes on this file before the update or before everything was messed up?
I'm reading your first post, what do you mean by: "used the new user and pass with all privledges"
Could you explain what did you do and the exact steps that you did do?
The Forum post is edited by Senior Developer Mar 21 '17
Leader Senior Developer
Mar 21 '17
You need to set the password in plain text, not encrypted.
The Forum post is edited by Senior Developer Mar 21 '17
jody huth
Mar 21 '17
could never get the site to do updates and user and pass for ftp never changed so i created a new user for the database then used that name and pass in the update box to try that yes tried to call the data base directly probably my fault. then got all the errors and now im just trying to get the site back up atleast i will have the initial site but wont be able to add plugins or updates like it was before
Leader Senior Developer
Mar 21 '17
If you already did changed the db user and password in config file and still have the same issue, you better do a backup of all your files/database and move on from that hosting to another hosting provider, it looks like there is something broken in your hosting account. Maybe if you ask to your hosting provider they can be able to tell you what could be wrong.
We can't know if the hosting is broken until you move into another hosting provider.
The issue is that the website is trying to connect to the database with the user/password that is in the config.php file, so the error says that you cannot acces to the database with that user/password. That simple.
One last thing that you may try is to make a database backup.
Make a new database, and new user/password with privileges for that database or give privileges to an existing user, restore the old database into the new one, and finally, change the user/password in config.php file.
Leader Senior Developer
Mar 21 '17
The user/password from the new ftp account is not the same than the user from MySQL account, the config.php needs mysql user/password.
