Topic: Adding RH Software Collections version of MySQL to SME

[LANMonkey]

I have been trying to get MySQL version 5.5 or better going on my SME server.  I posted a New Feature Request for SME 9.0 alpha 3 to have the potential for upgrading to MySQL 5.5.  I got a response explaining to me that this was unecessary because Red Hat offered a solution where a second server could be installed by way of Red Hat Software Collections and there was a 5.5 version of MySQL available:

http://bugs.contribs.org/show_bug.cgi?id=7612#c1

However the documentation is pretty sparse and Red Hat is bound to be different from SME.  I tried applying clues from the instructions, but I am not seeing a successful install of the updated version.  And also I'm not sure how to apply it once I do get the installation.  But here is what I am seeing when I try to install:

Code: [Select]

[xx@xx ~]# cd /etc/yum.repos.d/
[xx@xx yum.repos.d]# wget http://people.redhat.com/~hhorak/software-collections/rhel-5-scl-mysql55.repo
--2013-05-23 10:42:39--  http://people.redhat.com/~hhorak/software-collections/rhel-5-scl-mysql55.repo
Resolving people.redhat.com... 209.132.183.19
Connecting to people.redhat.com|209.132.183.19|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 144 [text/plain]
Saving to: "rhel-5-scl-mysql55.repo"

100%[======================================>] 144         --.-K/s   in 0s

2013-05-23 10:42:39 (5.10 MB/s) - "rhel-5-scl-mysql55.repo" saved [144/144]

[xx@xx yum.repos.d]# yum install mysql55
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
 * base: mirror.itc.virginia.edu
 * smeaddons: mirror.canada.pialasse.com
 * smeextras: mirror.canada.pialasse.com
 * smeos: mirror.canada.pialasse.com
 * smeupdates: mirror.canada.pialasse.com
 * updates: mirrors.kernel.org
base                                                     | 3.7 kB     00:00
smeaddons                                                | 2.9 kB     00:00
smeextras                                                | 2.9 kB     00:00
smeos                                                    | 3.1 kB     00:00
smeupdates                                               | 2.9 kB     00:00
updates                                                  | 3.4 kB     00:00
updates/primary_db                                       | 2.4 MB     00:15
Setting up Install Process
No package mysql55 available.
Error: Nothing to do

It says "No package mysql55 available".

Does anyone have any idea how to get this thing going?  Any and all tips or clues would be appreciated.

[CharlieBrady]

It says "No package mysql55 available".

Does anyone have any idea how to get this thing going?  Any and all tips or clues would be appreciated.

The /etc/yum.repos.d files are ignored by the yum configuration used in SME server. You will need to create a database entry in the yum_repositories database, and proceed from there.

[LANMonkey]

I intend to follow the example here:

Code: [Select]

/sbin/e-smith/db yum_repositories set epel repository \
Name 'Epel - EL6' \
BaseUrl 'http://download.fedoraproject.org/pub/epel/6/$basearch' \
MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch' \
EnableGroups no \
GPGCheck yes \
GPGKey http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL \
Visible no \
status disabled
Is that right?  If so, how do I apply the information you posted at the bug towards this end?

I have from your post,

http://people.redhat.com/~hhorak/software-collections/scl-mysql55.repo

[CharlieBrady]

It makes no sense to set both BaseURL and MirrorList - BaseURL is ignored if MirrorList is specified - so you need one or the other.

I have from your post,

http://people.redhat.com/~hhorak/software-collections/scl-mysql55.repo

That's incorrect. The URL is:

http://people.redhat.com/~hhorak/software-collections/rhel-5-scl-mysql55.repo

and the content is:

[rhel-5-scl-mysql55]
name=rhel-5-scl-mysql55
baseurl=http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/
gpgcheck=0

You really should be able to work out the db settings from that.

[LANMonkey]

OK, here is what I did,

Code: [Select]

