Sentora Support Forums
Socks Problems SQL - Printable Version

+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: Socks Problems SQL (/showthread.php?tid=3793)



Socks Problems SQL - JimKnopf - 06-05-2017

Hello dear Sentora community. Now i am here.
I thought i can safe me this part, but ...

Long words small sense.

I can connect to sentora phpmyadmin.

If i want install, wordpress or other scripts, the login form/db connect tells me: Cant connect db

/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Access denied for user 'dbuser'@'localhost' (using password: YES)

Need your support.

I knowsentora, that i install the software, configure it fastĀ and can start/install other software.

Where the problem is? Cant fix it.
Greetings


RE: Socks Problems SQL - TGates - 06-05-2017

It tells you what is wrong: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Is it running? Does the file mentioned exist? If so, what are the file's permissions.


RE: Socks Problems SQL - JimKnopf - 06-05-2017

(06-05-2017, 07:38 AM)TGates Wrote: It tells you what is wrong: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Is it running? Does the file mentioned exist? If so, what are the file's permissions.

Exist!
Running!

# sudo /etc/init.d/mysql start
start: Job is already running: mysql

But i had problems during installation. Have to uninstall apache2 and bind9 to install sentora.

As you can see, phpmyadmin can connect.
Only with uploaded software and this db connect,
i get always problems.

Tried different OS (Ubuntu 16/14 (32|64), CentOs)
Greetings

(06-05-2017, 07:16 PM)JimKnopf Wrote: ------------------
FIXED
------------------

Think i have the problem found.
Have restared mysql with

sudo stop mysql
sudo start mysql
........
NOTE: A SERVER REBOOT FIX THIS PROBLEM NOT!
ONLY THE PROCESS STOP/RESTART FIX IT AFTER AN NEW INSTALLATION (!)
I think, this problems comes with deinstalling apache2 and bind9, see above|beyond.

[ apt-get purge apache2*
apt-get purge bind9*
]

Now i can install WP as a sample installation.
........

When problems are ... i know where i can find you.
Greetings

-------------

-Temporarely closed, problem could self fixed -



RE: Socks Problems SQL - TGates - 06-06-2017

Ok, glad you have sorted it out and everything is running OK. Keep us updated if any changes.