LinuxQuestions.org
Help answer threads with 0 replies.
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 05-04-2017, 04:32 PM   #1
DiogoAbdalla
LQ Newbie
 
Registered: Feb 2010
Posts: 7

Rep: Reputation: 0
Mint 17.3: trouble installing MySQL 5.7


Hi all, Im need of some help here

I was trying to upgrade MySQL on my linux Mint 17.3 (with KDE) from 5.5 to 5.7

Following the guides at mysql.com, I first upgraded it to 5.6, which worked without problems. Then tried to install 5.7.

I downloaded mysql-apt-config_0.8.5-1_all.deb and installed it, choosing "ubuntu trusty" (because there is no Mint on the list), and then ran apt-get update and then apt-get install mysq-server, like instructed.

But I got this error:

Code:
The following packages have unmet dependencies:
 mysql-server : Depends: mysql-community-server (= 5.7.18-1ubuntu14.04) but it is not going to be installed
And then I got stuck. Ive tried removing all installed mysql stuff, like people recommended me: I can uninstall everything except mysql-common. If I try removing it, it gives me a scary huge list of dependencies that includes a bunch of KDE components

If I try aptitude install mysql-server (like I saw recommend elsewhere), it gives me this scary possible solution:

Code:
The following actions will resolve these dependencies:
      Remove the following packages:      
1)      akonadi-backend-mysql             
2)      akonadi-facebook                  
3)      akonadi-kde-resource-googledata   
4)      akonadi-server                    
5)      deluge                            
6)      deluge-gtk                        
7)      kde-config-telepathy-accounts     
8)      kde-telepathy                     
9)      kde-telepathy-auth-handler        
10)     kde-telepathy-contact-list        
11)     kde-telepathy-declarative         
12)     kde-telepathy-desktop-applets     
13)     kde-telepathy-filetransfer-handler
14)     kde-telepathy-integration-module  
15)     kde-telepathy-minimal             
16)     kde-telepathy-send-file           
17)     kde-telepathy-text-ui             
18)     kde-workspace                     
19)     kde-workspace-bin                 
20)     kdepim-runtime                    
21)     kdeplasma-addons                  
22)     knotes                            
23)     kontact                           
24)     konversation                      
25)     korganizer                        
26)     kscreensaver                      
27)     libkpeople3                       
28)     libktpcommoninternalsprivate7     
29)     mariadb-server-core-5.5           
30)     mysql-client-core-5.5             
31)     plasma-dataengines-workspace      
32)     plasma-desktop                    
33)     plasma-widgets-addons             
34)     plasma-widgets-workspace
What? Why?

Worst yet, I cant even install mysql 5.5 back. Purging mysql-apt-config and trying apt-get mysql-server again gives me this awesome error:
Code:
The following packages have unmet dependencies:
 mysql-server : Depends: mysql-server-5.5 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
What can I do? Short of reinstalling the whole system, which is really not an option now. Please help
 
Old 05-04-2017, 04:54 PM   #2
hydrurga
LQ Guru
 
Registered: Nov 2008
Location: Pictland
Distribution: Linux Mint 20 MATE
Posts: 8,048
Blog Entries: 5

Rep: Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917
If you haven't made any backups in recent days (which I would heartily recommend you do in the future on a regular basis, but particularly before important changes) then, short of reinstalling, what you can do is try to work backwards.

So, please paste the tail end of /var/log/apt/history.log (everything after and including your upgrade of MySql to 5.6).

By the way, Ubuntu Trusty was indeed the right choice for Mint 17.3. However you should consider upgrading at some point to the latest version of Mint 18.1 (especially if you are forced to do a reinstall).
 
1 members found this post helpful.
Old 05-04-2017, 06:07 PM   #3
DiogoAbdalla
LQ Newbie
 
Registered: Feb 2010
Posts: 7

Original Poster
Rep: Reputation: 0
Thank you a lot, man

Here's the log:

