Hi Guys,
I Just wanna seek your idea about installing SuiteCRM, i’am facing problem installing this though i already follow the instruction on the websites as well as it is successfully installed at the end there is some error appear in the site. what should i do or do i have to change some configurations. please help regarding on this just wanna try this opensource applications in our sales and marketing department
Hi Yam,
This looks like its all warnings and notices, you need to turn off the warnings and notices within the server settings.
notices and warnings are not errors which will cause any problems as long as they are not displayed out to the screen.
Ian.
Hi Ian,
sorry for the noob, question. how can i run SuiteCRM? though it is successfully installed can you instruct pls. so that i can test the application i don’t know how to do this is my first time i try this.
Thanks,
Yam
you will have used the following to install
http:////install.php
use the following to login
http:///
other questions might be able to be answered here.
This url might be able to help get you started.
Ian.
Hi Ian,
I already follow your instructions regarding on installing SuiteCRM. Below is the directory of the application
http://192.168.1.34:8080/suite/
still there is some notices appears, sorry but i don’t know how can i solve this, please help me.
Thanks,
Yam
You need to find the file “sugarcrm.log” and/or “suitecrm.log” and show the content of that file.
The last line “Database error. check your sugarcrm.log” is a little worrying.
Jobst
I did miss the database error on the last line. so yes this is a good place to start.
might be worth you turning off the display errors in the php.ini file if you have access. If you dont you will need to disable it another way.
by the way i’am using xampp as my backend for database. Still got this error, how can i resolve this.
Thanks,
Yam
Hi Jobst,
this is the content of my sugarcrm.log:
04/29/15 02:43:22 [4936][-none-][FATAL] Could not connect to DB server 192.168.1.34 as sa. port : Host ‘192.168.1.34’ is not allowed to connect to this MySQL server
04/29/15 02:43:22 [4936][-none-][FATAL] Could Not Connect: Database Is Not Connected
04/29/15 02:43:22 [4936][-none-][FATAL] Query Failed: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’ LIMIT 0,1: Database Is Not Connected
04/29/15 02:43:22 [4936][-none-][FATAL] Get One Failed:SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’: Database Is Not Connected
04/29/15 02:43:22 [4936][-none-][FATAL] Query Failed: SELECT version() version LIMIT 0,1: Database Is Not Connected
04/29/15 02:43:22 [4936][-none-][FATAL] Get One Failed:SELECT version() version: Database Is Not Connected
04/29/15 02:43:34 [4936][-none-][FATAL] Could not connect to DB server 192.168.1.34 as sa. port : Host ‘192.168.1.34’ is not allowed to connect to this MySQL server
04/29/15 02:43:34 [4936][-none-][FATAL] Could Not Connect: Database Is Not Connected
04/29/15 02:43:34 [4936][-none-][FATAL] Query Failed: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’ LIMIT 0,1: Database Is Not Connected
04/29/15 02:43:34 [4936][-none-][FATAL] Get One Failed:SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’: Database Is Not Connected
04/29/15 02:43:34 [4936][-none-][FATAL] Query Failed: SELECT version() version LIMIT 0,1: Database Is Not Connected
04/29/15 02:43:34 [4936][-none-][FATAL] Get One Failed:SELECT version() version: Database Is Not Connected
04/29/15 02:43:41 [4936][-none-][FATAL] Could not connect to DB server 192.168.1.34 as sa. port : Host ‘192.168.1.34’ is not allowed to connect to this MySQL server
04/29/15 02:43:41 [4936][-none-][FATAL] Could Not Connect: Database Is Not Connected
04/29/15 02:43:41 [4936][-none-][FATAL] Query Failed: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’ LIMIT 0,1: Database Is Not Connected
04/29/15 02:43:41 [4936][-none-][FATAL] Get One Failed:SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’: Database Is Not Connected
04/29/15 02:43:41 [4936][-none-][FATAL] Query Failed: SELECT version() version LIMIT 0,1: Database Is Not Connected
04/29/15 02:43:41 [4936][-none-][FATAL] Get One Failed:SELECT version() version: Database Is Not Connected
04/29/15 02:45:24 [4936][-none-][FATAL] Could not connect to DB server 192.168.1.34 as crmdb. port : Host ‘192.168.1.34’ is not allowed to connect to this MySQL server
04/29/15 02:45:24 [4936][-none-][FATAL] Could Not Connect: Database Is Not Connected
04/29/15 02:45:24 [4936][-none-][FATAL] Query Failed: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’ LIMIT 0,1: Database Is Not Connected
04/29/15 02:45:24 [4936][-none-][FATAL] Get One Failed:SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’: Database Is Not Connected
04/29/15 02:45:24 [4936][-none-][FATAL] Query Failed: SELECT version() version LIMIT 0,1: Database Is Not Connected
04/29/15 02:45:24 [4936][-none-][FATAL] Get One Failed:SELECT version() version: Database Is Not Connected
04/29/15 02:48:08 [4936][-none-][FATAL] Could not connect to DB server as crmdb. port : Access denied for user ‘crmdb’@‘localhost’ (using password: YES)
04/29/15 02:48:08 [4936][-none-][FATAL] Could Not Connect: Database Is Not Connected
04/29/15 02:48:08 [4936][-none-][FATAL] Query Failed: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’ LIMIT 0,1: Database Is Not Connected
04/29/15 02:48:08 [4936][-none-][FATAL] Get One Failed:SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ‘’: Database Is Not Connected
04/29/15 02:48:08 [4936][-none-][FATAL] Query Failed: SELECT version() version LIMIT 0,1: Database Is Not Connected
04/29/15 02:48:08 [4936][-none-][FATAL] Get One Failed:SELECT version() version: Database Is Not Connected
04/29/15 02:49:22 [4936][-none-][FATAL] Query Failed: CREATE DATABASE suitecrm CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1044: Access denied for user ‘’@‘localhost’ to database ‘suitecrm’
04/29/15 02:49:22 [4936][-none-][FATAL] Could not connect to DB server as crmdb. port : Access denied for user ‘’@‘localhost’ to database ‘suitecrm’
Thanks,
Yam
The first line in the log tells you everything
04/29/15 02:43:22 [4936][-none-][FATAL] Could not connect to DB server 192.168.1.34 as sa. port : Host '192.168.1.34' is not allowed to connect to this MySQL server
All other errors are BECAUSE of this error - You are NOT connected to the database hence every OTHER query will fail.
The problem you are having is based on many reasons:
You are better off to find answers to these question on any of the XAMPP forums, MYSQL forum or stackoverflow.
Jobst
Hi Jobst,
By the way i’am using xampp as my backend for my database. when i setup SuiteCRM there are no tables showed in the setup i just create a name of database.
Thanks,
William
This is what I wrote below, your SuiteCRM server/install cannot access the MYSQL server, your databases WILL BE EMPTY from the start onwards.
You need to learn and understand how to allow other hosts and users to access the databases on your MYSQL server, hence why I suggested to go to a XAMPP or MYSQL forum, further it is very well explained in this article on stackoverflow:
As an example I show you something like this:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
There are 100’s of different ways of allowing access to MYSQL but you should have some understanding how that works.
Jobst