0
votes
1answer
18 views

Apache can't connect to remote MySQL, but mysql command line from same server can

Symptoms: I am running CentOS 6. I can connect to the remote MySQL from the command line: mysql -h a.b.c.d -u user -p -D db. Laravel artisan commands run on the local command line can also connect: ...
0
votes
2answers
38 views

cent os fail to install mysql-devel

I want to install python-mysqldb. But it tells me that I must install mysql-devel first, and then I have this problem: [root@iamca yum.repos.d]# yum install mysql-devel Loaded plugins: fastestmirror, ...
-5
votes
0answers
29 views

PHPMyAdmin shows blank screen after logging in [on hold]

Since moving to a new VPS - we have been having issues accessing PHPMyAdmin. We have 15 websites (and cPanel accounts) hosted on this new VPS and PHPMyAdmin only works in two of the cPanels. No ...
-1
votes
1answer
56 views

MariaDB 10.x on CentOS 7?

Why there is no MariaDB 10.x RPM for CentOS/RedHat 7? I'm trying to install the most recent stable version on my server, but it seems, that official repo is absent for so long since release. Why? ...
2
votes
1answer
35 views

MySQL replication slowing master

We are currently running MySQL 5.1 Quick Overview We use 5 web servers ( Apache ) all connected to 1 DB server ( MySQL ) hosted on the cloud. The DB server running on the cloud ( Master ) ...
0
votes
2answers
181 views

No mysqld or mysql.server after mariadb-server install

So... likely I'm an idiot, but I'm stuck. I just set up a CentOS 7 on Digial Ocean and I can't seem to get the MariaDB/MySQL server running. Some output [root@hostname ~]# yum list installed |grep ...
-4
votes
2answers
142 views

Error MySQL CentOS - Starting MySQLCouldn't find MySQL server

I can not make any operation in mysql: root@server2 [/]# /etc/init.d/mysql status MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED] root@server2 [/]# /etc/init.d/mysql start ...
0
votes
1answer
107 views

Upgrade PHP-mysql Lib Centos 6 [duplicate]

I just delete all php and mysql and installed it again. but in PHPMyadmin i still get: Your PHP MySQL library version 5.1.69 differs from your MySQL server version 5.5.39. This may cause ...
0
votes
2answers
87 views

Centos Your PHP MySQL library version 1.5.73 differs from your MySQL server version 5.5.39 [duplicate]

I have recently updated my PHP version to 5.4 and my mysql version to 5.5 [root@**** ~]# php -v PHP 5.4.31 (cli) (built: Jul 25 2014 07:41:53) Copyright (c) 1997-2014 The PHP Group Zend Engine ...
0
votes
1answer
57 views

Centos mysql version is 5.5 however PHPmyadmin still says version 5.1

When i run the following in my console: [root@****~]# mysql -u root -p -e 'SELECT VERSION();' Enter password: +-----------+ | VERSION() | +-----------+ | 5.5.39 | +-----------+ Which should be ...
0
votes
1answer
217 views

mysql “no packages marked for update” in Centos

From the following guide i have been trying to update mysql on my Centos server: http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/updating-yum-repo.html My current mysql version is: ...
0
votes
2answers
151 views

Why won't iptables allow MySQL connections?

For some reason mysql connections from a specific IP address aren't allowed. This is the rule I have (grabbed from iptables-save): -A INPUT -s 12.34.56.78/32 -p tcp -m state --state NEW -m multiport ...
2
votes
2answers
113 views

403 Forbidden when trying to access a folder in document root of nginx

When I access index.php, it works fine. But on localhost/pset7, it gives a 403. Here is the permission log, -rw-r--r--. 1 root root 51 Jul 31 14:21 index.html -rw-r--r--. 1 root ...
-1
votes
2answers
126 views

CENTOS Vs Windows 2008 R2

We have an application running on Windows Server 2008 R2 with Apache WAMP, Tomcat, Mysql, PHP and java SE for last 4 years. Its a Web based ERP application. I would like to know if it makes sense to ...
3
votes
2answers
199 views

Cannot Establish Remote Connection to MYSQL Database

want to access the MYSQL database remotely but when checking on yougetsignal(dot) com I get a message that port 3306 is closed. Configuration: Fresh Server (Centos 6.4 64 bit with Zpanel installed) ...
0
votes
0answers
61 views

Unable to create the initial Zenoss object database

trying to setup Zenoss in Centos. Couldn't initialize the Zenoss due to below error /etc/init.d/zenoss start Zenoss not initialized. Performing first-boot initialization... Fresh install pre steps ...
1
vote
2answers
217 views