Code:
Start-Date: 2017-05-03  18:24:04
Commandline: apt-get upgrade
Upgrade: libegl1-mesa:amd64 (10.1.3-0ubuntu0.5, 10.1.3-0ubuntu0.6), libegl1-mesa:i386 (10.1.3-0ubuntu0.5, 10.1.3-0ubuntu0.6), libruby1.9.1:amd64 (1.9.3.484-2ubuntu1.2, 1.9.3.551-2bbox1~trusty1), libopenvg1-mesa:amd64 (10.1.3-0ubuntu0.4, 10.1.3-0ubuntu0.6), virtualbox:amd64 (4.3.18-dfsg-1~ubuntu1~trusty1, 5.0.4-dfsg-2), dbus:amd64 (1.6.18-0ubuntu4.3, 1.6.18-0ubuntu4.5), google-chrome-stable:amd64 (58.0.3029.81-1, 58.0.3029.96-1), libicu52:amd64 (52.1-3ubuntu0.5, 52.1-3ubuntu0.6), grub-common:amd64 (2.02~beta2-9ubuntu1.2, 2.02~beta2-9ubuntu1.12), base-files:amd64 (7.2ubuntu5.2, 7.2ubuntu5.5), grub2-common:amd64 (2.02~beta2-9ubuntu1.2, 2.02~beta2-9ubuntu1.12), virtualbox-dkms:amd64 (4.3.18-dfsg-1~ubuntu1~trusty1, 5.0.4-dfsg-2), libxatracker2:amd64 (10.1.3-0ubuntu0.4, 10.1.3-0ubuntu0.6), smplayer-themes:amd64 (15.6.0-1~trusty1, 17.3.0-1~trusty1), virtualbox-qt:amd64 (4.3.18-dfsg-1~ubuntu1~trusty1, 5.0.4-dfsg-2), xserver-xorg-video-intel:amd64 (2.99.910-0ubuntu1.6, 2.99.910-0ubuntu1.7), libwayland-egl1-mesa:amd64 (10.1.3-0ubuntu0.5, 10.1.3-0ubuntu0.6), libwayland-egl1-mesa:i386 (10.1.3-0ubuntu0.5, 10.1.3-0ubuntu0.6), grub-pc-bin:amd64 (2.02~beta2-9ubuntu1.2, 2.02~beta2-9ubuntu1.12), grub-pc:amd64 (2.02~beta2-9ubuntu1.2, 2.02~beta2-9ubuntu1.12), libgbm1:amd64 (10.1.3-0ubuntu0.5, 10.1.3-0ubuntu0.6), libgbm1:i386 (10.1.3-0ubuntu0.5, 10.1.3-0ubuntu0.6), youtube-dl:amd64 (2017.04.17-1~webupd8~trusty0, 2017.05.01-1~webupd8~trusty0), xserver-xorg-video-openchrome:amd64 (0.3.3-1build1, 0.3.3-1ubuntu0.1), linux-firmware:amd64 (1.127.12, 1.127.23), dbus-x11:amd64 (1.6.18-0ubuntu4.3, 1.6.18-0ubuntu4.5), ruby1.9.1:amd64 (1.9.3.484-2ubuntu1.2, 1.9.3.551-2bbox1~trusty1), linux-libc-dev:amd64 (3.13.0-53.89, 3.13.0-117.164)
End-Date: 2017-05-03  18:29:29

Start-Date: 2017-05-03  18:31:56
Commandline: apt-get install mysql-server-5.6
Install: mysql-server-core-5.6:amd64 (5.6.33-0ubuntu0.14.04.1, automatic), mysql-server-5.6:amd64 (5.6.33-0ubuntu0.14.04.1), mysql-client-core-5.6:amd64 (5.6.33-0ubuntu0.14.04.1, automatic), mysql-client-5.6:amd64 (5.6.33-0ubuntu0.14.04.1, automatic)
Remove: mysql-server-core-5.5:amd64 (5.5.55-0ubuntu0.14.04.1), mysql-server-5.5:amd64 (5.5.55-0ubuntu0.14.04.1), mysql-client-core-5.5:amd64 (5.5.55-0ubuntu0.14.04.1), mysql-client-5.5:amd64 (5.5.55-0ubuntu0.14.04.1), mysql-server:amd64 (5.5.55-0ubuntu0.14.04.1)
End-Date: 2017-05-03  18:33:00