[xx@xx audittools]# /sbin/e-smith/db yum_repositories set mysql55 repository \
> Name 'rhel-5-scl-mysql55' \
> BaseUrl 'http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/$basearch' \
> GPGCheck no \
> Visible no \
> status disabled
[xx@xx audittools]# signal-event yum-modify
[xx@xx audittools]# yum --enablerepo=mysql55 install mysql55
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
Error: Cannot find a valid baseurl for repo: mysql55
[xx@xx audittools]# /sbin/e-smith/db yum_repositories set mysql55 repository \
> Name 'rhel-5-scl-mysql55' \
> BaseUrl 'http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/$basearch' \
> GPGCheck no \
> Visible no \
> status disabled
[xx@xx audittools]# signal-event yum-modify                                 
[xx@xx audittools]# yum --enablerepo=mysql55 install mysql55                 
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
Error: Cannot find a valid baseurl for repo: mysql55

"Error: Cannot find a valid baseurl for repo: mysql55"

I also tried,  "yum --enablerepo=mysql55 install rhel-5-scl-mysql55" to the same effect.

What am I missing?

[CharlieBrady]

What am I missing?

You called the repo 'rhel-5-scl-mysql55', not 'mysql55'.

[LANMonkey]

Still nothing,

Code: [Select]

[xx@xx ~]# /sbin/e-smith/db yum_repositories set mysql55 repository \
> Name 'mysql55' \
> BaseUrl 'http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/$basearch' \
> GPGCheck no \
> Visible no \
> status disabled
[xx@xx ~]# signal-event yum-modify                                           
[xx@xx ~]# yum --enablerepo=mysql55 install mysql55                         
Loaded plugins: fastestmirror, smeserver
Existing lock /var/run/yum.pid: another copy is running as pid 3414.
Another app is currently holding the yum lock; waiting for it to exit...
  The other application is: yum
    Memory :  35 M RSS ( 79 MB VSZ)
    Started: Thu May 23 14:36:31 2013 - 00:20 ago
    State  : Running, pid: 3414
Loading mirror speeds from cached hostfile
Error: Cannot find a valid baseurl for repo: mysql55
[xx@xx ~]# yum --enablerepo=mysql55 install rhel-5-scl-mysql55               
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
Error: Cannot find a valid baseurl for repo: mysql55

[Stefano]

you don't need $basearch at the end of the line IMVHO

[LANMonkey]

Nope.

Code: [Select]

[xx ~]# /sbin/e-smith/db yum_repositories set mysql55 repository \
> Name 'mysql55' \
> BaseUrl 'http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/' \
> GPGCheck no \
> Visible no \
> status disabled
[xx ~]# signal-event yum-modify                                           
[xx ~]# yum --enablerepo=mysql55 install mysql55                         
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
Error: Cannot find a valid baseurl for repo: mysql55


[LANMonkey]

I am reviewing the problem as it stands.  I am trying to install a second MySQL server using the Software Collections as advise in my New Feature Request using yum.

I am trying to set up a repository using the clues provided by the Contribs documentation here:

http://wiki.contribs.org/SME_Server:Documentation:FAQ:Section01#Adding.2C_removing_or_disabling_repositories

This is how I am setting up the repository, by cutting and pasting this code into me PuTTY terminal and running it:

Code: [Select]

/sbin/e-smith/db yum_repositories set mysql55 repository \
Name 'mysql55' \
BaseUrl 'http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/' \
GPGCheck no \
Visible no \
status disabled
The base URL provided in the post above is

http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/

You can go to this link and find files available.

When I input the above code and run "signal-event yum-modify" followed by "yum --enablerepo=mysql55 install mysql55" I get an error,

"Error: Cannot find a valid baseurl for repo: mysql55"

Why can't yum use http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/ as a valid base url?  Is there some other error?  Should "install mysql55" read something else? 

How do I install this software?

Any and all tips and or clues would be appreciated.

[Stefano]

you are using BaseUrl instead of BaseURL

tried here right now, no issues at all

HTH

[LANMonkey]

That did it.  I changed the line

BaseUrl 'http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/' \

to

BaseURL 'http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/' \

and my search returns packages.

OK, so now what do I do?  Recall again, that I am trying to install a second MySQL server using the Software Collection.

The line to install is "yum --enablerepo mysql55 install mysql55", but I get "No package mysql55 available." in response.  Which package do install?  If I do a search of mysql, I get,

Code: [Select]

