Koozali.org: home of the SME Server

Vembu Storegrid 3.1 on SME Server 8.0beta4 (use at your own risk)

Offline countzero

  • *
  • 31
  • +0/-0
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
« Last Edit: February 18, 2010, 02:11:49 AM by countzero »

Online Stefano

  • *
  • 10,894
  • +3/-0
Re: Vembu Storegrid 3.1 on SME Server 8.0beta4 (use at your own risk)
« Reply #1 on: February 12, 2010, 01:17:08 PM »
- 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....

Quote
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

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

Code: [Select]
config set storegrid service status enabled TCPPort 32004
signal-event remoteaccess-update

should do the job

Offline countzero

  • *
  • 31
  • +0/-0
MySQL 5.0 -> 5.1 woes
« Reply #2 on: February 17, 2010, 03:01:16 PM »
[deleted]
« Last Edit: February 18, 2010, 02:01:29 AM by countzero »

Online Stefano

  • *
  • 10,894
  • +3/-0
Re: Vembu Storegrid 3.1 on SME Server 8.0beta4 (use at your own risk)
« Reply #3 on: February 17, 2010, 03:22:44 PM »
countzero:

Code: [Select]
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

Offline countzero

  • *
  • 31
  • +0/-0
MySQL 5.1.43 + PHP 5.3.1 on SME server 8.0beta4
« Reply #4 on: February 18, 2010, 01:17:05 AM »
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!
« Last Edit: February 18, 2010, 02:14:21 AM by countzero »

Offline countzero

  • *
  • 31
  • +0/-0
Re: Vembu Storegrid 3.1 on SME Server 8.0beta4 (use at your own risk)
« Reply #5 on: February 20, 2010, 11:17:18 AM »
Aargh...never mind...still not working properly....
« Last Edit: February 23, 2010, 03:47:54 PM by countzero »

Offline daniel

  • ****
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
Re: Vembu Storegrid 3.1 on SME Server 8.0beta4 (use at your own risk)
« Reply #6 on: February 24, 2010, 07:26:32 PM »
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?

Offline countzero

  • *
  • 31
  • +0/-0
Re: Vembu Storegrid 3.1 on SME Server 8.0beta4 (use at your own risk)
« Reply #7 on: June 30, 2010, 02:38:12 PM »
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.
« Last Edit: June 30, 2010, 02:41:35 PM by countzero »

Offline frederikbay

  • ***
  • 41
  • +0/-0
Re: Vembu Storegrid 3.1 on SME Server 8.0beta4 (use at your own risk)
« Reply #8 on: September 05, 2010, 10:15:21 PM »
hi

Did you ever get this to work?

BR Frederik