Koozali.org: home of the SME Server
Obsolete Releases => SME Server 8.x => Topic started by: LANMonkey on May 23, 2013, 07:58:51 PM
-
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:
[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.
-
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.
-
I intend to follow the example here:
/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
-
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.
-
OK, here is what I did,
[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?
-
What am I missing?
You called the repo 'rhel-5-scl-mysql55', not 'mysql55'.
-
Still nothing,
[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
-
you don't need $basearch at the end of the line IMVHO
-
Nope.
[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
-
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:
/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.
-
you are using BaseUrl instead of BaseURL
tried here right now, no issues at all
HTH
-
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,
[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?
-
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:
[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?
-
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?
-
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.
-
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.
Yes, I had looked at that, but I missed that there was nothing there except for 64 bit systems. I was too wrapped up in trying to get the repository working.
So, my hopes for running a second instance of a different version of mysql on SME has no solution? The repository offered by Software Collections has nothing for me if I don't have a 64 bit system?