php pdo connection cannot be established, but mysql command line client can

situation as follows: php script on server a, run by user 'web' (nginx + php-fpm) should access mysql on server b via pdo library, but gets SQLSTATE[HY000] [2003] Can't connect to MySQL server on ...
0
votes
2answers
64 views

resetting iptables seems to make connections clear faster

I have iptables setup on 2 servers. Server#1 is public and Server#2 only allows the ip address of Server#1 to have ACCESS. Server#2 has a mySQL database that Server#1 queries. I ran a query and it ...
2
votes
3answers
615 views

CentOS (rel6) with default python 2.6, but seperate 3.3.5 installation

I have a CentOS server (rel6) that had python installed (2.6), but I needed a few features in 3.3+. I installed 3.3 into a seperate folder and made a symbolic link to execute it: I installed setup ...
0
votes
0answers
66 views

high mysqld cpu usage after moving to new server

Just moved to a new (more powerful) server with only one website running on it, no changes on the website, but now I got a horrible high CPU load and I can't find out why. top: top - 22:54:08 up 1 ...
1
vote
1answer
545 views

How to install MySQL 5.1 libraries on Ubuntu 14.04 or CentOS?

I've got two VMs: CentOS 6.5 and Ubuntu Server 14.04. Neither of their package management systems has the MySQL 5.1 libraries available (they both have MySQL 5.5). I need to know how to install the ...
0
votes
1answer
238 views

Plesk error when adding a subscription: ODBC error #08S01 can't connect to local MySQL

I'm getting this error after updating MySQL to 5.6 (Plesk 11.5, fresh installation) using the official MySQL repository right after adding a new subscription. Internal error: ODBC error #08S01: ...
0
votes
1answer
39 views

Linux CentOS dedicated server, process is dissapearing from WHM process manager

I have a script running on my dedicated server /usr/bin/php/home/user/public_html/myscript.php. When I log in to WHM/Process Manager, sometimes this script disappears from the list. Also, when I log ...
0
votes
1answer
58 views

How do I make a program start up automatically on reboot?

I am currently renting a VPS that is running CentOS 6.5. I am using it to run a basic forum site, and obviously, I need a web server and MySQL to power that. I have chosen Apache for my web server, ...
1
vote
0answers
70 views

Transfer user data of a Tigase server

I'm trying to transfer a Tigase XMPP server from an Ubuntu VPS to a CentOS VPS. Unfortunately there isn't any official documentation available and I need to experiment in order to preserve all of the ...
3
votes
1answer
280 views

RPM that installs to /opt/rh

I've noticed that the "mysql55" RPMs in the standard CentOS 5.10 repository install everything to /opt/rh. Is it expected that an end user might change this location somehow? It creates complications ...
0
votes
2answers
96 views

How do I prevent a website on my server causing the whole server to crash

I have a server with 6GB of RAM and a 6-Core CPU. Number of websites hosted by the server is about 10, but sometimes 2 of them take 100% CPU and almost entire RAM which cause the whole server to crash ...
1
vote
1answer
109 views

5-7 second latency between Apache server and MySQL server when website calls on database server

I am currently running a virtualized environment for my web and db server. When I access the web server or the MySQL server individually, they are both fast. I also have websites running on the web ...
0
votes
1answer
102 views

Configure Monit to delete /var/lib/mysql/mysql.sock after abrupt Centos6.5 machine shutdown

I have Monit monitoring Mysql. When the machine shuts down abruptly eg a power failure, mysqld cannot be restarted unless /var/lib/mysql/mysql.sock is deleted, due to the error Another MySQL daemon ...
1
vote
1answer
1k views

Mysql high memory usage and using swap

I have a 1.6GB database that adds about 200MB of size every month. I have a 12GB RAM(shared with apache, mysql and os), mysql always uses swap that i need to restart the service once it reached the ...
0
votes
1answer
48 views

How to determine what memory was freed

We have a somewhat complex LAMP stack running a variety of websites using Litespeed instead of Apache on Centos 5. Once everything is up and running, the memory usage of the system is fairly ...
0
votes
0answers
84 views

MySQL keeps dying for no apparent reason

I'm looking after a VPS with the following specifications: Centos 6, 50GB HDD & 512MB memory. The problem I'm having is MySQL keeps on crashing for no apparent reason. I've double checked the log ...
1
vote
1answer
398 views

MySQL demon already running with same unix socket

When trying to start the mysqld demon on a CentOS 6.5 box I get the following error: [root@hardin ~]# service mysqld start Another MySQL daemon already running with the same unix socket. Starting ...
0
votes
1answer
70 views

mysql.slow.log is not created even though it's configured in /etc/my.cnf , what could be the reason?

This is the relevant section from /etc/my.cnf: [mysqld] slow-query-log = ON long_query_time = 2 log_slow_queries = /var/log/mysql-slow.log The problem is that file is ...
0
votes
1answer
125 views

centos 6.4 install mysql [duplicate]

I have centos 6.4 64 bit and I accidently uninstalled my php-mysql extension, as a result my wordpress site is down. I need to install php-mysql (note, I prefer to get mysqlnd, but first I just need ...
0
votes
1answer
175 views

CentOS 5.8 - The most difficult MySQL installation ever?

To install I did: yum --enablerepo=remi,remi-test install mysql mysql-server Result of the last 3 lines: Installed: mysql-server.x86_64 0:5.0.95-5.el5_9 Complete! Then I did the following: ...
0
votes
1answer
338 views

Cent OS - MySQL Daemon failed to start [closed]

I'm running AWS micro instance with 0.615 GB Memory. I have APC running on it with 35 MB size max as default. Now I have restarted mysqld and it wont start. It has just stopped. I really need to get ...
-1
votes
1answer
1k views

Best Apache & MySQL config for 16GB and 8 Cores [closed]

I'm having some trouble with my servers. I'm having a peak and my servers load are very high. I have 3 servers, one for frontend, one for database (mysql) and one for delivery images (no problem with ...
1
vote
0answers
256 views

mysql binlog error “ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 341, event_type: 2 **”

I am new in mysql binary log and replication .Please help me sort this issue. I am using mysql version 5.0.95 and now facing errors in binlogs. Some of querries in binary log as unknown event and ...
4
votes
2answers
466 views

Unable to start Mysql with SELinux

I am attempting to start MySQL with SELinux on CentOS 6 however I am getting the following error. 131212 09:08:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 131212 09:08:58 ...
0
votes
1answer
148 views

mysql connection to database error [closed]

Two weeks ago I bought new server, and since then sometimes I have error in connection to database on this server. This are error logs after restartng mysqld var/log/mysqld.log: 131206 10:54:37 ...
0
votes
1answer
525 views

Cpanel requiring MySQL upgrade, yet cpanel package is up to date?

I'm running CentOS; WHM/CPanel is telling me: fatal: Newer releases of cPanel & WHM are not compatible with your MySQL version: 5.0. Upgrade your MySQL server to a version greater or equal to ...
2
votes
2answers
1k views

CentOS 6 or Ubuntu 12.04? [closed]

I need MySQL (with a lot of querys) and an HTTPs service. Should I use CentOS 6 or Ubuntu 12.04 on a virtual server? Are there differences in the performance (with default config) or differences in ...
2
votes
2answers
465 views

Increasing nproc on CentOS/RHEL

I have a problem where mysqld runs out of threads and throws errors when under heavy load. I have traced this back to a problem where the pid seems to be limited a soft limit of 1024 processes (have ...
0
votes
2answers
970 views

MySQL / Firewall / Can't connect to MySQL server

I have a client running a mysql server with bind-address=0.0.0.0. Here is the iptables output root@host:/var/www# iptables -L Chain INPUT (policy ACCEPT) target prot opt source ...
-2
votes
1answer
54 views

Adding and Removing MySQL Databases via CentOS 6 - 64 bit

I have a VPS, and am having troubles with MySQL. I think I have created a database, but got lost. I need to know how to: Add a database, with the username, name of the database, and password. ...
1
vote
2answers
2k views

Centos backup mysql using cron job

According to this tutorial http://www.a2hosting.com/kb/getting-started-guide/backing-up-your-data/backups-on-dedicated-servers-and-vps trying to backup mysql database I did: 1) created folders in ...
0
votes
2answers
148 views

Is there a debian-sys-maint equivalent in centos?

I am using debian-sys-maint as practical way to do database dumps in our debian systems, somenthing like this: mysqldump -u debian-sys-maint -p`cat /etc/mysql/debian.cnf | grep password | tail -n 1 | ...
2
votes
1answer
53 views

monit not able to monitor mysql with sock

Just in case if you are using Monit version 5.1.1 and try to monitor mysql with sock it will always fail with "Connection failed" my monit configuration file is: check process mysql with pidfile ...
0
votes
0answers
224 views

DRBD show StandAlone on Primary node after secondary node attach with it?

I am using Centos5.4 & DRBD8.2.6 heartbeat2.1.3 & one java program with Mysql & Asterisk1.6.2.6. On DRBD disk i put 2 service Asterisk & Mysql. SO if DRBD Disk not up both services ...