Koozali.org: home of the SME Server
Contribs.org Forums => General Discussion => Topic started by: countzero on February 12, 2010, 11:58:58 AM
-
Download software here:
http://www.storegrid.net/products/storegrid/sp/200909300/VembuStoreGrid_3_0_SP_RH.zip
- create ibay
- create user
- yum install unixODBC
- yum install compat-libstdc++-33
- unzip *.zip
- wget http://dev.mysql.com/get/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-0.i386.rpm/from/http://mysql.mirrors.ilisys.com.au/
- rpm -Uvh *.rpm
- run installer script
- odbcinst -j
unixODBC 2.2.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini
Append the following to DRIVERS file:
[ODBC]
Trace = No
Trace File = /tmp/sql.log
Pooling = Yes
[MySQL]
Description =
Driver = /usr/local/lib/libmyodbc3-3.51.27.so
Driver64 =
Setup = /usr/local/lib/libmyodbc3S-3.51.27.so
Setup64 =
UsageCount =1
CPTimeout =300
CPReuse =1
Threading =0
[root@server /]# find . -name libmyodbc*.so
./usr/lib/libmyodbc3-3.51.27.so
If your library files live somewhere else, update above file paths.
Append the following to the SYSTEM DATA SOURCES file:
[storegrid]
Driver = MySQL
DATABASE = storegrid
PWD = #####
SERVER = localhost
UID = storegrid
SOCKET = /var/lib/mysql/mysql.sock
Create MySQL database and user 'storegrid'
Start Storegrid and go to http://yourserverhere:6061
Login
ERROR: You have specified an invalid Data Source name '#####' for the user 'root' to connect the Database '#####'. Please correct this, restart StoreGrid and then try logging in again. Make sure that the value of the DSName attribute specified in the [StoreGrid_Home]/conf/SGConfiguration.conf file matches the Data Source name available in this system.
ln -s /etc/odbcinst.ini /usr/local/etc/odbcinst.ini
ln -s /etc/odbc.ini /usr/local/etc/odbc.ini
Stop Storegrid
Start Storegrid
Test ODBC connection to the database:
isql -v storegrid storegrid ##### (where ##### is the password)
You should be able to connect to the database.
However, if you go to https://yourserverhere:6061 it might say:
"Lost connection to MySQL server at 'reading initial communication packet', system error: 111"
Cause: Wrong version of MySQL installed on the server.
If you can't get MySQL to version 5.1.39:
$SGRIDHOME/conf/SGConfiguration.php
...
Database UseODBC="0" .....
...
This will get you going, but it isn't pretty.
Note that MySQL 5.1 is strongly recommended.
SME Server 8 uses RedHat CentOS5. CentOS5 comes with MySQL 5.0 (5.0.77).
You can try "yum upgrade mysql mysql-server" but it won't upgrade to MySQL 5.1.
CentOS 5 has not included MySQL 5.1 out of stability concerns I can imagine.
With MySQL 5.0 certain links on the Storegrid web page won't work.
To update to MySQL 5.1 (at your own risk)
===========================
Make sure to use SME Server 8 (I used 8.0beta4)
Download CentOS MySQL 5.1.39 server + client from here:
http://www.storegrid.com/online-backup/sp-help/mysql-setup-linux.html
/etc/rc.d/init.d/mysqld stop
rpm -e mysql --nodeps
rpm -e mysql-server --nodeps
Unzip the downloaded file and run the installation script, or install manually:
rpm -Uvh MySQL-server-5.1.39-0.glibc23.i386.rpm
rpm -Uvh MySQL-client-5.1.39-0.glibc23.i386.rpm
signal-event post-upgrade
signal-event reboot
Suppose we want to allow incoming connections on port 32004
man iptables
Quick test:
Shutdown the entire firewall on the SME server:
service masq stop
Test port:
telnet yourserverhere 32004
Start the firewall on the SME server:
service masq start
Create pin hole in firewall:
mkdir -p /etc/e-smith/templates-custom/etc/rc.d/init.d/masq/
cd /etc/e-smith/templates-custom/etc/rc.d/init.d/masq/
vi 15AllowStoreGrid
Add the line:
/sbin/iptables -A INPUT -p tcp -m tcp --dport 32004 -j ACCEPT
(Make sure there is an empty line at the top and bottom)
/sbin/e-smith/expand-template /etc/rc.d/init.d/masq
/etc/init.d/masq restart
Check:
iptables -L | grep 32004
ACCEPT tcp -- anywhere anywhere tcp dpt:32004
-
- wget http://dev.mysql.com/get/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-0.i386.rpm
- rpm -Uvh *.rpm
you should always install rpms with yum.. in this case, yum localinstall....
Cause: Wrong version of MySQL installed on the server.
....
Note that MySQL 5.1 is strongly recommended.
SME Server 8 uses RedHat CentOS5. CentOS5 comes with MySQL 5.0 (5.0.77).
You can try "yum upgrade mysql mysql-server" but it won't upgrade to MySQL 5.1.
...
To update to MySQL 5.1 (at your own risk)
===========================
Make sure to use SME Server 8 (I used 8.0beta4)
Download CentOS MySQL 5.1.39 server + client from here:
http://www.storegrid.com/online-backup/sp-help/mysql-setup-linux.html
/etc/rc.d/init.d/mysqld stop
rpm -e mysql --nodeps
rpm -e mysql-server --nodeps
Unzip the downloaded file and run the installation script, or install manually:
rpm -Uvh MySQL-server-5.1.39-0.glibc23.i386.rpm
rpm -Uvh MySQL-client-5.1.39-0.glibc23.i386.rpm
signal-event post-upgrade
signal-event reboot
this is not necessary AFAIK: you can always enable ceontosplus repo and upgrade mysql.. or, as an alternative, you can find a repo with centos5 rpms for mysql
Suppose we want to allow incoming connections on port 32004
man iptables
Quick test:
Shutdown the entire firewall on the SME server:
service masq stop
Test port:
telnet yourserverhere 32004
Start the firewall on the SME server:
service masq start
Create pin hole in firewall:
mkdir -p /etc/e-smith/templates-custom/etc/rc.d/init.d/masq/
cd /etc/e-smith/templates-custom/etc/rc.d/init.d/masq/
vi 15AllowStoreGrid
Add the line:
/sbin/iptables -A INPUT -p tcp -m tcp --dport 32004 -j ACCEPT
(Make sure there is an empty line at the top and bottom)
/sbin/e-smith/expand-template /etc/rc.d/init.d/masq
/etc/init.d/masq restart
Check:
iptables -L | grep 32004
ACCEPT tcp -- anywhere anywhere tcp dpt:32004
this is not necessary..
config set storegrid service status enabled TCPPort 32004
signal-event remoteaccess-update
should do the job
-
[deleted]
-
countzero:
yum --enablerepo=centosplus update mysql php --exclude perl*
should do the job
NOTE: the "--exclude perl*" is IMPORTANT because without it you would upgrade perl and so break your server
HTH
-
http://mirror.centos.org/centos/5/centosplus/i386/RPMS/
There is no mysql / php in centosplus repository.
I like "rpm -ev" as it has "--nodeps". It's like swatting a fly with a bazooka. yum doesn't have "--nodeps".
Hence, I also use "rpm -Uvh" a bit. "yum localinstall" might be better, but yum is often resisting cooperation (which is a good thing, given my yum/rpm skills)
I did eventually get MYSQL and all dependencies (like php-mysql) upgraded to 5.1 as follows:
http://www.r0xarena.com/blog/installing-mysql-5134-from-source-in-centos-53/
My experiences are 100% based on this excellent tutorial
wget http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm
rpm -Uvh epel-release-5-3.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
rpm -Uvh remi-release-5.rpmcd
cd /etc/yum.repos.d/
mv epel.repo ../yum.smerepos.d/
mv epel-testing.repo ../yum.smerepos.d/
mv remi.repo ../yum.smerepos.d/
vi /etc/yum.smerepos.d/remi.repo
enabled=1
service mysqld stop
/etc/rc.d/init.d/httpd stop
rpm -ev mysql --nodeps
rpm -ev mysql-server --nodeps
yum update php
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
php-common i386 5.3.1-1.el5.remi remi 945 k
replacing php-pecl-Fileinfo.i386 1.0.4-3.el5.centos
Updating:
php i386 5.3.1-1.el5.remi remi 1.3 M
php-cli i386 5.3.1-1.el5.remi remi 2.5 M
php-gd i386 5.3.1-1.el5.remi remi 202 k
php-imap i386 5.3.1-1.el5.remi remi 79 k
php-ldap i386 5.3.1-1.el5.remi remi 50 k
php-mbstring i386 5.3.1-1.el5.remi remi 2.1 M
php-mysql i386 5.3.1-1.el5.remi remi 140 k
php-pdo i386 5.3.1-1.el5.remi remi 162 k
php-xml i386 5.3.1-1.el5.remi remi 203 k
Installing for dependencies:
libXaw i386 1.0.2-8.1 base 324 k
libXmu i386 1.0.2-5 base 62 k
libXpm i386 3.5.5-3 base 45 k
libXt i386 1.0.2-3.1.fc6 base 175 k
libedit i386 2.11-2.20080712cvs.el5 epel 79 k
mysql-libs i386 5.1.43-1.el5.remi remi 2.1 M
sqlite2 i386 2.8.17-2.el5.remi remi 170 k
t1lib i386 5.1.1-7.el5 epel 194 k
Transaction Summary
================================================================================
Install 9 Package(s)
Update 9 Package(s)
Remove 0 Package(s)
Total download size: 11 M
Is this ok [y/N]: y
php -v
PHP 5.3.1 (cli) (built: Nov 20 2009 17:51:14)
yum install mysql-server
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-server i386 5.1.43-1.el5.remi remi 8.5 M
Installing for dependencies:
mysql i386 5.1.43-1.el5.remi remi 3.5 M
Transaction Summary
================================================================================
Install 2 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 12 M
Is this ok [y/N]: y
service mysqld restart
/etc/rc.d/init.d/httpd restart
vi /etc/yum.smerepos.d/remi.repo
enabled=0
Oh, before I forget, for SME server, after rpm/yum changes always run when done:
signal-event post-upgrade
signal-event reboot
=====
Thank you for your time and efforts!
-
Aargh...never mind...still not working properly....
-
Countzero,
Would you elaborate on this storegrid product? Is this to turn an SME server into something comparable to workstation backup such as carbonite where laptops can backup files to a central server? Or is this a product that will backup an SME server to a central backup datavault?
-
Yes, like Carbonite. Except that YOU are the online backup provider. It can be used to provide online backup services for clients. It has nothing to do with backing up an SME server.
Vembu Storegrid is a "backup over the internet (online backup) solution". It requires monthly licenses (1 for your server and 1 for each of the clients you backup). You can import data from a USB drive so that the initial data set is transferred across without taking excessive bandwidth. So as long as the daily changes (dynamic data) are less then a few 100 mbytes, you can sync/backup these changes over the net...online backup.
As I like SME server, I thought to have it configured to run the "Vembu Storegrid" product.
-
hi
Did you ever get this to work?
BR Frederik