+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: Error connecting to the Mysql server (/showthread.php?tid=4049)
- Nathx3 - 10-03-2014
Hello,
I get that Error when opening my homepage.
Error connecting to the Mysql server
If your the admin please check your config settings.
If your not then there is no connection to Mysql sorry, come back later.
-LC-CMS By ToXiC L33T-
My config.php file should be correct.
I tried both IP's 127.0.0.1 and my root ones(HP is on the same root as my lc server)
I also restarted the httpd
and the mysql username and password is also correct ( I use the same which I use with navicat )
already tried with creating new user,didn't work also
any tip?
Greetings,
- BayBay - 10-03-2014
I think you are using Max outdated website... Use version 3.6.2.....
your config has to be something like this :
// Show PHP Errors
error_reporting(E_ALL);
ini_set('display_errors', '0'); // change 0 = off 1 = on
// Your Name
$server_owner = 'yourname';
// Mysql IP
$LCSET['cms_host'] = 'your server ip'; // dns or ip
// Mysql Login
$LCSET['cms_username'] = 'your mysql username'; // Mysql username
$LCSET['cms_password'] = 'your mysql password'; // Mysql password
YOUR Mysql dabatases name of course
// Mysql Databases
$LCSET['cms_lc_auth'] = 'newproject_db_auth'; // auth database
$LCSET['cms_lc_db'] = 'newproject_db'; // db database
$LCSET['cms_lc_data'] = 'newproject_data'; // data database
$LCSET['cms_lc_site'] = 'cms_demo'; // Website Database Name
Make sure your mysql username and password is correct...
- Nathx3 - 10-03-2014
Everything is correct,or?
And yes, I'm using version 3.6.2
Mysql Username and pw are definitly correct
Any tips?
- BayBay - 10-03-2014
Everything is correct,or?
And yes, I'm using version 3.6.2
Mysql Username and pw are definitly correct
Any tips?
2 questions:
1. Is your mysql username root ?
2. Did u executed website sql file in navicat?
- Wizatek - 10-04-2014
What you can try to do is look in /var/log/httpd/error.log
sometimes you might find some php errors there.
If your the admin please check your config settings.
If your not then there is no connection to Mysql sorry, come back later.
- Nathx3 - 10-04-2014
Hello, thanks for trying to help me
@BayBay
Yes, my sql username is root and the password i put in is correct.
I also created a database named cms and cms_demo and executed the DB from the LC-CMS 3.6.2
(Why twice? To test if that was the error)
@Wizatek
[Fri Oct 03 21:24:58 2014] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 configured -- resuming normal operations
[Fri Oct 03 22:12:05 2014] [error] [client 77.176.186.171] File does not exist: /var/www/html/favicon.ico
[Fri Oct 03 22:36:08 2014] [error] [client 50.23.43.242] attempt to invoke directory as script: /var/www/cgi-bin/
[sat Oct 04 02:05:31 2014] [error] [client 71.6.135.131] File does not exist: /var/www/html/robots.txt
[sat Oct 04 11:33:38 2014] [error] [client 146.71.111.226] attempt to invoke directory as script: /var/www/cgi-bin/
[sat Oct 04 11:33:41 2014] [error] [client 146.71.111.226] script not found or unable to stat: /var/www/cgi-bin/tell
[sat Oct 04 12:38:05 2014] [error] [client 197.216.0.32] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /tmUnblock.cgi
[sat Oct 04 12:42:36 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/script
[sat Oct 04 12:42:36 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/jenkins
[sat Oct 04 12:42:36 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/hudson
[sat Oct 04 12:42:36 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/login
[sat Oct 04 12:42:37 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/jenkins
[sat Oct 04 12:42:37 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/hudson
[sat Oct 04 12:42:37 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/jmx-console
[sat Oct 04 12:42:37 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/manager
[sat Oct 04 12:42:38 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/msd
[sat Oct 04 12:42:38 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/mySqlDumper
[sat Oct 04 12:42:38 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/msd1.24stable
[sat Oct 04 12:42:38 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/msd1.24.4
[sat Oct 04 12:42:38 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/mysqldumper
[sat Oct 04 12:42:38 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/MySQLDumper
[sat Oct 04 12:42:38 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/mysql
[sat Oct 04 12:42:38 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/sql
[sat Oct 04 12:42:39 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/phpmyadmin
[sat Oct 04 12:42:39 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/phpMyAdmin
[sat Oct 04 12:42:39 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/mysql
[sat Oct 04 12:42:39 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/sql
[sat Oct 04 12:42:39 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/myadmin
[sat Oct 04 12:42:39 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/phpMyAdmin-4.2.1-all-languages
[sat Oct 04 12:42:39 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/phpMyAdmin-4.2.1-english
[sat Oct 04 12:42:39 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/sqlite
[sat Oct 04 12:42:40 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/SQLite
[sat Oct 04 12:42:40 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/SQLiteManager-1.2.4
[sat Oct 04 12:42:40 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/sqlitemanager
[sat Oct 04 12:42:40 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/SQlite
[sat Oct 04 12:42:40 2014] [error] [client 217.70.189.134] File does not exist: /var/www/html/SQLiteManager
[sat Oct 04 13:11:16 2014] [error] [client 146.71.111.226] attempt to invoke directory as script: /var/www/cgi-bin/
That are the last messages from the var/log/httpd/error.log