← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB for OpenSuSE 12.3

 

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
>>
>>
>>
>>
>

Follow ups

References