maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

I checked in Fedora21 (Desktop).  It's standard repositories have MariaDB
10.0.14 available and here "rpm -qa | grep maria" returns what it should.


-- peter

On Tue, Nov 25, 2014 at 4:47 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>
wrote:

> One more correction/etal.  "MySQL" acutally appears in YaST "Service
> Manager".  But (I think) it appears as running even if it stoppedd.
>
> -- Peter
>
> On Tue, Nov 25, 2014 at 2:36 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>
> wrote:
>
>> Addtionally I had hoped that TokuDb was there.  But it seems not.  SuSE
>> is also not listed here:
>> https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-to-enable-tokudb-in-mariadb/
>>
>> -- Peter
>>
>> On Tue, Nov 25, 2014 at 2:10 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>
>> wrote:
>>
>>> I was just about to reply that!-- peter
>>>
>>> On Tue, Nov 25, 2014 at 2:08 PM, jocelyn fournier <
>>> jocelyn.fournier@xxxxxxxxx> wrote:
>>>
>>>>  oups, sorry, I missed your
>>>>
>>>> peter@linux-hwpu:~> rpm -qa | grep maria
>>>>
>>>> line
>>>>
>>>>
>>>> Le 25/11/2014 14:07, jocelyn fournier a écrit :
>>>>
>>>> Hi,
>>>>
>>>> Perhaps try to grep mariadb instead of mysql ?
>>>>
>>>> HTH,
>>>>   Jocelyn
>>>>
>>>>
>>>> Le 25/11/2014 14:00, Peter Laursen a écrit :
>>>>
>>>> wrong again .. the server. clients, and CONNCT engine are installed.
>>>> and sever is running
>>>>
>>>>
>>>>
>>>>  peter@linux-hwpu:~> mysql
>>>> Welcome to the MariaDB monitor.  Commands end with ; or \g.
>>>> Your MariaDB connection id is 4
>>>> Server version: 10.0.15-MariaDB MariaDB Server
>>>>
>>>>  Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
>>>>
>>>>  Type 'help;' or '\h' for help. Type '\c' to clear the current input
>>>> statement.
>>>>
>>>>  MariaDB [(none)]> show databases
>>>>     -> ;
>>>> +--------------------+
>>>> | Database           |
>>>> +--------------------+
>>>> | information_schema |
>>>> | test               |
>>>> +--------------------+
>>>>  2 rows in set (0,01 sec)
>>>>
>>>>  MariaDB [(none)]> show engines;
>>>>
>>>> +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
>>>> | Engine             | Support | Comment
>>>>                                      | Transactions | XA   | Savepoints |
>>>>
>>>> +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
>>>> | MEMORY             | YES     | Hash based, stored in memory, useful
>>>> for temporary tables                  | NO           | NO   | NO         |
>>>> | CSV                | YES     | CSV storage engine
>>>>                                     | NO           | NO   | NO         |
>>>> | MyISAM             | YES     | MyISAM storage engine
>>>>                                      | NO           | NO   | NO         |
>>>> | BLACKHOLE          | YES     | /dev/null storage engine (anything you
>>>> write to it disappears)             | NO           | NO   | NO         |
>>>> | MRG_MyISAM         | YES     | Collection of identical MyISAM tables
>>>>                                      | NO           | NO   | NO         |
>>>> | CONNECT            | YES     | Management of External Data (SQL/MED),
>>>> including many file formats         | NO           | NO   | NO         |
>>>> | FEDERATED          | YES     | FederatedX pluggable storage engine
>>>>                                      | YES          | NO   | YES        |
>>>> | ARCHIVE            | YES     | Archive storage engine
>>>>                                     | NO           | NO   | NO         |
>>>> | InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions,
>>>> row-level locking, and foreign keys | YES          | YES  | YES        |
>>>> | PERFORMANCE_SCHEMA | YES     | Performance Schema
>>>>                                     | NO           | NO   | NO         |
>>>> | Aria               | YES     | Crash-safe tables with MyISAM heritage
>>>>                                     | NO           | NO   | NO         |
>>>>
>>>> +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
>>>> 11 rows in set (0,00 sec)
>>>>
>>>>  MariaDB [(none)]>
>>>>
>>>>
>>>>
>>>>  -- Peter
>>>>
>>>>  MariaDB [(none)]>
>>>>
>>>>
>>>>
>>>>  .. but the"rpm" command does not return it?
>>>>
>>>>
>>>>  -- Peter
>>>>
>>>> On Tue, Nov 25, 2014 at 1:38 PM, Peter Laursen <
>>>> peter_laursen@xxxxxxxxxx> wrote:
>>>>
>>>>> oops .. it seems that I am wrong!
>>>>>
>>>>>
>>>>>  peter@linux-hwpu:~> rpm -qa | grep mysql
>>>>> libmysqld18-10.0.13-2.3.2.x86_64
>>>>> libqt4-sql-mysql-4.8.6-4.4.1.x86_64
>>>>> libreoffice-base-drivers-mysql-4.3.3.2-4.1.x86_64
>>>>> libmysqlcppconn6-1.1.2-6.2.2.x86_64
>>>>> libmysqlclient18-10.0.13-2.3.2.x86_64
>>>>> php5-mysql-5.6.1-4.1.x86_64
>>>>> peter@linux-hwpu:~> rpm -qa | grep maria
>>>>> mariadb-errormessages-10.0.13-2.3.2.x86_64
>>>>> peter@linux-hwpu:~> ^C
>>>>> peter@linux-hwpu:~>
>>>>>
>>>>>
>>>>>  .. so no server is installed now, it seems!
>>>>>
>>>>>
>>>>>  -- Peter
>>>>>
>>>>> On Tue, Nov 25, 2014 at 1:37 PM, Peter Laursen <
>>>>> peter_laursen@xxxxxxxxxx> wrote:
>>>>>
>>>>>> I did a fresh install of SuSe 1.3 with only XFCE desktop. I installed
>>>>>> the "LAMP Server" from the Installation menu.  next I installed Amarok and
>>>>>> its dependencies (and it was not a showstpper if not installed with the
>>>>>> full KDE).
>>>>>>
>>>>>>
>>>>>>  Problems still occurring
>>>>>> 1) I had to uninstall
>>>>>> 2) the command line yast2 command syntax failed, but  I was able to
>>>>>> isntall the packages one-by-one in te order specified
>>>>>> 3) after rinstallation the service does no appear in YaST 'Service
>>>>>> management' GUI. It definitely shold on SuSE.
>>>>>>
>>>>>>  (detals of the error in 1) above
>>>>>>
>>>>>>  3 nye pakker der installeres.
>>>>>> Samlet downloadstørrelse: 95,3 MiB. Allerede cachet: 0 B  Efter
>>>>>> transaktionen
>>>>>> vil yderligere 522,2 MiB blive brugt.
>>>>>> Vil du fortsætte? [j/n/? vis alle tilvalg] (j): j
>>>>>> Henter pakke MariaDB-common-10.0.15-1.x86_64
>>>>>>                                            (1/3),  19,9 KiB (173,9
>>>>>> KiB udpakket)
>>>>>> Henter pakke MariaDB-client-10.0.15-1.x86_64
>>>>>>                                            (2/3),  24,3 MiB (147,7
>>>>>> MiB udpakket)
>>>>>> Henter pakke MariaDB-server-10.0.15-1.x86_64
>>>>>>                                            (3/3),  71,0 MiB (374,4
>>>>>> MiB udpakket)
>>>>>> Tjekker for filkonflikter:
>>>>>> ...............................................[fejl]
>>>>>> Fandt 1 filkonflikt:
>>>>>>
>>>>>>  File /usr/lib64/libmysqld.so.18
>>>>>>   from install of
>>>>>>      MariaDB-server-10.0.15-1.x86_64(Cache for rene RPM-filer)
>>>>>>   conflicts with file from package
>>>>>>      libmysqld18-10.0.13-2.3.2.x86_64(@System)
>>>>>>
>>>>>>  Filkonflikter forekommer når to pakker forsøger at installere filer
>>>>>> med samme navn, men forskelligt indhold. Hvis du fortsætter vil filer i
>>>>>> konflikt blive erstattet, hvorved det tidligere indhold mistes.
>>>>>> Vil du fortsætte? [ja/nej] (nej): nej
>>>>>>
>>>>>>  Der opstod en problem under eller efter installation eller
>>>>>> fjernelse af pakker:
>>>>>> Installation aborted by user  <-- what is not true. I was not given a
>>>>>> choice!)
>>>>>>
>>>>>>
>>>>>>  Please test your RPMs for use in GUI environments.  Currently it is
>>>>>> hardly usable here. Also consider that people may already have installed
>>>>>> the server shipping with the distro. I guess i would work if KDE was not
>>>>>> installed and MySQL/MariaDB also was not. I think it would be prefaerable
>>>>>> if MariaDBs RPMs for SuSE had the same structure and dependencies as those
>>>>>> shipped by SuSE so that existing installation could be upgraded. But that
>>>>>> is a rather 'unqualified opinion'. You probably have reasons to do as you
>>>>>> do.
>>>>>>
>>>>>>
>>>>>>
>>>>>>  -- Peter
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, Nov 24, 2014 at 8:22 PM, Peter Laursen <
>>>>>> peter_laursen@xxxxxxxxxx> wrote:
>>>>>>
>>>>>>> Won't work. The problem is KDE it seems.  I use the XFCE desktop
>>>>>>> primarily but did also installed KDE and a few more desktops (just in order
>>>>>>> to check them). But the only KDE program that I really want is Amarok.
>>>>>>>
>>>>>>>
>>>>>>>  peter@linux-zayf:~/Skrivebord/MariaDB> sudo yast2 -i
>>>>>>> ./MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm
>>>>>>> ./MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm
>>>>>>> ./MariaDB-10.0.15-opensuse13_1-x86_64-client.rpm
>>>>>>> DEPRECATED. Use zypper directly: zypper --non-interactive install
>>>>>>> ./MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm
>>>>>>> ./MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm
>>>>>>> ./MariaDB-10.0.15-opensuse13_1-x86_64-client.rpm
>>>>>>> Indlæser softwarekildedata...
>>>>>>> Læser installerede pakker...
>>>>>>> Løser pakkeafhængigheder...
>>>>>>> 2 problemer:
>>>>>>> Problem: mariadb-client-10.0.13-2.3.2.x86_64 konflikter med
>>>>>>> namespace:otherproviders(mysql-client), der leveres af
>>>>>>> MariaDB-client-10.0.15-1.x86_64
>>>>>>> Problem: MariaDB-server-10.0.15-1.x86_64 kræver MariaDB-client, men
>>>>>>> dette krav kan ikke leveres
>>>>>>>
>>>>>>>  Problem: mariadb-client-10.0.13-2.3.2.x86_64 konflikter med
>>>>>>> namespace:otherproviders(mysql-client), der leveres af
>>>>>>> MariaDB-client-10.0.15-1.x86_64
>>>>>>>  Løsning 1: Følgende handlinger udføres:
>>>>>>>   afinstallation af mariadb-client-10.0.13-2.3.2.x86_64
>>>>>>>   afinstallation af akonadi-4.14.3-4.4.x86_64
>>>>>>>   afinstallation af python-kde4-akonadi-4.14.3-4.3.x86_64
>>>>>>>   afinstallation af plasma-addons-lancelot-4.14.3-8.3.x86_64
>>>>>>>   afinstallation af plasma-addons-akonadi-4.14.3-8.3.x86_64
>>>>>>>   afinstallation af korganizer-4.14.3-4.4.x86_64
>>>>>>>   afinstallation af kontact-4.14.3-4.4.x86_64
>>>>>>>   afinstallation af kmail-4.14.3-4.4.x86_64
>>>>>>>   afinstallation af kdepim4-runtime-4.14.3-4.2.x86_64
>>>>>>>   afinstallation af kdepim4-4.14.3-4.4.x86_64
>>>>>>>   afinstallation af kaddressbook-4.14.3-4.4.x86_64
>>>>>>>   afinstallation af knotes-4.14.3-4.4.x86_64
>>>>>>>  Løsning 2: installér ikke MariaDB-client-10.0.15-1.x86_64
>>>>>>>
>>>>>>>  Vælg blandt løsningerne ovenfor med nummer eller skip, forsøg igen
>>>>>>> eller annullér [1/2/s/f/a] (a): a  *<<-- this 'a' prompts
>>>>>>> automatically (gives me no choice) and when I try same option from YaST GUI
>>>>>>> it just reinstalls what it just removed. This is after I removed Amarok and
>>>>>>> a few other KDE programs aswell as the old MariaDB server.. originally the
>>>>>>> conflict list was longer!*
>>>>>>>
>>>>>>>  peter@linux-zayf:~/Skrivebord/MariaDB>
>>>>>>>
>>>>>>>
>>>>>>>  I have tried different things from command-line and GUI, but it
>>>>>>> seems that I will need to remove a lot of KDE software making use of MySQL,
>>>>>>> if it shall be possible to continue. Else it will not let me remove
>>>>>>> mariadb-client-10.0.13. Did someone say *depencency hell* :-).
>>>>>>>
>>>>>>>  It will probably be easier to do a fresh install of SuSE without
>>>>>>> KDE! Unless your RPMs can handle the conflicts (replacing themselves with
>>>>>>> what is already installed).Restoring snapshot!
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>  -- Peter
>>>>>>>
>>>>>>> On Mon, Nov 24, 2014 at 3:54 PM, Peter Laursen <
>>>>>>> peter_laursen@xxxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> And teh *bonus question*.  What should I remove and not remove
>>>>>>>> before installing your packages?
>>>>>>>>
>>>>>>>>
>>>>>>>>  peter@linux-zayf:~> rpm -qa | grep mysql
>>>>>>>> libmysqlclient18-10.0.13-2.3.2.x86_64
>>>>>>>> libqt4-sql-mysql-4.8.6-4.4.1.x86_64
>>>>>>>> php5-mysql-5.6.1-4.1.x86_64
>>>>>>>> libmysqld18-10.0.13-2.3.2.x86_64
>>>>>>>> libmysqlcppconn6-1.1.2-6.2.2.x86_64
>>>>>>>> libreoffice-base-drivers-mysql-4.3.3.2-4.1.x86_64
>>>>>>>> peter@linux-zayf:~> rpm -qa | grep maria
>>>>>>>> mariadb-client-10.0.13-2.3.2.x86_64
>>>>>>>> mariadb-errormessages-10.0.13-2.3.2.x86_64
>>>>>>>> mariadb-10.0.13-2.3.2.x86_64
>>>>>>>> peter@linux-zayf:~>
>>>>>>>>
>>>>>>>>
>>>>>>>>  -- Peter
>>>>>>>>
>>>>>>>> On Mon, Nov 24, 2014 at 3:36 PM, Peter Laursen <
>>>>>>>> peter_laursen@xxxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>> Thanks a lot. I will try this (tomorow probably).
>>>>>>>>>
>>>>>>>>>  -- Peter
>>>>>>>>>
>>>>>>>>> On Mon, Nov 24, 2014 at 3:26 PM, Sergei Golubchik <
>>>>>>>>> serg@xxxxxxxxxxx> wrote:
>>>>>>>>>
>>>>>>>>>> Hi, Peter!
>>>>>>>>>>
>>>>>>>>>> On Nov 24, Peter Laursen wrote:
>>>>>>>>>> > Thanks Elena. That even I can understand.
>>>>>>>>>> >
>>>>>>>>>> > But error on installation of server packet "No packet found
>>>>>>>>>> allowing for
>>>>>>>>>> > the action specified". I am simply launching YaST graphical
>>>>>>>>>> interface from
>>>>>>>>>> > the context menu of the RPM file placed on my desktop ("install
>>>>>>>>>> with packet
>>>>>>>>>> > manager"). There is a reference to some log with more details,
>>>>>>>>>> but I don't
>>>>>>>>>> > know where it can be found.
>>>>>>>>>>
>>>>>>>>>>  I've tried to repeat this - but over ssh, so I used text-mode
>>>>>>>>>> yast2.
>>>>>>>>>> Supposedly, selecting "install with packet manager" from the
>>>>>>>>>> context
>>>>>>>>>> menu is equivalent to "sudo yast2 -i /path/to/file.rpm" (I don't
>>>>>>>>>> know
>>>>>>>>>> for sure).
>>>>>>>>>>
>>>>>>>>>> Here's the issue. MariaDB-server package depends on other
>>>>>>>>>> MariaDB-*
>>>>>>>>>> packages. Normally yast or yum fetch dependencies automatically
>>>>>>>>>> from a
>>>>>>>>>> repository. But you don't install from a repository, you install a
>>>>>>>>>> specific file. In this case yast cannot fetch dependencies. You
>>>>>>>>>> have to
>>>>>>>>>> install either all packages in one command, like this:
>>>>>>>>>>
>>>>>>>>>>   sudo yast2 -i MariaDB*server.rpm MariaDB*client.rpm
>>>>>>>>>> MariaDB*common.rpm
>>>>>>>>>>
>>>>>>>>>> or you can do it with GUI and a context menu - but you need to
>>>>>>>>>> install
>>>>>>>>>> MariaDB*common.rpm first, then MariaDB*client.rpm, and only then
>>>>>>>>>> you can
>>>>>>>>>> install MariaDB*server.rpm.
>>>>>>>>>>
>>>>>>>>>> I tried both solutions - both worked.
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>> Sergei
>>>>>>>>>>
>>>>>>>>>> P.S. Now, when we build for SuSE, I hope we will provide a proper
>>>>>>>>>> package repository and yast will be able to resolve dependencies
>>>>>>>>>> automatically.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~maria-discuss
>>>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>>
>>>>
>>>
>>
>