BinaryData Posted December 17, 2016 Share Posted December 17, 2016 Specs 2.13Ghz Processor 1GB Memory 60GB SSD https://gyazo.com/014407946954356a7af3c0c7c8f2af4b SQL crashed sometime this morning at 4AM. I haven't been able to get it to start again, config files are empty. Nothing is there. I can't start the service, and then login either. I was thinking about re-installing the service, however I wasn't sure what that would do to the DBs on there. Is there a tool to where I can make an image of this and toss it into a VM to test? Link to comment Share on other sites More sharing options...
+BudMan MVC Posted December 17, 2016 MVC Share Posted December 17, 2016 Who says mysql is not running?? From your screenshot its running - process 20774 Your getting login errors.. You have the wrong path to your sock file? sudo find / -type s This will tell you your sockets.. Link to comment Share on other sites More sharing options...
BinaryData Posted December 17, 2016 Author Share Posted December 17, 2016 Quote root@nl-gxs-main:~# sudo find / -type s find: `/proc/21566/task/21566/fd/5': No such file or directory find: `/proc/21566/task/21566/fdinfo/5': No such file or directory find: `/proc/21566/fd/5': No such file or directory find: `/proc/21566/fdinfo/5': No such file or directory /run/acpid.socket /run/mysqld/mysqld.sock /run/dbus/system_bus_socket /run/udev/control /dev/log Was the output. No DB Connections can be made, even local ones. It says the process is running, but it isn't. Quote root@nl-gxs-main:~# service --status-all [ + ] acpid [ + ] apache2 [ + ] apparmor [ ? ] apport [ + ] atd [ ? ] binfmt-support [ ? ] cloudpw [ ? ] console-setup [ + ] cron [ ? ] cryptdisks [ ? ] cryptdisks-early [ - ] dbus [ ? ] dns-clean [ + ] friendly-recovery [ - ] grub-common [ ? ] irqbalance [ ? ] killprocs [ ? ] kmod [ - ] landscape-client [ ? ] mysql [ ? ] networking [ ? ] ondemand [ ? ] open-vm-tools [ ? ] pppd-dns [ - ] procps [ ? ] rc.local [ + ] resolvconf [ - ] rsync [ + ] rsyslog [ ? ] screen-cleanup [ ? ] sendsigs [ + ] ssh [ - ] sudo [ + ] udev [ ? ] umountfs [ ? ] umountnfs.sh [ ? ] umountroot [ - ] unattended-upgrades [ - ] urandom Link to comment Share on other sites More sharing options...
BinaryData Posted December 17, 2016 Author Share Posted December 17, 2016 Looks like it was a patch that was keeping it from starting and connecting. I ran updates, and it took forever for it to be configured and working. Everything seems to be online and functioning now. Link to comment Share on other sites More sharing options...
+BudMan MVC Posted December 18, 2016 MVC Share Posted December 18, 2016 here is your socket /run/mysqld/mysqld.sock Link to comment Share on other sites More sharing options...
BinaryData Posted December 23, 2016 Author Share Posted December 23, 2016 On 12/18/2016 at 3:39 AM, BudMan said: here is your socket /run/mysqld/mysqld.sock Right, I know the socket was there. The problem was, I couldn't connect to it. It seems like running the updates fixed everything, MySQL Developers disabled something if x patch wasn't installed or something. I'm not 100% sure, but it's online and working now. I have about 100+ updates being pushed at me every week for LAMP related stuff. Link to comment Share on other sites More sharing options...
+BudMan MVC Posted December 23, 2016 MVC Share Posted December 23, 2016 well looks more like a path issue to me.. In what you posted you were trying to connect to /var/run/mysqld/mysqld.sock But as you can see your socket was /run/mysqld/mysqld.sock That looks like you were looking in var when it was really just off a /run ? Link to comment Share on other sites More sharing options...
BinaryData Posted December 23, 2016 Author Share Posted December 23, 2016 I mean, I didn't tell it to specifically look ing /var/run/mysqld/mysqld.sock, I was just using the command to start mysql. I wonder if Oracle changed where the socket was stored, and an update fixed it. Oh well, it works now after I ran all of those updates. I'll have to look into it more. Link to comment Share on other sites More sharing options...
Recommended Posts