Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2017-11-07, 21:17:20

Author Topic: Could not open database connection.  (Read 1411 times)

0 Members and 1 Guest are viewing this topic.

Offline pazesmass

  • Junior Member
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Could not open database connection.
« on: 2013-07-25, 20:54:13 »
Installed Kloxo MR without any errors.
Opened {ip}:7778 in my browser to log in and there is just a blank screen and the message 'Could not open database connection.'

When i try to start the mysql service (service mysql start) I get this response
Code: [Select]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

I found a similar question here:
http://mybb.mratwork.com/showthread.php?tid=281
And when I run 'mysql -u root -p' and enter the password i get this response:
Code: [Select]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

Note: The file '/var/lib/mysql/mysql.sock' does not exist
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Could not open database connection.
« Reply #1 on: 2013-07-25, 21:47:37 »
Try 'mksock /var/lib/mysql/mysql.sock'.

Also inform 'cat /etc/my.cnf' and 'mysql -V'
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline pazesmass

  • Junior Member
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Could not open database connection.
« Reply #2 on: 2013-07-25, 22:21:43 »
Quote from: "MRatWork"
Try 'mksock /var/lib/mysql/mysql.sock'.

Also inform 'cat /etc/my.cnf' and 'mysql -V'

Still the same.

When I run 'mysql -V' I get this:
Code: [Select]
mysql  Ver 14.14 Distrib 5.5.29, for Linux (x86_64) using readline 5.1

and this 'cat /etc/my.cnf':
Code: [Select]
[mysqld]
# Settings user and group are ignored when systemd is used (fedora >= 15).
# If you need to run mysqld under different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
user=mysql

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Semisynchronous Replication
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so

# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1

# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline pazesmass

  • Junior Member
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Could not open database connection.
« Reply #3 on: 2013-07-26, 22:43:18 »
Solved it...The problem is not related to kloxo. You can delete the topic
« Last Edit: 1970-01-01, 01:00:00 by Guest »

 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo
Click Here

Page created in 0.032 seconds with 16 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM