LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This 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


Reply
  Search this Thread
Old 09-20-2018, 09:59 AM   #16
TBotNik
Member
 
Registered: May 2016
Location: Greenville, TX
Distribution: Kubuntu 18.04
Posts: 796

Original Poster
Rep: Reputation: Disabled

hydrurga,

Can't even advertise myself as available for work till MySQL is working flawlessly! Thought I was flawless on my server but had to reboot this AM and BAM the plasma DT was gone. Now restoring! Got it down to 2 BASH script to restore KDE, but that is without MySQL and all development is in PHP with MySQL interactions!

TBNK
 
Old 09-20-2018, 10:02 AM   #17
TBotNik
Member
 
Registered: May 2016
Location: Greenville, TX
Distribution: Kubuntu 18.04
Posts: 796

Original Poster
Rep: Reputation: Disabled
All,

Been downloading tar and deb files for MySQL from 5.5 to 8.0 so I can attempt gdebi installs, bypassing normal apt-get installs to see which version started the interdependancies on the Plasma/KDE desktop and which is therefore bad.

Cheers!

TBNK
 
Old 09-20-2018, 10:19 AM   #18
hydrurga
LQ Guru
 
Registered: Nov 2008
Location: Pictland
Distribution: Linux Mint 21 MATE
Posts: 8,048
Blog Entries: 5

Rep: Reputation: 2925Reputation: 2925Reputation: 2925Reputation: 2925Reputation: 2925Reputation: 2925Reputation: 2925Reputation: 2925Reputation: 2925Reputation: 2925Reputation: 2925
Quote:
Originally Posted by TBotNik View Post
hydrurga,

Can't even advertise myself as available for work till MySQL is working flawlessly! Thought I was flawless on my server but had to reboot this AM and BAM the plasma DT was gone. Now restoring! Got it down to 2 BASH script to restore KDE, but that is without MySQL and all development is in PHP with MySQL interactions!

TBNK
Yes, but if you're losing out on potential $250K projects, then perhaps you should really be paying a professional to sort this out for you. A professional, for example, would have advised you to make regular system backups/snapshots/images, particularly when everything was going smoothly, so that you could roll back to a previous working version of your system.

Upgrading to the latest versions of MySQL etc. on an old Kubuntu 14.04 system has the potential to be fraught with difficulties due to the dependencies involved, as you've found out. It would be more advisable to create virtual machines running more up-to-date distros which support the versions of MySQL that you want to use.
 
Old 09-20-2018, 03:26 PM   #19
TBotNik
Member
 
Registered: May 2016
Location: Greenville, TX
Distribution: Kubuntu 18.04
Posts: 796

Original Poster
Rep: Reputation: Disabled
All,

OK ran my script on MySQL version 5.5 and got this after successful run:
Quote:
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

>:# cp /etc/mysql/my.cnf /usr/share/mysql/my-default.cnf;

>:# mysql_secure_installation;
The program 'mysql_secure_installation' can be found in the following packages:
* mysql-server-5.5
* mariadb-server-5.5
* mysql-server-5.6
* percona-xtradb-cluster-server-5.5
Try: apt-get install <selected package>

>:# mysql_install_db;
Neither host 'hostname' nor 'localhost' could be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option
Not sure what all this means or the next steps! At least the installs ran, but have not rebooted to see if it blew the plasma, but will now to test the plasma results!

Cheers!

TBNK
 
Old 09-20-2018, 04:05 PM   #20
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Quote:
Originally Posted by TBotNik View Post
All,

Been downloading tar and deb files for MySQL from 5.5 to 8.0 so I can attempt gdebi installs, bypassing normal apt-get installs to see which version started the interdependancies on the Plasma/KDE desktop and which is therefore bad.

Cheers!

TBNK
those mysql repos aren't serving up any desktop conflicts.
Across the street that's a FrankenDebian. "Bypassing normal apt-get" (ubuntu's repos)
You're making penguins cry

apt-get --dry-run -install <toaster.bios>.deb
apt-cache search <package>

