Ubuntu Servers :: Mysql Died Overnight On 8.04
Jan 14, 2011
After X days of blissful uptime my mysql failed on my server for some reason. I have had 0 problems with it for over a year and it simply died overnight. I have been upgrading old packages occasionally so it is possible that could have effected it. Anyway, after reading around tons about how /var/run/mysqld/mysql.sock doesn't exist and solutions to fix it I finally ended up attempting to reinstall mysql (I take regular database backups so I wan't concerned about losing data).
The typescript from this endeavor is here: [URL]. Hopefully someone knows what the heck is going on? EDIT: after pulling my hair out trying to get this to work for 5 days I decided to install simply wipe out ubuntu entirely and install 10.4 and try again. this worked, but its a horrible solution.
View 2 Replies
ADVERTISEMENT
Aug 6, 2010
I was running 8.something on my ubuntu server. Today I decided to upgrade releases! So I started it, all via ssh cos the box is about 800 miles away and it was going just fine. However - I went away from the pc for about a hour, and my ssh session died. On reconnect it starts a new ssh session - and I dont know how to reconnect to the upgrade process and finish it off.
View 9 Replies
View Related
Jan 3, 2009
I had a RAID1 'device' build on two physical partitions on two drives. One of the disk controllers died and software RAID did the job - now I am working on the degraded array.
Now I want to put the old disk (sdb) back, and I am not sure what will happen. Both disks have 'raid auto' partitions. And sdb file structure from before of the failure. The raid code will find inconsistency between both partitions. What will it decide? Will it start coping from the currently running system (sda) all the data to the old one (sdb) at the boot time, as I wish?
I don't want to it to write from the old one to the new one, as some months passed and lots of changes happened to the data.
View 1 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Jan 11, 2011
I was on my server most the night via SSH doing changes (mostly permissions :/ ) and woke up this morning and get "Server unexpectedly closed network connection" from inside the network (via internal IP), AND outside the network (via outside IP)Obviously I messed something up somewhere right?
Any thoughts on what to verify or check first? Server is up, because I can access a few different hosted pages. I'm remote today, so I don't have access to the box. I'm assuming i'm SOL until I get to the box tonight to fix locally..
View 3 Replies
View Related
Jul 28, 2009
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
View 2 Replies
View Related
Mar 11, 2011
How does this happen? This morning waking one of my dev systems its asking me to install a font.Its a chinese font, for the terminal. Obviously I didn't try to install it. I did use this system to view gotomeeting.com yesterday. Oh yea and installed flash from netstat shows an open connection to 74.51.103.39:80.
View 1 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
May 4, 2010
I don't know. I have had tons of issues with the Linux today. Now when I try and start mysql it just fails. the syslog says code...
The command mysql results in:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I have even tried to uninstall mysql and reinstall it an nothing works. Any suggestions?
View 4 Replies
View Related
Jun 5, 2010
I'm trying to start my MySQL server, and it fails if the /etc/mysql/my.cnf file is there. If it isn't, then it fails - syslog shows me this:
Code:
Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
[Code].....
View 7 Replies
View Related
Aug 20, 2010
I have probably found a bug in the Ubuntu php5 package. At first I thought it's a problem with Zend Framework, which I use, then I thought it's a php issue, but now it seems to be a problem with Ubuntu's php packages. My problem is that under certain conditions, php is going to read records from the mysql database table infinite times. For a much more detailed description of the bug,[URL]..
I've tried on an x86 Ubuntu Desktop edition, and an x64 Ubuntu Server edition, both 10.04, and both had this bug. I have set up a test system (x86 Ubuntu Server edition 10.04), and compiled apache2 and php5 from source, but used the mysql-server package from the repository. And I couldn't reproduce the bug. However, after copying the self-compiled libphp5.so file from the test system to the desktop that produces the error, I could still reproduce the error on the desktop. This suggests me that the problem is either not in php, or - more probably - there are multiple php binaries used in the repository version, and therefore it doesn't matter that I've copied my libphp5.so because mysql functions are somewhere else. I've found a mysql.so file in /usr/lib/php5/20090626+lfs coming from the php5-mysql package. Does that have anything to do with this issue?
View 8 Replies
View Related
Mar 14, 2011
ive been trying to fix this for a while. i dont have the original my.cnf, but i dont even know if thats the error:
Code:
pavel@pvl1:~$ sudo service mysql start
^C
pavel@pvl1:~$ cd /var/log/[code]....
View 1 Replies
View Related
May 3, 2011
Is there a php,mysql built in?What folder do i put my website?What command do i need to use to start and stop apache?If there isnt php,mysql built in how do i install it ?
View 9 Replies
View Related
Jun 26, 2011
I have trouble with MySQL server on my Ubuntu 11.04.Below is what I get in Terminal
root@linux:/home/karl# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the
service(
[code]....
View 3 Replies
View Related
Jul 24, 2011
I'm using ubuntu 10.04 LTS I install mysql..Code: sudo apt-get install mysql-server.I set up my password and confirm,I type mysql at the terminal and i get this back.
View 1 Replies
View Related
Jan 15, 2010
My mysql server won't start on my machine. It simply fails with no errors.
Code:
sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
When I run cat /var/log/mysql.err the file is empty, thinking this might be a permissions issue
I tried chowning to a mysql user. Here's the current permissions.
Code:
ls -alh /var/log/mysql*
-rw-r----- 1 mysql adm 0 2009-09-30 11:08 /var/log/mysql.err
-rw-r----- 1 mysql adm 0 2010-01-15 09:07 /var/log/mysql.log
-rw-r----- 1 mysql adm 20 2009-11-25 07:35 /var/log/mysql.log.1.gz
-rw-r----- 1 mysql adm 20 2009-11-24 07:59 /var/log/mysql.log.2.gz
-rw-r----- 1 mysql adm 20 2009-11-23 07:56 /var/log/mysql.log.3.gz
-rw-r----- 1 mysql adm 20 2009-11-22 07:54 /var/log/mysql.log.4.gz
-rw-r----- 1 mysql adm 20 2009-11-21 07:47 /var/log/mysql.log.5.gz
-rw-r----- 1 mysql adm 20 2009-11-20 07:43 /var/log/mysql.log.6.gz
-rw-r----- 1 mysql adm 20 2009-11-19 07:35 /var/log/mysql.log.7.gz
/var/log/mysql:
total 8.0K
drwxrwsrwx 2 mysql adm 4.0K 2009-09-30 11:08 .
drwxr-xr-x 16 root root 4.0K 2010-01-15 10:24 ..
Still having the same issue, mysql server is still failing and /var/log/mysql.err is still empty.
View 3 Replies
View Related
Feb 5, 2010
I set up mod_proxy in order to get rid of :8080 now I cant access phpmyadmin through the browser. what is the quickest way to turn off mod_proxy and access phpmyadmin? I would like to optimize the tables and back up the sql file. I just need to turn it on for a bit, and then enable mod_proxy again.Right now, if I got to localhost/phpmyadmin, it redirects to the main application.
I have used a2enmod, and added
sudo a2enmod proxy
sudo a2enmod proxy_http
sudo a2enmod proxy_ajp
[Code]...
View 2 Replies
View Related
Feb 8, 2010
I'm using ubuntu 9.10 64bit and I'want to configure php mysql and lampp. Also the package mysql-ser is already installed, so if I install MYSQL GUI tools(Administrator, query browser..) from my synaptic package manager will it detect the mysql already installed ? Also tried configuring lampp by extracting it in my /opt directory and i started the server, which MySQL ll it detect the one which was previously installed otr the oin that in gui tools ?
Also think the current ubuntu repository does't have latest build of mysql GUI tools, so how the above mentioned things ll change if I try to download the individual package.
Oveall what I want is to configure Mysql GUI tools, Mysql workbench, xampp and php(For this I'm using Bluefish and Komposer). Please help me out so that I can leave windows for my Web-projects.
View 1 Replies
View Related
Mar 19, 2010
how i can instal mysql,apache and php through my usb. what commands do i need?
View 2 Replies
View Related
May 9, 2010
My config:
Ubuntu 9.0.4 (all up to date with security patches)
Apache 2.2.11
MySQL version 5.0.75
PHP Version 5.2.6-3ubuntu4.5
I'm running Ubuntu as a Virtual machine with VMWare on top of a Windows 2008 Server. It has been working perfectly for nearly 9 months. I have one processor and 2GB of Ram assigned to the Virtual machine. Memory usage seldom ever reaches more than 50%, swapfile is hardly used either. I noticed recently that sites were loading very slow from time to time. Webmin showed me that USER / KERNEL were together using 100% cpu. I then started searching for answers to what was causing this and then read about using HTOP. I then installed HTOP and found that the following processes were the culprits
/usr/sbin/mysqld
/usr/sbin/apache2 -k start
There are multiple instances of mysqld and apache2 listed in HTOP, I assume this is because I run multiple sites on the box. It does however seem limited to only one or two PID's that are repeatedly maxing out the CPU at 100% (every 30 seconds to a minute) sometimes the CPU will stay maxed at 100% for nearly a minute and then free itself again but it is doing this continually. At the point when the CPU maxes out at 100% there will be one instance of mySQLD and one instance of Apache2 right at the top of HTOP and between the two they will be hogging 100% cpu. All the sites are either Wordpress or Joomla sites and I am quite confident it's one of these sites causing a problem.
My issue is that I cannot pin down which PID belongs to which site. Then, once I know which site it is how do I then trace what process / file inside that site is casuing the problem? I figured one of my busiest sites (wordpress) might be the culprit and I installed the W3 Total Cache plugin today but that has not helped this 100% cpu problem, so for all I know it might be another WP site on the box or even one of the Joomla sites. I've noticed that the TIME column on the one MYSQLD instance that maxes out is very long so it seems like Mysql is keeping some connection open or something?
View 8 Replies
View Related
May 10, 2010
I just installed a brand new ubuntu server 10.04 32-bit, choosing the LAMP option on install. Upon reboot I couldn't connect to mysql from another machine, so on this new server I changed the file at /var/mysql/my.cnf
[Code]...
View 9 Replies
View Related
May 11, 2010
Ubuntu server 10.04 comes with a new event based startup system, and I wonder if that can be responsible for this problem. The server has been upgraded from 9.10. On reboot mysql does not always manage to start... /var/log/mysql/error.log has info similar to this:
100511 19:05:00 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
100511 19:05:00 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100511 19:05:00 [ERROR] Aborting
So apparently port 3306 is not 100% unused when mysql tries to open it or somehow network connections are not ready, even if mysql start is supposed to wait for 'net-device-up' and 'local-filesystems' according to /etc/init/mysql.conf. This does not happen on all reboots. I am supposed to be able to start it manually with command 'start mysql' but that does not seem to work also. When I try start it again, it says mysql is running but no databases can be reached and mysqld is not active, reboot and good luck is all that helps...
As far as I know there are no firewalls installed, at least none I have manually configured and it has worked with no problems on 9.10. So this new upstart thing seems responsible. It simply does not let mysql wait until it can start in good way. That also explains why it's a random problem. If all starts happen when and if there is free processor time, it does not always start things in the same order on every reboot. The key here is port 3306, or whatever port mysql is configured to use. The upstart system simply needs delay the start until the port is 100% free and available for the system to use.
View 1 Replies
View Related
May 14, 2010
It took a while but I got my home webserver setup and running with mysql. Now I want to import a 70MB MSSQL backup file from my hosting company. I noticed phpMyAdmin can import up to 2MB. Any suggestions on how to do this for a larger file. I do have access to the server running SSH so I'm not opposed to using the command line if I need to.
View 2 Replies
View Related
May 21, 2010
With the new realease of Ubuntu 10.04 LTS, I was wondering if there was going to be a package for installing Mysql Cluster Server 7.1
If not does anyone know of a good walkthrough for compiling and installing it in Ubuntu 10.04 LTS?
View 8 Replies
View Related
Jun 18, 2010
does ubuntu 10.04 support multithread on mysql 32 bit?
View 8 Replies
View Related
Jul 9, 2010
I need to Install MySql Server somewhere that I can access. Instead on installing it in a Windows box like I have for years, I'm thinking of putting it on a Ubuntu Server box (or virtual machine) instead. Should I do it on a Ubuntu Server or a Ubunto desktop box? I have never installed Ubuntu as a server, is it more or less the same as installing the desktop version? Lastly, is there multiple versions of Ubuntu where one might be more appropriate than another? All I want is a machine that I can access MySql via an IP address. Don't need DHCP, dns, Mail server or anything.
View 4 Replies
View Related
Jul 15, 2010
I have searched some about Bind9 and have it installed in my server. Now I'm looking for a Tools like mysqlBind and I found unxsBind is the next version of mysqlBind (These tools help you config BIND DNS with MySQL). But the issue is: I don't know how to Install it in Ubuntu - there just say how to install with Centos.
View 2 Replies
View Related
Jul 15, 2010
When you access mysql within the same Apache server (same ip address) via php, do you need to GRANT user ip in order to login to mysql?
Where are the log files for php, mysql etc?
View 4 Replies
View Related
