-1
votes
1answer
19 views

postfix how to setup local domain users as virtual users

How can I set up local domain users as virtual users? I have setup virtual domain and the users but when I sent an email it keeps telling me "User not found". To test to see what the problem is, I ...
0
votes
1answer
767 views

how to fix corrupt, not cleanly closed and upgrade needing tables in mysql

When I restart mysql server in Debian, I always have the below messages. How to make the messages disappear or fix the problem/corrupted tables? debian:~# /etc/init.d/mysql restart Stopping MySQL ...
0
votes
1answer
55 views

mysql can't use locks with log tables

When I run mysqlcheck command in Debian MySQL 5.1, I get the below messages: Debian:~# mysqlcheck --all-databases -u root -p Enter password: mysql.columns_priv OK ...
0
votes
1answer
51 views

Configuring MariaDB to log to mysql.log using rsyslog

I'm a little stumped - there is something obvious I'm missing here. Recently I made the switch from mySQL to mariaDB. Everything is working so far - except for the logging, as I realized today. All ...
0
votes
1answer
28 views

Dovecot MySQL Authentication SlowDown

I have an IMAP/POP3/Webmail server with Dovecot1 2.2.10 with a MySQL backend located on another server. The server runs with default configuration. ... driver = mysql default_pass_scheme = plain ... ...
1
vote
2answers
34 views

run second mysqld instance for backup restore

I am trying to start a second mysqld instance to restore data from backup (innoDB). Following the manual I put together this: P="/var/lib/reoback/backups/2014-06-30/var/lib/mysql" cd $P mkdir tmp ...
1
vote
2answers
62 views

start mysql service after syncing data dir to tmpfs

hej there! I'm maintaining a network of 8 Pandaboards. One of them is acting as server to host a php-based browser game, others are clients running that game. The server runs Debian Wheezy from SD ...
0
votes
0answers
377 views

Mysql not starting after upgrading debian squeeze to wheezy

I recently bought a VPS box with Debian Squeeze pre-installed as the OS. I upgraded to Debian Wheezy and most things work fine (e.g. apache). The problem I'm having relates to MySQL - which is just ...
1
vote
1answer
1k views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
1
vote
1answer
356 views

Can't start mysql server

I'm facing problems installing a software package that depends on MySQL. During the installation it installs a MySQL server, but for some reason starting the services fails and thus the installation ...
2
votes
1answer
184 views

monit mysql server blocked because of too many bad connections

Is there any tweak for monit or another way to monitor whether one server can access mysql on another server? I tried it with monit but as you probably know, after 10 attempts, mysql blocks the ...
0
votes
1answer
440 views

Updating php5-mysql for MySQL 5.6 under Debian 7

