[Maria-discuss] MariaDB for OpenSuSE 12.3
I have OpenSuSE 12.3. It ships with MariaDB 1.0.13 - and with no TokuDB and no Galera options. I would like to upgrade to 10.0.14 and also enable TokuDB. And it does not seem that an upgrade will be available from SuSE software repositories. There are a lot of RPMs in the yum repository http://mirror.23media.de/mariadb/mariadb-10.0.14/yum/. But does anyone know if they will work with SuSE 12.3? Runtime environment (kernel, glibc etc.) should be compatible of course, and also RPMs for Redhat/Fedora/CentOS systems will not alwyas work on SuSE, as SuSE has some specific requirements for the SPECS. When I used SuSE 10.x many years ago, the generic "glibc23" RPMs available worked perfectly. Note: I *only* want to install a server that can be handled by SuSE's YaST package manager! So suggestons for any other solution (such as using the tarball) is not an option. Or it would be last resort. I would not mind give it a try if someone can advise what I should try. I have SuSE running in a VM and I will be able to return to a snapshot of the system easily if something goes wrong. -- Peter
BTW: the CONNECT engine is also not available. It really looks like the SuSE developers *configure* (with .. with ..with ..) using old ptions that are not updated for MariaDB 10..Maybe someone at MariaDB could contact SuSe about it? It could be a simple mistake. It also does not have FederatedX (but Federated is available as a plugin - and same for Archive and Blackhole engines). -- Peter On Sun, Nov 23, 2014 at 12:51 PM, Peter Laursen <peter_laursen@webyog.com> wrote:
I also may do. But my primary question was if somebody knows if any of the RPMs in MariaDB yum repositories would work in SuSE 13.2 and can be fully managed by YaST. In that case I will not rely on updates from SuSE but install from MariaDB. I have noticed that Linux distributors' are often very conservative with MySQL upgrades once a distro has been released as GA. Besides @Harald .. I thinik it was only 2 days ago that you told that you would ignore my mails to the the MariaDB mailing lists for all future as I am not "worth spending time with". I would appreciate if you kept that promise! In other words: please PISS OFF. My nerves cannot tolerate you as a person. You are the most annoying person I ever encountered! -- Peter. On Sun, Nov 23, 2014 at 8:47 PM, Reindl Harald <h.reindl@thelounge.net> wrote:
Am 23.11.2014 um 21:02 schrieb Peter Laursen:
who do you think you are? if you have personal problems just go somewhere else i don't and discuss on a *technical level* and *mo* i have not the time nor am i instersted to maintain a list of jerks to ignore - if i have an answer in the right direction i give an answer (even to people acting like a pure asshole)
Hi, Peter! We've recently started building on SuSE: http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse13_1-x86_64 http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse13_1-x86 This is a new builder and we haven't made any releases of these binaries yet, as far as I remember. Still the source code is the same, so it is as stable as any other 10.0 build. But the packaging - like dependencies or conflicts - might be not completely polished yet. So, if you'd like, you can try our suse rpms that were built on opensuse, as above. On Nov 23, Peter Laursen wrote:
Regards, Sergei
I am sorry, but I really do not understand at all how to get acces to RPMs (or anything) from the page linked to ( http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse13_1-x86_64 ). -- Peter On Sun, Nov 23, 2014 at 9:50 PM, Sergei Golubchik <serg@mariadb.org> wrote:
Hi Peter, http://hasky.askmonty.org/archive/pack/10.0/build-6865/kvm-zyp-opensuse13_1-... Regards, Elena On 24.11.2014 15:17, 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. -- Peter
Hi, Peter! On Nov 24, Peter Laursen wrote:
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.
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@webyog.com> 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@webyog.com> 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@webyog.com> 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@webyog.com> wrote:
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@webyog.com> 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-t... -- Peter On Tue, Nov 25, 2014 at 2:10 PM, Peter Laursen <peter_laursen@webyog.com> wrote:
participants (5)
-
Elena Stepanova -
jocelyn fournier -
Peter Laursen -
Reindl Harald -
Sergei Golubchik