Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Having issues with MySQL! Will not start! When I run "service mysql start" I get the error "start: Job failed to start"! I ran some recovery BASH scripts I had from before and was, when running the cmd "mysqld -u root -p --skip-grant-options" getting the error: "mysql error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'" but after running the scripts now getting the error: "180508 13:51:37 [Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line"!
So then ran the cmd: "mysqld -u mysql -p --skip-grant-options" it says it started and gives a process number, but running "ps -A | grep mysql" or "ps -A | grep mysqld" nothing shows. and even running "ps -A | grep procnumber" shows no process. What do I need to fix this?
Found a HOWTO online that said the following command set would clear this but it also errors.
Attempting "Removal" does not work, so went to Synaptic Package Manager to re-install these packages and get this set of errors repeated for ever package selected there:
Code:
E: Unable to correct dependencies
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.
I had to clear held packages once before, but do not remember how.
Ign http://dl.google.com stable InRelease
Hit http://dl.google.com stable Release.gpg
Hit http://dl.google.com stable Release
Ign http://us.archive.ubuntu.com trusty InRelease
Hit http://linux.teamviewer.com stable InRelease
Hit http://linux.teamviewer.com preview InRelease
Hit http://us.archive.ubuntu.com trusty-updates InRelease
Hit http://ppa.launchpad.net trusty InRelease
Hit http://security.ubuntu.com trusty-security InRelease
Hit http://us.archive.ubuntu.com trusty-backports InRelease
Ign http://extras.ubuntu.com trusty InRelease
Hit http://dl.google.com stable/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty Release.gpg
Hit http://linux.teamviewer.com stable/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty Release
Hit http://extras.ubuntu.com trusty Release.gpg
Hit http://linux.teamviewer.com stable/main i386 Packages
Hit http://us.archive.ubuntu.com trusty-updates/main Sources
Ign http://ppa.launchpad.net trusty InRelease
Hit http://us.archive.ubuntu.com trusty-updates/restricted Sources
Hit http://extras.ubuntu.com trusty Release
Hit http://linux.teamviewer.com preview/main amd64 Packages
Hit http://security.ubuntu.com trusty-security/main Sources
Hit http://linux.teamviewer.com preview/main i386 Packages
Hit http://us.archive.ubuntu.com trusty-updates/universe Sources
Hit http://us.archive.ubuntu.com trusty-updates/multiverse Sources
Ign http://dl.google.com stable/main Translation-en_US
Hit http://security.ubuntu.com trusty-security/restricted Sources
Hit http://extras.ubuntu.com trusty/main Sources
Ign http://dl.google.com stable/main Translation-en
Hit http://us.archive.ubuntu.com trusty-updates/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty-updates/restricted amd64 Packages
Hit http://ppa.launchpad.net trusty InRelease
Hit http://security.ubuntu.com trusty-security/universe Sources
Hit http://extras.ubuntu.com trusty/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty-updates/universe amd64 Packages
Hit http://us.archive.ubuntu.com trusty-updates/multiverse amd64 Packages
Hit http://security.ubuntu.com trusty-security/multiverse Sources
Hit http://extras.ubuntu.com trusty/main i386 Packages
Hit http://us.archive.ubuntu.com trusty-updates/main i386 Packages
Hit http://us.archive.ubuntu.com trusty-updates/restricted i386 Packages
Hit http://ppa.launchpad.net trusty/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty-updates/universe i386 Packages
Hit http://security.ubuntu.com trusty-security/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty-updates/multiverse i386 Packages
Hit http://us.archive.ubuntu.com trusty-updates/main Translation-en
Hit http://security.ubuntu.com trusty-security/restricted amd64 Packages
Ign http://linux.teamviewer.com stable/main Translation-en_US
Hit http://ppa.launchpad.net trusty/main i386 Packages
Hit http://security.ubuntu.com trusty-security/universe amd64 Packages
Ign http://linux.teamviewer.com stable/main Translation-en
Hit http://us.archive.ubuntu.com trusty-updates/multiverse Translation-en
Hit http://us.archive.ubuntu.com trusty-updates/restricted Translation-en
Ign http://linux.teamviewer.com preview/main Translation-en_US
Hit http://security.ubuntu.com trusty-security/multiverse amd64 Packages
Hit http://us.archive.ubuntu.com trusty-updates/universe Translation-en
Ign http://linux.teamviewer.com preview/main Translation-en
Hit http://us.archive.ubuntu.com trusty-backports/main Sources
Hit http://ppa.launchpad.net trusty/main Translation-en
Hit http://us.archive.ubuntu.com trusty-backports/restricted Sources
Hit http://security.ubuntu.com trusty-security/main i386 Packages
Hit http://us.archive.ubuntu.com trusty-backports/universe Sources
Hit http://us.archive.ubuntu.com trusty-backports/multiverse Sources
Hit http://security.ubuntu.com trusty-security/restricted i386 Packages
Hit http://us.archive.ubuntu.com trusty-backports/main amd64 Packages
Hit http://ppa.launchpad.net trusty Release.gpg
Hit http://us.archive.ubuntu.com trusty-backports/restricted amd64 Packages
Hit http://security.ubuntu.com trusty-security/universe i386 Packages
Hit http://us.archive.ubuntu.com trusty-backports/universe amd64 Packages
Hit http://us.archive.ubuntu.com trusty-backports/multiverse amd64 Packages
Hit http://security.ubuntu.com trusty-security/multiverse i386 Packages
Hit http://us.archive.ubuntu.com trusty-backports/main i386 Packages
Ign http://extras.ubuntu.com trusty/main Translation-en_US
Hit http://ppa.launchpad.net trusty/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty-backports/restricted i386 Packages
Hit http://security.ubuntu.com trusty-security/main Translation-en
Hit http://us.archive.ubuntu.com trusty-backports/universe i386 Packages
Ign http://extras.ubuntu.com trusty/main Translation-en
Hit http://us.archive.ubuntu.com trusty-backports/multiverse i386 Packages
Hit http://security.ubuntu.com trusty-security/multiverse Translation-en
Hit http://us.archive.ubuntu.com trusty-backports/main Translation-en
Hit http://ppa.launchpad.net trusty/main i386 Packages
Hit http://us.archive.ubuntu.com trusty-backports/multiverse Translation-en
Hit http://security.ubuntu.com trusty-security/restricted Translation-en
Hit http://us.archive.ubuntu.com trusty-backports/restricted Translation-en
Hit http://security.ubuntu.com trusty-security/universe Translation-en
Hit http://us.archive.ubuntu.com trusty-backports/universe Translation-en
Hit http://ppa.launchpad.net trusty/main Translation-en
Hit http://us.archive.ubuntu.com trusty/main Sources
Hit http://us.archive.ubuntu.com trusty/restricted Sources
Hit http://us.archive.ubuntu.com trusty/universe Sources
Hit http://ppa.launchpad.net trusty Release
Hit http://us.archive.ubuntu.com trusty/multiverse Sources
Hit http://us.archive.ubuntu.com trusty/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty/restricted amd64 Packages
Hit http://us.archive.ubuntu.com trusty/universe amd64 Packages
Hit http://us.archive.ubuntu.com trusty/multiverse amd64 Packages
Hit http://ppa.launchpad.net trusty/main amd64 Packages
Hit http://us.archive.ubuntu.com trusty/main i386 Packages
Hit http://us.archive.ubuntu.com trusty/restricted i386 Packages
Hit http://us.archive.ubuntu.com trusty/universe i386 Packages
Hit http://us.archive.ubuntu.com trusty/multiverse i386 Packages
Hit http://ppa.launchpad.net trusty/main i386 Packages
Hit http://us.archive.ubuntu.com trusty/main Translation-en
Hit http://us.archive.ubuntu.com trusty/multiverse Translation-en
Hit http://ppa.launchpad.net trusty/main Translation-en
Hit http://us.archive.ubuntu.com trusty/restricted Translation-en
Hit http://us.archive.ubuntu.com trusty/universe Translation-en
Ign http://us.archive.ubuntu.com trusty/main Translation-en_US
Ign http://us.archive.ubuntu.com trusty/multiverse Translation-en_US
Ign http://us.archive.ubuntu.com trusty/restricted Translation-en_US
Ign http://us.archive.ubuntu.com trusty/universe Translation-en_US
Reading package lists...
ag-fix.txt:
Code:
Reading package lists...
Building dependency tree...
Reading state information...
The following packages were automatically installed and are no longer required:
linux-headers-3.13.0-128 linux-headers-3.13.0-128-generic
linux-image-3.13.0-128-generic linux-image-extra-3.13.0-128-generic
Use 'apt-get autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 9 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-5.5 (5.5.60-0ubuntu0.14.04.1) ...
Got these errors when it got to the MySQL install:
Code:
Setting up mysql-server-5.5 (5.5.60-0ubuntu0.14.04.1) ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Setting up libqpdf21:amd64 (8.0.2-3~14.04.1) ...
Setting up linux-image-3.13.0-147-generic (3.13.0-147.196) ...
Running depmod.
No apport report written because the error message indicates its a followup error from a previous failure.
update-initramfs: deferring update (hook will be called later)
Examining /etc/kernel/postinst.d.
dpkg --debug=70 --configure mysel-server-5.5
dpkg: error processing package mysel-server-5.5 (--configure):
no package named `mysel-server-5.5' is installed, cannot configure
Errors were encountered while processing:
mysel-server-5.5
dpkg --debug=700 --configure mysql-server-5.5
D000400: checking group ...
D000400: checking possibility -> initscripts
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> libdbi-perl
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> lsb-base
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> mysql-client-5.5
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> mysql-server-core-5.5
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> passwd
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> perl
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> psmisc
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> debconf
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> sysv-rc
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> libc6
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> libstdc++6
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> zlib1g
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> adduser
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> debconf
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking group ...
D000400: checking possibility -> mysql-common
D000400: is installed, ok and found
D000400: found 3
D000400: found 3 matched 0 possfixbytrig -
D000400: checking virtbroken virtual-mysql-server
Setting up mysql-server-5.5 (5.5.60-0ubuntu0.14.04.1) ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.5
So after running all the stuff to attempt purge, had to reboot! When I rebooted something in the purges totally destroyed Xwin, so had to do a recovery there then restore the KDE Desktop.
Today after recovery of Xwin & KDE, I ran:
Code:
aptitude -f install mysql mysql-client mysql-server-5.5 mysql-server mysql-common
Which open the config interfaces where I tried to set the root password, but then that failed with:
Code:
Unable to set password for the MySQL "root" user An error occurred while setting the password for the MySQL administrative user.
This may have happened because the account already has a password, or because of a communication problem with the MySQL server.
You should check the account's password after the package installation.
Please read the /usr/share/doc/mysql-server-5.5/README.Debian file for more information.
And these additional errors at the cmd line:
Code:
Unpacking mysql-server (5.5.60-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for ureadahead (0.100.0-16) ...
ureadahead will be reprofiled on next reboot
Setting up mysql-server-5.5 (5.5.60-0ubuntu0.14.04.1) ...
180510 16:59:05 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
180510 16:59:05 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
180510 16:59:05 [Note] /usr/sbin/mysqld (mysqld 5.5.60-0ubuntu0.14.04.1) starting as process 15650 ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up mysql-server-5.5 (5.5.60-0ubuntu0.14.04.1) ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.5
mysql-server
Then when I attempt the installs via Synaptic Package Manager, still get the "HELD" packages errors, but ran
So per the error attempted to read the README.Debian file, but it is actually README>Debian.gz so had to run ARK and extra to a local readable directory.
I says run the cmds:
Code:
/usr/bin/mysql -u root -D mysql -e "update user set password=password('newpassword') where user='root'"
/usr/bin/mysql -u root -e "flush privileges"
but those produce the error:
Code:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
which was the original error I started with!
Anyway exhausted on this, so need help quickly as possible!
After hours of research to solve this finding that over 95% of the HOWTOs on this subject just think your mysql stopped and a simple "restart" will fix this.
But when you keep getting errors on:
Restart,
Purge,
Re-install,
Install,
and Ps -A | grep mysql ===> Shows nothing.
Then you know your have a serious problem to debug and nothing in the MySQL docs covers any of this, then you know you need real help.
Even the cmd:
Code:
dpkg --get-selections | grep hold
shows nothing, as no packages held;
But all the errors are telling you absolutely any apt-get commands will not run due to "held" packages, you need a guru.
Been battling an issue for 10 days now on my Aspire 7739 Laptop running Kubuntu 14.04 LTS. Wrote this up her originally om: 05/09
After hours of research to solve this finding that over 95% of the HOWTOs on this subject just think your mysql stopped and a simple "restart" will fix this, I'm going crazy. Been pounding on irc.freenode.net to attempt solutions from the gurus there. Nothing!
I keep getting errors on:
service apache2 restart,
service mysql restart/start/stop,
apt-get purge (anything),
apt-get install (anything),
apt-get -f install (anything),
apt-get reinstall (anything),
Synaptic Package Manager.
Synaptic Package Manager always says the errors are due to held packages, but the cmd to show them:
Code:
dpkg --get-selections | grep hold
and
Code:
Ps -A | grep mysql
===> Shows nothing.
So this is a serious problem, broken mysql install which has either fragmented or incompatible packages and all the debug and other HOWTOs in the MySQL docs says nothing that covers any of this!
So you know I need real serious help.
The broken/held package errors appear on any apt-get commands so nothing in the normal apt-get can run and therefore all the normal fixes just don't work. I had this issue last year, when one of my customers upgraded to PHP7/MySQL7 and to support them attempted upgrade to MySQL7 and we found that the incompatibility kept breaking apt-get, so had to create a container, with newer OS and basically LAMP7.
With help from the gurus at: irc.freenode.net we found and cleared all the MySQL 7 stuff that was breaking things, but when this last software package installed (seopanel) wondering if some of the 7 stuff got back into the update pool? I don't remember where to find all this, so if you know, so I can open all the right files and clear this junk, would appreciate it.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.