After a lot of troubles installing MySQL 5.6 for Debian 7 (with ISPConfig) (FYI, I followed this tutorial : http://xmodulo.com/2013/12/upgrade-mysql-server-debian-ubuntu.html) my PHPMyAdmin shows me ...
0
votes
0answers
20 views

Extremely weird proftpd behavior

I have configured proftpd + mysql and it is working Its working perfectly despite the overcomplicated queries. However when I enable DefaultRoot ~ It stops working and somehow reverts to some ...
0
votes
0answers
30 views

MySQL Service allow local connections through hosts.allow

I have my hosts.deny set up as ALL: ALL but when I do this I can't seem to allow MySQL in hosts.allow. I need it just on the local network. I've tried: mysql: LOCAL mysqld: LOCAL and as a last ...
0
votes
1answer
281 views

Dovecot handshake failure, on Postfix success

I am trying to setup a Dovecot/Postfix structure, relying on a MySQL backend. I came across a problem with SSL configuration, and it's really tearing my hair out... Situation Dovecot listens on port ...
0
votes
0answers
27 views

pureftpd per domain mysql

I am trying to configure PureFTPd with mysql for a multiuser hosting. What i would like to accomplish is that each "client" is an account on the system, but each of those clients can have multiple ...
0
votes
3answers
84 views

Remote access forbidden (HY000) to specific mysql client

A MySQL server is located at central.hwcharts.com; it is the master of a basic master-slave replication which replicates toward host0.hwcharts.com, located on a different physical machine which ...
1
vote
2answers
138 views

MySQL shut down it self periodically

I recently bought 512MB, 2.2GHz, 20GB SSD - VPS Server and installed Debian Wheezy 64-bit and it is used as WEB Server. I have installed Apache2, PHP, MySQL, ClamAV, Anti-DDoS, Spam Assain, Postfix, ...
1
vote
0answers
85 views

LVS-DR and OpenVPN: returning packets not being routed into the vpn

i've set up a load balancer with ldirectord, and an active-passive mysql service managed by it, on two additional real servers. LVS is running in Direct Routing mode, so the client requests are ...
0
votes
0answers
219 views

MySQL from Deb changing configuration after installing perl packages?

This will sound silly, I'm sure. Here goes. I have a new installation of Debian Wheezy (Debian7). Instead of going with the aptitude installation of MySQL that right now holds v5.5.31 I went with the ...
0
votes
2answers
170 views

Apache2 Debian server falls. Out of memory

help me please with my apache problem. I got an droplet at DigitalOcean with 512mb of RAM (Debian). There are 3 sites on MODX CMS (works on php). Today morning as i think system discovered an out of ...
-1
votes
2answers
180 views

How to add support of bcrypt to mysql?

Following this answer mysql does not support bcrypt because system does not support them either. How to add support of bcrypt to Debian to MySQL?
0
votes
1answer
21 views

syscp cron_traffic.php needs 10 minutes to execute

I use syscp on debian and i noticed that this script is taking more than 10 minutes to execute: date ; /usr/bin/php5 -q /var/www/syscp/scripts/cron_traffic.php; date Do 5. Dez 12:09:09 CET 2013 Do ...
0
votes
2answers
60 views

freebsd-like jail with debian for mysql (updating db schema)

I have debian box with big database. I want to do a lot of risky operation with this database. Its about updating the sofware which works with this db. I can stop database for 5 min, but not for ...
0
votes
0answers
36 views

Pinpointing PHP performance problems after upgrade

I have done an upgrade of my server from debian 6 to 7.2, along with moving from PHP 5.4 with APC to PHP 5.5 with OpCache and APCu (both running as php-fpm). MySQL and Apache are still the same ...
0
votes
2answers
129 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 | ...
0
votes
1answer
83 views

Debian mysql-proxy reserved connections

I was looking in too the mysql-proxy configuration, and decied to install it in order to make an access point to my servers whenever they reach high peak, however i want to have 5-10 reserved ...
0
votes
0answers
102 views

postfixadmin doesn't create table but create database

Already i downloaded and installed postfixadmin ,But for version compatibily, i' forced to install from debian repository. I prevent to wonderful thing, It is installed successfully , creates ...
0
votes
2answers
237 views

autossh -> private key without passphrase

I would like to tunnel a mysql database. So I thought I use a private key without a passphrase to make it reboot friendly. The problem is, openssh still asks me for a passphrase and if I leave it ...
0
votes
0answers
225 views

Mysql remote connections very slow - host lookups already disabled

I followed every instruction about this issue and nothing helped. Remote communication with MySQL server takes 4-30 seconds on simple query like select 1 from table_name and connection attempt often ...
-1
votes
1answer
119 views

Python cant connect to local MySQL server through socket [closed]

I have a python script which is designed to add things to a MYSQL database. The error I get is this: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock I've checked the ...
2
votes
2answers
2k views

How to reinstall broken mysql package

Trying to fix a broken mysql installation, this happened after upgrading from debian 6.0 to 7.0. I have the dotdeb.org packages in my /etc/apt/sources.list. root@ginger:/var/log/mysql# apt-get ...
0
votes
2answers
1k views

OpenVZ MySQL InnoDB won't start

I have a OpenVZ Server with 4GB RAM and have tried to install MySQL on several distros (Ubuntu 12.04 64Bit, Ubuntu 12.10 64Bit, Debian 7 64Bit) and I always get the same errors: 130718 6:57:27 ...
1
vote
2answers
644 views

mysqldump isn't able to export a specific database, phpMyAdmin crashes

I'm experiencing problems with a database on my server (Note: All other databases work fine). Once I try to export it with mysqldump I get this error: # mysqldump -u root -pXXXXXXXXX databasename ...
1
vote
5answers
4k views

After installing Mysql 5.6 the server can't start

The mysql server is installed on a clean install of Debian 7 Have tried this serveral times each time on a clean install of Debian installation # apt-get update && apt-get upgrade # ...
5
votes
2answers
9k views

How to install Mysql 5.6 on Debian 7 wheezy

I'm trying to install Mysql 5.6 on Debian 7 Wheezy.. After installing the mysql database/folder /var/lib/mysql/mysql is empty # groupadd mysql # useradd -r -g mysql mysql # apt-get install libaio1 # ...
0
votes
0answers
103 views

Performance drop after hours of runtime - how to detecting bottleneck

I am running a local database server for 1 client machine. My DB server runs redis (version 2.6.13) and mysql (5.5.31-30.3-log Percona Server (GPL), Release 30.3). I have 1 Client machine that runs a ...
-1
votes
2answers
309 views

How to regain access to myql server and dump database?

We retake the management of our server and now we need to make some reverse engineering. We gave to an external company the development of our new Website and they need a dump of database from old ...
-1
votes
3answers
123 views

Reinstall mysql and keep mysql data [closed]

In Debian, /root/bin folder was deleted. The biggest problem is that mysql is missing. When I type: > mysql -bash: mysql: command not found I have all data in /var/lib/mysql. How do I install ...
0
votes
3answers
3k views

Failed mysql upgrade to 5.5 on debian wheezy

When upgrading debian squeeze to wheezy, the upgrade of mysql to mysql-server-5.5 fails: # apt-get dist-upgrade -u ... Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ... [ ok ] Stopping MySQL ...
-1
votes
3answers
2k views

How to install MySQL 5.6 on Debian (wheezy or squeeze) and make it work

How to install MySQL 5.6 on Debian (wheezy or squeeze)? The package is on mysql site but what's next? Thanks for first answers. I actually installed it but it won't work.
0
votes
1answer
174 views

PHP processes keep overwhelming my server, eating up the CPU and making it lock up :(

I have a Debian Squeeze Lighttpd server with PHP and MySQL, and also with XCache and Varnish set up. I am quite new to this, but have tried as hard as I can to resolve this problem with no success. ...
1
vote
2answers
685 views

PHP mysqlnd on Debian 6

I've installed php5-mysqlnd via: apt-get install php5-mysqlnd This is a brand new virgin Debian install with just apache2 and php5 via: apt-get install apache2 echo "deb ...
0
votes
2answers
482 views

Apache and MySQL doesn't start at boot

I am running Debian 6 on a server. On this server I want to have an instance of Apache2 and MySQL started when the system boots. For this purpose I know there are the init.d script and the symbolic ...
-1
votes
1answer
116 views

Can't install anymore MySQL on debian after deletion of various folders [closed]

So here is my story: I've been thinking "Why am I using MySQL 5.1, if there is already 5.6 out?", therefore I wanted to install 5.6 on my debian root server(it is a playground/testserver, not a ...
3
votes
3answers
11k views

MySQL keeps crashing: InnoDB: Unable to lock ./ibdata1, error: 11

I have a simple webserver (Debian 6.0 x86, DirectAdmin with 1 GB of memory and still 10 GB free space, mySQl version 5.5.9), however the mySQL server keeps crashing and I need to kill all mySQL ...
1
vote
3answers
1k views

Error installing mysql, any way to fix it?

I was installing mysql with apt-get install mysql-server (like I always did) before that I had done an apt-get update (I am using Debian 6), and when I installed I found this problem, pretty common as ...
2
votes
1answer
142 views

How can I isolate my Apache and MySQL installations on the same server? [closed]

I have a 8GB RAM Linux server which will be running Apache and mysql. First I was thinking of chrooting mysql (and apache) but then thought of putting mysql in a virtual machine on the same server, ...
4
votes
1answer
292 views

Ran out of disk space, how to tar without creating copy

I am at 98% of an 8GB SSD, and I have a 3 GB mysql data that I need to gzip and or tar and then download it, so then I can delete it. How can I tar or gzip the sql (or the mysql tables) so that that ...
0
votes
1answer
62 views

MySQL table records changes every second

I was using a PHP script running on background to grab data and insert them into the mysql database... i stopped the PHP from logging and checked the table records, i found that its being changed ...