[GNUnet-developers] MySQL/ODBC install scripts

[Jan Marco Alkema]

Hello Igor, Christian,

Hereby the scripts to install MySQL/ODBC.

For experimental use I will serperate the source of gnunet-stats.
Try to implement ODBC -> MySQL by using the code of MyODBC-3.51.05/samples.
Every 5 minutes inserting the stats in ODBC via cron.

Also I will test a "Java Stats Interface" - > Jdbc -> MySQL.

Later port the gnunet-stats source to the windows environment.

Igor, Christian. I am not familiar with automake, autoconf, configure.in.
How can I link the "Odbc library" with every gnunet core routine?

Greetings Jan Marco

Appendix A: Install MySQL/ODBC:

For Linux download three files from Internet:
mysql-4.0.9-gamma.tar.gz
unixODBC-2.2.3.tar.gz
MyODBC-3.51.05.tar.gz

address@hidden build]# vi mysql.sh

#!/bin/sh
#

/usr/local/fsh/var/mysql/bin/mysqladmin shutdown

sleep 10

rm -Rf /usr/local/fsh/depot/mysql-4.0.9

rm -Rf /usr/local/fsh/var/mysql

cd /usr/local/fsh/depot

tar -zxvf mysql-4.0.9-gamma.tar.gz

cd /usr/local/fsh/depot/mysql-4.0.9-gamma
echo make distclean
echo rm config.cache
echo make clean
./configure --prefix=/usr/local/fsh/var/mysql
make
make install

mkdir /usr/local/fsh/var/mysql/var
chmod 777 /usr/local/fsh/var/mysql/var

chgrp -R mysql /usr/local/fsh/var/mysql
chown -R mysql /usr/local/fsh/var/mysql

/sbin/ldconfig -v|grep libmysqlclient

sleep 10

/usr/local/fsh/var/mysql/bin/mysql_install_db

chgrp -R mysql /usr/local/fsh/var/mysql
chown -R mysql /usr/local/fsh/var/mysql

if [ `grep "/usr/local/fsh/var/mysql/lib/mysql" /etc/ld.so.conf| wc -l` =
0 ] ; then
  echo "/usr/local/fsh/var/mysql/lib/mysql">>/etc/ld.so.conf
  /sbin/ldconfig
fi

rm -Rf /usr/local/unixODBC
rm -Rf /usr/local/fsh/depot/unixODBC-2.2.3
cd /usr/local/fsh/depot
tar -zxvf unixODBC-2.2.3.tar.gz
cd /usr/local/fsh/depot/unixODBC-2.2.3
./configure --prefix=/usr/local/unixODBC
make
make install

rm -Rf /usr/local/fsh/depot/MyODBC-3.51.05
cd /usr/local/fsh/depot
tar -zxvf MyODBC-3.51.05.tar.gz
cd /usr/local/fsh/depot/MyODBC-3.51.05
./configure --with-mysql-libs=/usr/local/fsh/var/mysql/lib/mysql --with-mysq
l-includes=/usr/local/fsh/var/mysql/include/mysql --with-unixODBC=/usr/local
/unixODBC
make
make install


address@hidden start]# vi mysql.sh

#!/bin/sh
#
/bin/sh -c 'cd /usr/local/fsh/var/mysql/bin ;
./mysqld_safe --user=mysql --socket=/tmp/mysql.sock &'

address@hidden samples]# pwd
/usr/local/fsh/depot/MyODBC-3.51.05/samples

address@hidden samples]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.9-gamma

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON *.* TO address@hidden
    -> IDENTIFIED BY 'venu' WITH GRANT OPTION;

Query OK, 0 rows affected (0.02 sec)

mysql>
    -> Aborted

address@hidden samples]# mysqladmin create myodbc3

address@hidden samples]# ./run-samples
***********************************************
usage: my_basics [DSN] [UID] [PWD]
***********************************************

myconnect:
 connecting to 'myodbc3' with user name 'venu'...
 success!!

my_basics:
 total rows updated:1 total rows deleted:1
 [HY000][1051:[MySQL][ODBC 3.51 Driver][mysqld-4.0.9-gamma]Unknown table
'myodbc3_demo_basic']
 success!!

mydisconnect:
 success!!
***********************************************
usage: my_connect [DSN] [UID] [PWD]
***********************************************

 allocating environment handle ...success..
 setting the environment version ...success..
 allocating the connection handle ...success..
 connecting to server using DSN 'myodbc3'...success..
 connection established successfully to server 'MySQL'

SUCCESS ...

***********************************************
usage: my_param [DSN] [UID] [PWD]
***********************************************

myconnect:
 connecting to 'myodbc3' with user name 'venu'...
 success!!

my_init_table:
 creating table 'my_demo_param'

my_param_insert:
 id      auto    name    timestamp
 -------------------------------------------
 0       1       MySQL0  2003-01-17 12:43:06
 1       2       MySQL1  2003-01-17 12:43:06
 2       3       MySQL2  2003-01-17 12:43:06
 3       4       MySQL3  2003-01-17 12:43:06
 4       5       MySQL4  2003-01-17 12:43:06
 5       6       MySQL5  2003-01-17 12:43:06
 6       7       MySQL6  2003-01-17 12:43:06
 7       8       MySQL7  2003-01-17 12:43:06
 8       9       MySQL8  2003-01-17 12:43:06
 9       10      MySQL9  2003-01-17 12:43:06

 total rows fetched:10

my_param_update:

 total rows updated:1
 id      auto    name    timestamp
 -------------------------------------------
 0       1       MySQL0  2003-01-17 12:43:06
 1       2       MySQL1  2003-01-17 12:43:06
 2       3       MySQL2  2003-01-17 12:43:06
 3       4       MySQL3  2003-01-17 12:43:06
 4       5       MySQL4  2003-01-17 12:43:06
 5       6       MySQL5  2003-01-17 12:43:06
 6       7       MySQL6  2003-01-17 12:43:06
 7       8       MySQL7  2003-01-17 12:43:06
 8       9       MySQL8  2003-01-17 12:43:06
 9       10      update  2003-01-17 12:43:06

 total rows fetched:10

my_param_delete:
 total rows deleted:1
 total rows deleted:1
 id      auto    name    timestamp
 -------------------------------------------
 0       1       MySQL0  2003-01-17 12:43:06
 1       2       MySQL1  2003-01-17 12:43:06
 2       3       MySQL2  2003-01-17 12:43:06
 3       4       MySQL3  2003-01-17 12:43:06
 4       5       MySQL4  2003-01-17 12:43:06
 6       7       MySQL6  2003-01-17 12:43:06
 7       8       MySQL7  2003-01-17 12:43:06
 9       10      update  2003-01-17 12:43:06

 total rows fetched:8

mydisconnect:
 success!!
.
.