Start-Date: 2017-05-04  14:10:01
Commandline: apt-get purge mysql-client-core-5.6
Install: mysql-client-core-5.5:amd64 (5.5.55-0ubuntu0.14.04.1, automatic)
Purge: mysql-server-5.6:amd64 (5.6.33-0ubuntu0.14.04.1), mysql-client-core-5.6:amd64 (5.6.33-0ubuntu0.14.04.1), mysql-client-5.6:amd64 (5.6.33-0ubuntu0.14.04.1)
End-Date: 2017-05-04  14:10:23

Start-Date: 2017-05-04  14:11:05
Commandline: apt-get purge mysql-server-core-5.6
Install: mysql-server-core-5.5:amd64 (5.5.55-0ubuntu0.14.04.1, automatic)
Purge: mysql-server-core-5.6:amd64 (5.6.33-0ubuntu0.14.04.1)
End-Date: 2017-05-04  14:11:11

Start-Date: 2017-05-04  14:11:28
Commandline: apt-get autoremove
Remove: libterm-readkey-perl:amd64 (2.31-1)
End-Date: 2017-05-04  14:11:29

Start-Date: 2017-05-04  14:17:41
Commandline: /usr/sbin/synaptic
Upgrade: mysql-common:amd64 (5.5.55-0ubuntu0.14.04.1, 5.7.18-1ubuntu14.04)
End-Date: 2017-05-04  14:17:44

Start-Date: 2017-05-04  14:18:51
Commandline: apt-get purge mysql-server-core-5.5
Install: mariadb-common:amd64 (5.5.54-1ubuntu0.14.04.1, automatic), mariadb-server-core-5.5:amd64 (5.5.54-1ubuntu0.14.04.1, automatic)
Purge: mysql-server-core-5.5:amd64 (5.5.55-0ubuntu0.14.04.1)
End-Date: 2017-05-04  14:18:57

Start-Date: 2017-05-04  14:29:05
Commandline: apt-get upgrade
Upgrade: gzdoom:amd64 (3.0.0, 3.0.1)
End-Date: 2017-05-04  14:29:10

Start-Date: 2017-05-04  14:30:15
Commandline: apt-get purge mysql-apt-config
Purge: mysql-apt-config:amd64 (0.8.5-1)
End-Date: 2017-05-04  14:30:17

Start-Date: 2017-05-04  14:33:06
Commandline: apt-get purge mysql-apt-config
Purge: mysql-apt-config:amd64 (0.8.5-1)
End-Date: 2017-05-04  14:33:08

Start-Date: 2017-05-04  14:49:34
Commandline: apt-get purge mysql-apt-config
Purge: mysql-apt-config:amd64 (0.8.5-1)
End-Date: 2017-05-04  14:49:35

Start-Date: 2017-05-04  14:50:33
Commandline: apt-get purge mysql-client-core-5.5
Install: libmariadbclient18:amd64 (5.5.54-1ubuntu0.14.04.1, automatic), mariadb-client-core-5.5:amd64 (5.5.54-1ubuntu0.14.04.1, automatic)
Purge: mysql-client-core-5.5:amd64 (5.5.55-0ubuntu0.14.04.1)
End-Date: 2017-05-04  14:50:40

Start-Date: 2017-05-04  14:51:03
Commandline: apt-get purge mysql-server-5.5
Purge: mysql-server-5.5:amd64 ()
End-Date: 2017-05-04  14:51:05

Start-Date: 2017-05-04  14:52:13
Commandline: apt-get purge php5-mysql
Purge: php5-mysql:amd64 (5.5.9+dfsg-1ubuntu4.21)
End-Date: 2017-05-04  14:52:16

Start-Date: 2017-05-04  14:52:33
Commandline: apt-get purge php5.6-mysql
Purge: php5.6-mysql:amd64 (5.6.30-10+deb.sury.org~trusty+2)
End-Date: 2017-05-04  14:52:35

Start-Date: 2017-05-04  14:53:42
Commandline: /usr/sbin/synaptic
Remove: libdbd-mysql-perl:amd64 (4.025-1ubuntu0.1)
End-Date: 2017-05-04  14:53:44

Start-Date: 2017-05-04  14:54:08
Commandline: /usr/sbin/synaptic
Remove: libmysql-java:amd64 (5.1.28-1), libnb-ide14-java:amd64 (7.0.1+dfsg1-5ubuntu2), libnb-java5-java:amd64 (7.0.1+dfsg1-5ubuntu2), libnb-apisupport3-java:amd64 (7.0.1+dfsg1-5ubuntu2)
End-Date: 2017-05-04  14:54:11

Start-Date: 2017-05-04  15:02:18
Commandline: /usr/sbin/synaptic
Purge: mysql-apt-config:amd64 (0.8.5-1)
End-Date: 2017-05-04  15:02:20

Start-Date: 2017-05-04  15:02:57
Commandline: /usr/sbin/synaptic
Downgrade: mysql-common:amd64 (5.7.18-1ubuntu14.04, 5.5.55-0ubuntu0.14.04.1)
End-Date: 2017-05-04  15:02:59

Start-Date: 2017-05-04  15:04:15
Upgrade: mysql-common:amd64 (5.5.55-0ubuntu0.14.04.1, 5.7.18-1ubuntu14.04)
End-Date: 2017-05-04  15:04:16

Start-Date: 2017-05-04  15:04:29
End-Date: 2017-05-04  15:04:29

Start-Date: 2017-05-04  15:08:53
Commandline: apt-get purge mysql-apt-config
Purge: mysql-apt-config:amd64 (0.8.5-1)
End-Date: 2017-05-04  15:08:55

Start-Date: 2017-05-04  15:28:07
Commandline: apt-get purge mysql-apt-config
Purge: mysql-apt-config:amd64 (0.8.5-1)
End-Date: 2017-05-04  15:28:08

Start-Date: 2017-05-04  15:32:33
Commandline: /usr/sbin/synaptic
Downgrade: mysql-common:amd64 (5.7.18-1ubuntu14.04, 5.5.55-0ubuntu0.14.04.1)
End-Date: 2017-05-04  15:32:35

Start-Date: 2017-05-04  15:32:51
Commandline: /usr/sbin/synaptic
Reinstall: mysql-common:amd64 (5.5.55-0ubuntu0.14.04.1)
End-Date: 2017-05-04  15:32:53

Start-Date: 2017-05-04  15:37:11
Commandline: /usr/sbin/synaptic
Reinstall: plasma-desktop:amd64 (4.11.11-0ubuntu0.2)
End-Date: 2017-05-04  15:37:16

Start-Date: 2017-05-04  15:55:06
Commandline: apt-get install -f
Install: mysql-common:amd64 (5.7.18-1ubuntu14.04, automatic)
End-Date: 2017-05-04  15:55:08

Start-Date: 2017-05-04  15:58:39
Commandline: /usr/sbin/synaptic
Purge: mysql-apt-config:amd64 (0.8.5-1)
End-Date: 2017-05-04  15:58:40

Start-Date: 2017-05-04  16:09:01
Commandline: apt-get install -f
Install: mysql-client-core-5.5:amd64 (5.5.55-0ubuntu0.14.04.1, automatic), mysql-common:amd64 (5.5.55-0ubuntu0.14.04.1, automatic), mariadb-common:amd64 (5.5.54-1ubuntu0.14.04.1, automatic)
End-Date: 2017-05-04  16:09:04

Start-Date: 2017-05-04  16:19:56
Commandline: /usr/sbin/synaptic
Purge: mysql-apt-config:amd64 (0.8.5-1)
End-Date: 2017-05-04  16:19:58
You can see that yesterday Ive upgraded to MySQL 5.6, which went fine

Confusion starts today, after MySQL 5.7 fails to install and I start desperately trying everything
 
Old 05-04-2017, 06:23 PM   #4
hydrurga
LQ Guru
 
Registered: Nov 2008
Location: Pictland
Distribution: Linux Mint 20 MATE
Posts: 8,048
Blog Entries: 5

Rep: Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917
Ok, thanks. Let's give this a go. First of all, have you saved all data or documents that you have in case things go awry?

The last entry was you purging mysql-apt-config, and it appears that it was successful, so we can ignore that.

To reverse the penultimate entry (we'll try all the packages on that line in one go to start off with):

Code:
sudo apt-get -s --purge autoremove mysql-client-core-5.5 mysql-common mariadb-common
I've intentionally put a -s flag (simulate) in there so that we can see what apt-get proposes to do before it does it. Please paste the output from the above command and we'll check that it's not going to do any damage.

Also, I'm not very knowledgeable in this area, but are you sure that it was a good idea to install both mysql-common and mariadb-common? MariaDB is a replacement for MySQL, so you might have had some unwelcome crossover there. Installing both on the same system actually requires some jiggery-pokery (https://mariadb.com/kb/en/mariadb/in...ongside-mysql/). Anyway, I digress...
 
1 members found this post helpful.
Old 05-05-2017, 10:51 AM   #5
DiogoAbdalla
LQ Newbie
 
Registered: Feb 2010
Posts: 7

Original Poster
Rep: Reputation: 0
Thanks, lets try it.

Well, mysql-client-core-5.5 is not installed anymore, and trying to remove mysql-common makes apt-get s*** its pants:

Code:
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package 'mysql-client-core-5.5' is not installed, so not removed
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 plasma-netbook : Depends: plasma-widgets-workspace (= 4:4.11.11-0ubuntu0.2) but it is not going to be installed
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.
According to what I can see in Synaptic, a whole bunch of stuff, including "plasma-desktop", depend on mysql-common. Why is that? Is that normal? Ive attached a screenshot of the Synaptic dialog

Also, Ive found that even though I cant install MySQL 5.7 or 5.5, I can still install 5.6 again, for some reason: apt-get install mysql-server-5.6 ran and installed mysql back without problems, and its working

But still, I needed 5.7
Attached Thumbnails
Click image for larger version

Name:	common.png
Views:	24
Size:	64.1 KB
ID:	24933  

Last edited by DiogoAbdalla; 05-05-2017 at 10:53 AM.
 
Old 05-05-2017, 11:03 AM   #6
hydrurga
LQ Guru
 
Registered: Nov 2008
Location: Pictland
Distribution: Linux Mint 20 MATE
Posts: 8,048
Blog Entries: 5

Rep: Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917Reputation: 2917
So you've installed mysql 5.6 since that history log you posted?

My advice is to reinstall Linux. Sorry.
 
Old 05-05-2017, 11:29 AM   #7
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Abingdon, VA
Distribution: Catalina
Posts: 9,374
Blog Entries: 37

Rep: Reputation: Disabled
Quote:
Originally Posted by DiogoAbdalla View Post
I needed 5.7
Why?


How to install software on Linux Mint

Last edited by Habitual; 05-05-2017 at 11:30 AM.
 
Old 05-05-2017, 11:38 AM   #8
DiogoAbdalla
LQ Newbie
 
Registered: Feb 2010
Posts: 7

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by hydrurga View Post
So you've installed mysql 5.6 since that history log you posted?

My advice is to reinstall Linux. Sorry.
Just today. I needed mysql to work, so its better than nothing. Reinstalling linux is really not an option right now: I dont have the time or even an external to HD backup the things I need. I do intend to do it soon, but right now I just cant

Quote:
Originally Posted by Habitual View Post
Because I want to use the new JSON data type

edit: in any case, is it normal that all those components depend on mysql-common? Or something is really wrong here? I find very strange that plasma-desktop would need mysql to work

Last edited by DiogoAbdalla; 05-05-2017 at 11:49 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Trouble installing Mint 17.1 warewasher Linux - Newbie 20 04-25-2017 02:53 PM
[SOLVED] Trouble installing Mint on new Acer Aspire kawedel Linux - Newbie 12 02-21-2017 11:22 PM
i'm having trouble installing linux mint 17.2 on my HP laptop tbrownarcher Linux - Laptop and Netbook 5 07-08-2015 10:15 AM
[SOLVED] Trouble installing Linux Mint 16 L.Jones Linux - Laptop and Netbook 9 02-02-2014 03:21 PM
trouble installing linux mint nasa_pete Linux - Newbie 2 09-19-2010 10:58 PM

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

All times are GMT -5. The time now is 08:02 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