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:6061Login
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