Ubuntu Servers :: Start Mysql After Replacing My.cnf With My-huge.cnf?
Sep 26, 2010
I want to use the my-huge.cnf file, but when I replace /etc/mysql/my.cnf with the one in /usr/share/doc/mysql-server-5.1/examples/my-huge.cnf, mysql will not start; it is just hanging the process. The only thing i'm seeing in log files is repeating
Sep 26 06:42:51 caseaware kernel: [52647.422669] type=1505 audit(1285497770.990:1240): operation="profile_replace" pid=28591 name="/usr/sbin/mysqld"
Sep 26 06:43:22 caseaware kernel: [52678.675282] type=1505 audit(1285497802.320:1241):
[code]....
View 1 Replies
ADVERTISEMENT
May 4, 2011
I have a mysql database and i use it with apache for my webpages. And I guess it dosen't start when the computer starts so I have to manually start it with "sudo /etc/init.d/mysql start" This returns fail so i went to '/var/run/mysqld/' and the folder was empty. I don't know if this is the problem or not. How can I fix this?
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
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
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 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
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
Jul 26, 2010
Recently, few days or maybe a week ago I updated mysql and now mysql service do not start at boot. I must start it manualy, before this update it start automaticly.
View 9 Replies
View Related
Feb 18, 2010
I've just upgraded to 9.10, and mysql fails to start. When I do an /etc/init.d/mysql start, I just get
* Starting MySQL database server mysqld ...fail!with no additional errors or information to say what went wrong. I saw this thread http://ubuntuforums.org/showthread.php?t=1322070 but the fix mentioned does not apply, as I don't have the #skip bsd line in my config file.
View 5 Replies
View Related
Mar 24, 2010
I just compiled mysql apache and php from source and I have apache to start up from boot but I don't exactly know how to get mysql to do the same.
Edit: Also how do I add mysql to path? Should I just symlink it to somewhere thats in the path or what? And if that is the case wheres the best place to symlink it too.
View 3 Replies
View Related
Apr 8, 2010
I have a mysql database and i use it with apache for my webpages. And I guess it dosen't start when the computer starts so I have to manually start it with "sudo /etc/init.d/mysql start" This returns fail so i went to '/var/run/mysqld/' and the folder was empty. I don't know if this is the problem or not. How can I fix this?
View 9 Replies
View Related
May 3, 2010
Currently when the system boots, It boots jabberd2 before mysql. So jabber fails. Then, later mysql is loaded. I either want to force jabber to load mysql first, or make the system boot mysql first. I've tried changing /etc/init.d/jabberd2 to say "# Required-Start:
mysql $network $named $remote_fs"...
However, insserv says that mysql service has to be enabled... so I assume that's an issue because mysql is an upstart script.
View 5 Replies
View Related
May 9, 2010
mysqld not running on boot, I can start it manually with
Code:
sudo -u mysql mysqld
If I attempt to start it with Upstart I get
Code:
dom@mythbox:~$ sudo start mysql
start: Job failed to start
View 1 Replies
View Related
Apr 13, 2011
On my Ubuntu 10.04 LTS Server, mysql does not start at boot. I tried this but does not work.
Code:
root@dev:~# chkconfig mysql ON
The script you are attempting to invoke has been converted to an Upstart job, but lsb-header is not supported for Upstart jobs.
insserv: warning: script 'K02mysql' missing LSB tags and overrides
insserv: warning: script 'S10vzquota' missing LSB tags and overrides
The script you are attempting to invoke has been converted to an Upstart job, but lsb-header is not supported for Upstart jobs .....
How to make sure mysql process comes up automatically after every reboot
View 4 Replies
View Related
Apr 26, 2010
Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore: me@mycomputer~#start mysql [ret] ...... for hours this command never returns so that ^C aborts...
me@mycomputer~#ps axw |grep mysql ( no results, no mysql!!! ) me@mycomputer~#stop mysql [ret] no returns either!!! This upstart [start|stop] thing seems a total failure for mysql!!!
View 9 Replies
View Related
Nov 16, 2010
I was installing a 2 server cluster ISPConfig3 with the help of GlusterFS. I was following this manual - Link
In the server the file /etc/glusterfs/glusterfsd.vol
Code:
# Configuration for the mysql server volume
volume posix-mysql
type storage/posix
option directory /media/big/myweb/export-mysql
[Code].....
View 3 Replies
View Related
Apr 17, 2011
I am not able to start mysql server...when i type command sevice mysqld start it saysMySQL Daemon failed to start.Starting mysqld: [FAILED]so how to solve this problem ?
View 10 Replies
View Related
Feb 5, 2009
I thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:
linux-nepg:~ # service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
View 9 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
Dec 7, 2010
As the title says, I have a failed RAID5 hard drive. What's the easiest way I can go by replacing it? I've seen many ways to do this, but I would like to know what other people are saying about this, and see how you would do it.
P.S. This is the one I found. [URL]
View 3 Replies
View Related
Sep 7, 2010
My /var/ partition continues to fill up on all my servers, and it is because the logs in /var/log/apache2 or /var/log/mysql are being deleted during log rotate, but their file handles are being held open. Thus, a "du -sh /var/log" shows the correct values, but "df | grep /var" shows something much different.
It seems that the log files rotate, however if I run "lsof | grep deleted" it returns lots of files that are no longer visible in the directory, however refuse to clear themselves off the disk.
The only way I have found to make these log files go away (and thus clear up the disk space on the partition I should have) is to restart either apache or mysql, depending on which process has huge sized log files being held open.
Is it just me, or is this a big flaw in the way linux works, that it can't figure out how to release file handle for a log so the disk space can be reclaimed? This is happening to me a lot lately.
Here is some output from one of my web servers so you can see what I am seeing...
root@web49:~# df -h | grep /var$
Filesystem Size Used Avail Use% Mounted on
/dev/sda8 9.2G 6.1G 2.7G 70% /var
root@web49:~# du -sh /var
[Code]....
View 9 Replies
View Related
Mar 15, 2010
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
View 1 Replies
View Related
Jul 22, 2010
I am replacing a home network - Windows Server 2003 and 5 PCs (XP Pro) with UBUNTU 10.4 LTS Server and client versions. I am keeping a couple of the PCs with dual boot until I can migrate everything over (Having some issues with iTunes, Family Tree Maker, Media serving, DVD decrypt and a couple of others, but that is for another post). It was great fun getting the server up and running using only shell commands. Took me ages just to get a folder shared! Migrating the data over from NTFS to ext3 was also fun given the limited space on the partitions.
I really only want to use the server for communal network type things ... central user account maintenance, shared folders for music, video etc and data backup. I don't need it to be performing server functions on the Internet e.g. web server etc although that may come later. How I set up central user management? All the PCs are currently setup with local user ids, and it is a bit of a pain to go round each PC every time I change something.
The server is not always up, so I need to be able to log into the local PC without it being active. I was using Active Directory on Server 2003, but I don't need anything that complex really ... just 3 or 4 users to manage. I have been looking at the setup tutorial at [URL] but am not sure how relevant a lot of it is. I have SSH setup so I can login remotely, NFS is working to share the folders, but that is about all I have done so far.
View 2 Replies
View Related
Jan 9, 2011
I've got a raid5 array of 4 disks with ubuntu 8.04 runing on it that is currently still working:
/dev/sda
/dev/sdb
/dev/sdc
/dev/sdd
Smartmontools for /dev/sdc tell that there are 9 sectors pending for reallocation:
Code:
197 Current_Pending_Sector 0x0012 100 100 000 Old_age Always - 9
198 Offline_Uncorrectable 0x0010 100 100 000 Old_age Offline - 9
And /dev/sdd has increasing number of reallocated sectors (about 1 every couple of minutes):
Code:
5 Reallocated_Sector_Ct 0x0033 100 100 036 Pre-fail Always - 1735
/dev/sdc has failed a coulple of times this week (but I have always sucessfully readded it to raid5) . But the increasing number of reallocated sectores on /dev/sdd concerns me even more.
I'm affraid that during removal of /dev/sdd and adding new /devs/sdd disk, raid might fall appart. That's why I would try to do it in Ubuntu Live CD:If the raid falls appart (/dev/sdc fails) during the readding of new /dev/sdd disk, I might still remove the new /dev/sdd and return the previous one and assemble the raid with:
/dev/sda
/dev/sdb
/dev/sdd (old one that was previously removed)
Does assembling Raid in Ubuntu Live and adding new disk for /dev/sdd write anything on /dev/sda, /dev/sdb and /dev/sdc in the process of adding /dev/sdd into raid5?
View 2 Replies
View Related
May 3, 2010
I have had tons of issues with the linux today. Now when I try and start mysql it just fails. the syslog says:
May 3 16:19:40 tp-inventory /etc/init.d/mysql[7783]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 3 16:19:40 tp-inventory /etc/init.d/mysql[7783]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
[Code]....
View 6 Replies
View Related
Aug 4, 2010
I had xampp going, but it got messed up and mysql wouldn't start. I thought reinstalling wou;d fix it, but it didn't.
when i do:
Code:
sudo /opt/lampp/lampp start
i get:
Code:
Starting XAMPP for Linux 1.7.3a...
[Code]....
View 3 Replies
View Related
Jun 2, 2010
I cannot get mysql to start since updating to Lucid. It seems to be utterly silent, no log entries anywhere I can see or anything.
I've tried reinstalling the ubuntu install to no avail.
Here's the /etc/mysql/my.cnf:
(default from upgrade I suspect) this is also the debian.cnf
Code:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
[Code].....
I'm just getting utterly nothing in any log.
root@linuxbox:/etc/mysql# sudo start mysql
start: Job is already running: mysql
but there isn't! top/ps show nothing at all
root@linuxbox:/etc/mysql# sudo restart mysql (or stopping) just sit there, hung on something.
View 2 Replies
View Related
Jul 12, 2011
I have a development server that I have attempted the 9.10 -> 10.4 LTS upgrade on to see if there were any problems. (Another catch is that I am running PHP 5.3 and 5.2 concurrently, and this has been successfully done.)
MySQl fails to start:
Quote:
root@dev11:/var/run/mysqld# /etc/init.d/mysql start
* Starting MySQL database server mysqld
...fail!
Checking /var/log/syslog:
[Code]....
P.S. This server has had MySQL running for some time. There are databases on there, but again they are used in development only. I'd rather not uninstall/reinstall.
View 1 Replies
View Related
