Search for the values db_ which should produce a list like
You should be able to update the password in the CRM by opening the file called “config.php”
In this file there will be an array called dbconfig that looks like:
'dbconfig' =>
array (
'db_host_name' => '',
'db_host_instance' => '',
'db_user_name' => '',
'db_password' => '',
'db_name' => '',
'db_type' => '',
'db_port' => '',
'db_manager' => '',
If the details here are correct please check the PHP access and error logs for any information that may be related and provided them here
What is your Site_URL set to in the config.php file? Did you check for correct path?
Do you have .htacess file in the CRM Root ? what is the Base path set there?
Can you access you DB via some program on server like PHP MyAdmin ?
For AWS the host looks something like mysql–instance1.123456789012.us-east-1.rds.amazonaws.com so can you try to set your instance path in config
‘db_host_name’ => ‘YOUR_INSTANCE’,
So I ran sudo dpkg-reconfigure -plow phpmyadmin to fix the PhpMyAdmin issue. Once I had fixed phpMyAdmin I could see what the problem was. My database file was empty. Apparently I accidentally exported the new db (empty tables) over my existing sql file, instead of importing it the other way around… haha… I got it fixed now…
Thank you for all your troubles, and I am terribly sorry for the all inconvenience
Everything is up and looks good, but the Quick Repair & Rebuild tool doesn’t work. I get the error Database failure. Please refer to suitecrm.log for details.
Is there something I am missing?
This is what the log says, I don’t see anything unusual, except that there is a missing relationship, which I built again.
If you are migrating over and ‘rebuilding’ the instanced based on either a fresh database then you may need to take your time with the SQL repair & rebuild.
What I can see on your screen is there is a lot of SQL to execute. I would work your way through that SQL statement by statement so that you can rebuild the database in phases.
The error that is appears is the users_feed table. Perhaps execute the code (within that editable box) up until the users_feed and see if anything is wrong with the statement.
The alternative is to execute this SQL code in the PHPMyAdmin to see why it is failing.
Hi Samus,
How can I do this? Is there a way i can just copy paste and run it all thru altogether? haha… or will I have to run it individually for each table?
Perhaps not all the statements one by one but up until the users_feeds in the Repair & Rebuild screen you see. You could probably do it in chunks narrowing down the problematic tables.
Further to this. You could if you wanted execute the SQL in the Repair & Rebuild screen by click EXECUTE. That is why the text box with the SQL is editable. Else copy the SQL and inserted it via PHPMyAdmin console for that particular database.
So I tried running this on both backend and phpMyAdmin.
I saw that everytime it included the users_feeds table I got the error about Database Failure. But when I took it off and executed everything else, I get the status “Database Tables are synced with vardefs”.
What does that mean?
The user_feeds alter statement is as below
ALTER TABLE users_feeds modify COLUMN rank int(11) NULL ;
The immediate solution would be to manually execute this query via the Quick Repair & Rebuild field or PHPMyAdmin quotating the rank with backticks.
*seems discourse dislikes backticks as it uses it for code snippets XD
Oh on the final note the status of : Database Tables are synced with vardefs ” indicates that the databases have been rebuild matching the vardefs. and other defs. Meaning the two sources should be A-OK.
I still get can’t repair from SuiteCRM. This is what the suitecrm.log show up.
Does it make sense?
Tue Jun 30 04:07:01 2020 [177858][1][FATAL] Mysqli_query failed.
Tue Jun 30 04:07:01 2020 [177858][1][FATAL] Executing repair query: Query Failed: ALTER TABLE users_feeds modify COLUMN rank int(11) NULL: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank int(11) NULL' at line 1
Tue Jun 30 04:07:01 2020 [177858][1][FATAL] Exception handling in /var/www/cms/include/MVC/Controller/SugarController.php:400
Tue Jun 30 04:07:01 2020 [177858][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tue Jun 30 04:07:01 2020 [177858][1][FATAL] backtrace:
#0 /var/www/cms/include/database/DBManager.php(353): sugar_die()
#1 /var/www/cms/include/database/DBManager.php(328): DBManager->registerError()
#2 /var/www/cms/include/database/MysqliManager.php(179): DBManager->checkError()
#3 /var/www/cms/modules/Administration/repairDatabase.php(95): MysqliManager->query()
#4 /var/www/cms/include/MVC/View/SugarView.php(834): include_once('/var/www/cms/mo...')
#5 /var/www/cms/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile()
#6 /var/www/cms/include/MVC/View/SugarView.php(226): ViewClassic->display()
#7 /var/www/cms/include/MVC/Controller/SugarController.php(435): SugarView->process()
#8 /var/www/cms/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#9 /var/www/cms/include/MVC/SugarApplication.php(113): SugarController->execute()
#10 /var/www/cms/index.php(52): SugarApplication->execute()
#11 {main}
!