[root@jay ~]# yum --enablerepo mysql55 search mysql
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
 * base: mirrors-pa.sioru.com
 * smeaddons: mirror.pialasse.com
 * smeextras: mirror.pialasse.com
 * smeos: mirror.pialasse.com
 * smeupdates: mirror.pialasse.com
 * updates: mirrors.lga7.us.voxel.net
============================== N/S Matched: mysql ==============================
MySQL-python.i686 : An interface to MySQL
apr-util-mysql.i686 : APR utility library MySQL DBD driver
bacula-director-mysql.i686 : Bacula Director with MySQL database support
bacula-storage-mysql.i686 : MySQL Bacula storage daemon files
dovecot-mysql.i686 : MySQL back end for dovecot
e-smith-mysql.noarch : e-smith specific mysql configuration and templates.
freeradius-mysql.i686 : MySQL support for freeradius
libdbi-dbd-mysql.i686 : MySQL plugin for libdbi
mod_auth_mysql.i686 : Basic authentication for the Apache web server using a
                    : MySQL database
mysql.i686 : MySQL client programs and shared libraries
mysql-bench.i686 : MySQL benchmark scripts and data
mysql-connector-java.noarch : Official JDBC driver for MySQL
mysql-connector-odbc.i686 : ODBC driver for MySQL
mysql-devel.i686 : Files for development of MySQL applications
mysql-embedded.i686 : MySQL as an embeddable library
mysql-embedded-devel.i686 : Development files for MySQL as an embeddable library
mysql-libs.i686 : The shared libraries required for MySQL clients
mysql-server.i686 : The MySQL server and related files
mysql-test.i686 : The test suite distributed with MySQL
perl-DBD-MySQL.i686 : A MySQL interface for perl
php-mysql.i686 : A module for PHP applications that use MySQL databases
qt-mysql.i686 : MySQL driver for Qt's SQL classes
qt3-MySQL.i686 : MySQL drivers for Qt 3's SQL classes
rsyslog-mysql.i686 : MySQL support for rsyslog

  Name and summary matches only, use "search all" for everything.

But none of those files match the files listed at the Base URL.  And even so, I don't know which of the packages to install from the Base URL, or which name would describe them.

So I have the repository, which package do I install and how do I do that?

[LANMonkey]

I put the $basesearch back on the end of the Base URL so that the Base URL is,

BaseURL 'http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/$basearch' \

And now when I search mysql I get a new error:

Code: [Select]

[root@jay ~]# yum --enablerepo mysql55 search mysql
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
 * base: mirrors-pa.sioru.com
 * smeaddons: smeserver.mirror.garr.it
 * smeextras: smeserver.mirror.garr.it
 * smeos: smeserver.mirror.garr.it
 * smeupdates: smeserver.mirror.garr.it
 * updates: mirror.thelinuxfix.com
http://people.redhat.com/%7Ehhorak/software-collections/mysql55-rhel-5-candidate
/i386/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL retur
ned error: 404 Not Found"
Trying other mirror.
============================== N/S Matched: mysql ==============================

.... [Files from mysql55 not listed]

'http://people.redhat.com/%7Ehhorak/software-collections/mysql55-rhel-5-candidate
/i386/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL retur
ned error: 404 Not Found"'

So it is doing something different.  The file repomd.xml exist at the Base URL and has content.

What is going on here?  What do I have to do to get my mysql55 packages?

[LANMonkey]

I am seeing something here.  The reported URL for the XML file is

http://people.redhat.com/%7Ehhorak/software-collections/mysql55-rhel-5-candidate/i386/repodata/repomd.xml

But the actual URL is

http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/repodata/repomd.xml

The '%7E' that replaces '~' is not a problem because I can wget the URL using one instead of the other.   But somehow, '/i386' is tagged on to the URL and there is no such location.

So adding $basesearch to the Base URL creates some other kind of error, but the Base URL without it does not get me my packages.

What am I doing wrong?  How do I get a list of my packages?  Is there anything else I have to do to set the repository?

[CharlieBrady]

Have you looked at:

http://people.redhat.com/~hhorak/software-collections/mysql55-rhel-5-candidate/

?

If you look there, you will see that there are only .src.rpm and .x86_64.rpm packages. Unfortunately that repository doesn't contain packages which have been built for an i686 target system.