maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

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