OpenSUSE Install :: Start Mysql Before Another Application?
Mar 5, 2011
Through YaST's System Services I configured an application to start on boot. However, the application (mediatomb) is using mysql, so it should not be started before mysql. It is however, which means mediatomb fails to start.
How can I make sure mysql is started before mediatomb?
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
For the past day or so, mysqld has been hogging one of my two CPUs. On System Monitor, I tried "kill" and then "forcibly kill" when that button appeared on the menu but all that happened was a new mysqld popped up to take its place. I've since found that killing Akonadi first and then the forcible kill did the job so the problem seems to be solved. What bothers me, is what was it trying to do? I don't use the application. I wondered whether Thunderbird might use it so closed that down and rebooted but mysqld was still there. I suppose now I've got rid of that one - for now - I'll get knotify4 grabbing a cpu again. At least knotify4 is easy to kill - but then xorg usually takes over and I have to end the session.
I just installed the miro internet tv application using yast on my openSUSE 11.2 and I cannot start it.
Running the miro application from console gives me the following output:
nuca@ionpetrache:~> miro PyNotify support disabled on your platform. 2010-05-28 13:51:55,501 INFO Starting up Miro 2010-05-28 13:51:55,502 INFO Version: 2.5.4 2010-05-28 13:51:55,508 INFO OS: Linux 22.214.171.124-0.2-desktop i686 2010-05-28 13:51:55,509 INFO Revision: ssh://firstname.lastname@example.org/var/git/miro - 1e20db82
i am using putty to connect to my server and wanted to restart mysql server. searched the internet and found thatcommand is /etc/init.d/mysqld start or stopbut it did not worked.then tried /etc/init.d/mysql stop or startthis also did not worked.
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
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?
In looking at the release notes, I saw the comment File locations changes:
* MySQL socket file and pid file were moved from /var/lib/mysql to more reasonable location /var/run/mysql by default.
* MySQL log files are in /var/log/mysql. Not sure what I was supposed to do with that information. So I ignored it. Now, I am finding some issues with it. The web server works, but any connection to the database fails with 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)The thought dawned on me that maybe all my databases were erased and none set up. Going in to the terminal, I could connect and list and query the databases. So even though I backed them up, they still are there!
phpMyAdmin gives the same error message.
However, when I go into MySQL Administrator, it works fine.
I forgot where I saw it, but the socket is still set to var/lib/mysql. I could not find any mysql install log and would say what was in my cnf.my, but it still doesn't exist just as it has not in the past. Not sure if I should allow the MySQL Administrator to create it since I always ignored the prompt in the past and it worked. (Just wishing to keep the defaults)
At first I thought the upgrade upgraded the MySQL, but it's still 5.1.39 as I believe before. I've un-installed mysql-server and re-installed it with no change.
Can anyone can tell me how to get the socket to /var/run/mysql or what else is wrong? I read one place where mysql is supposed to set it up.
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: 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: ^G/usr/bin/mysqladmin: connect to
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
I posted a thread regarding a CD Base Application. I can run the program, but for some reason It does not seem to work properly.
For some reason in exits the program back to the command prompt. I am using the code from Linux programming 4th edition which you can get it from here...and in the folder ch08/app you will find all you need to create the CD database application.
I upgraded to version 11.4 and now I can not install any application. Not YAST or zypper downloaded RPMs.Firefox and Konqueror can not download links that are rpm. I do not understand what happens. Ties other than rpm, if fully discharged. I tried as root and nothing.
I tried to down grade my PHP5.3.x to 5.2.6 and some how I broke the connection to my Mysql. I needed to do this for version 6.xx of Drupal. Anyone know a quick fix to the mysql.lock or do I have to re-install Mysql?Error Message:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13).
I have SLES9.I am running a Java-application named meinServer5.This app starts two application servers, one admin process and one worker process, where the admin process has to be started before and ended after the worker process:
meinServer5 startadmin // starts the admin process meinServer6 stopadmin // stops the admin process meinServer5 start //starts the worker process
I have a problem when trying to update or install new application via Yast, I'm using opensuse 11.3. PackageKit Error repo-not-available: Failed to download /content from Index of /distribution/11.3/repo/oss
I got a new hard drive in and decided to do a completely new install of 11.4 64 on my "testing/spare machine:. I have my dual monitors configured properly But I ran into two issues. When doing a manual post install update from the 11.4 updates repo I have one file that will not play happily named cronie. When trying to install the application wspr from the hamradio repo I get the following error for an unsatisfied dependency. I have the same application installed on another 11.4 installation on this system and it didn't choke on this file.
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)