https://duckduckgo.com/?q=Kubuntu+14...%3Akubuntu.org
From my VLG blog post: (if you're interested in fixing yer toaster)

### Debian ###
Debian Administration - Debian Administration Resources - Retired
Debian Linux Tutorial - Linux Servers / Networking / Installation and Instructions for Home Server
Debian GNU/Linux Installation Guide
Debian HCL; Debian GNU/Linux device driver check & report
The Debian Administrator's Handbook
Debian Social Contract
Reasons to Choose Debian
Official Debian mirrors also here...
Basics of the Debian package management system
Debian package management
Debian package management tools
Newbiedoc
Aptitude user's manual
Apt - Debian Wiki
The APT, Dpkg Quick Reference
Secure APT
Aptitude - Debian Wiki
SourcesList - Debian Wiki
AptPreferences - Debian Wiki
Apt-Pinning for Beginners
Search Debian -- Packages
apt-get.org: Unofficial APT repositories
Debian-Database.ORG - Unofficial Debian Repositories Collected
UnofficialRepositories - Debian Wiki
Debian infographic
smxi - unofficial Debian maintenance script

John out.
 
Old 10-10-2018, 11:15 AM   #21
TBotNik
Member
 
Registered: May 2016
Location: Greenville, TX
Distribution: Kubuntu 18.04
Posts: 796

Original Poster
Rep: Reputation: Disabled
All,

OK if I'm seeing this right this is a config issue. Been looking for a definative HOWTO on this and not finding what I need so open to suggestions.

Habitual,

Just back from vacation and finally have inet at home, but really busy during the days, so slowly working through the list you sent.

Cheers!

TBNK
 
Old 02-20-2019, 07:42 PM   #22
TBotNik
Member
 
Registered: May 2016
Location: Greenville, TX
Distribution: Kubuntu 18.04
Posts: 796

Original Poster
Rep: Reputation: Disabled
All,

Totally gave up on this as the MySQL upgrades completely destroyed both the MySQL and the XWin on all machines where an upgrade was initiated, so had to go back a re-install from the "Live DVD". Notice I also reported that none of the 16.04 LTS and 18.04 LTS "Live DVDs" work as after burn and attempt to install from the DVD drive all error and crap out in the middle of the install, and same trying on "brand new" machines.

Ubuntu/Kubuntu did not test anything since the release of 14.04, which is totally obvious!

Cheers!

TBNK
 
Old 03-12-2019, 09:16 AM   #23
TBotNik
Member
 
Registered: May 2016
Location: Greenville, TX
Distribution: Kubuntu 18.04
Posts: 796

Original Poster
Rep: Reputation: Disabled
All,

Finally found a solution to the mysql install issues. Still not sure what is blowing it off, but forgeting all the wrong/erroneous HOWTOS, it's simply:
Code:
apt-get install mysql-server
The built-in mysql errors are in those extra packages that all the HOWTOS say you need to add!

Cheers!

TBNK
 
Old 03-26-2019, 01:51 PM   #24
TBotNik
Member
 
Registered: May 2016
Location: Greenville, TX
Distribution: Kubuntu 18.04
Posts: 796

Original Poster
Rep: Reputation: Disabled
All,

Finally found the answer on this. The command for installing/re-installing MySQL, where all the problems start, is simply:
Code:
apt-get install mysql-server
All the HOWTOs on this have 2-12 additional things to install with this and all that is where the errors originate. I had to do a "LIVE_DVD" re-install after all this destroyed the KDE Desktop, but then lost the DB again, and found this simple cmd in "synaptic", so now reloading all my DBs and should soon be running at full capacity for this server.

Marking this "solved"!

Cheers!

TBNK
 
1 members found this post helpful.
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
GRUB install problems... (post windows install on ubuntu) sersdf Linux - Software 4 02-27-2009 07:59 AM
apt-get install dependency problems with hplip software and kde install for Agnula maybi7 Linux - Software 1 02-03-2007 05:16 PM
install suse 9.3 on a PIII system??? problems in the install screen : flickers! :( akshay_jp SUSE / openSUSE 3 09-12-2006 11:53 AM
Ethernet Adsl Modem Driver Problems And Install Problems... akhilnair Linux - Hardware 12 11-28-2004 08:19 AM
Mandrake 9.1 Install problems (Graphical problems) sw4eternity Linux - Newbie 5 11-01-2003 08:43 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:06 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration