Re: [cobalt-users] SSH & MySQL on RaQ4 common questions!

[Daniel Neuhaus <dnidneuhaus@xxxxxxxx>]

Hi!

> MySQL:
> I think I have found the 'definitive' installation procedure:
> http://www.raqresources.com/mysql.htm
> Can one follow this and do it?  We have an in use RaQ4 and cannot be taking too many risks.

I tried this on two RaQ4 today without any problem. It uses
the last MySQL 3.23.35 from

# MYSQL

cd /home/packages
wget http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.35.tar.gz
echo "mysql:x:101:103:MySql User:/usr/local/mysql:">>/etc/passwd
echo "mysql:x:103:">>/etc/group
tar zxvf mysql-3.23.35.tar.gz
cd mysql-3.23.35
./configure --prefix=/usr/local/mysql --with-unix-socket-path=/tmp/mysql.sock --with-mysqld-user=mysql
make
make install
chown mysql.mysql /usr/local/mysql
scripts/mysql_install_db
chown -R mysql.mysql /usr/local/mysql/var
mkdir /var/lib/mysql
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
rm -f /usr/bin/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
chmod 755 /usr/local/mysql/var
/usr/local/mysql/bin/safe_mysqld &
/usr/local/mysql/bin/mysqladmin -u root password 'yourpasswordhere'
cp support-files/mysql.server /etc/rc.d/init.d/mysql
chmod 755 /etc/rc.d/init.d/mysql
echo "/etc/rc.d/init.d/mysql start">>/etc/rc.d/rc.sysinit

# If you want to have Perl-DBI
# DBI-Modul für Perl

cd /home/packages
wget http://www.mysql.com/Downloads/Contrib/DBI-1.14.tar.gz
wget http://www.mysql.com/Downloads/Contrib/Msql-Mysql-modules-1.2215.tar.gz
tar zxvf DBI-1.14.tar.gz
tar zxvf Msql-Mysql-modules-1.2215.tar.gz
cd /home/packages/DBI-1.14
perl Makefile.PL
make
make test
make install
cd /home/packages/Msql-Mysql-modules-1.2215
perl Makefile.PL                              # [1]/[n]/.../[root]
make
make test
make install

# löschen...

cd /home/packages
rm -rf DBI-1.14
rm -rf Msql-Mysql-modules-1.2215
rm -rf mysql-3.23.35
rm mysql-3.23.35.tar.gz
rm Msql-Mysql-modules-1.2215.tar.gz
rm DBI-1.14.tar.gz

# If you want to use PHPMyAdmin Advanced Auth use this to create a
# user "zugang" with password "zugang"

# Benutzer für PHPMyAdmin Advanced Auth

mysql -u root -yourpasswordhere
use mysql;
INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost', 'mysql', 'zugang', 'Y');
INSERT INTO user (Host, User, Password) VALUES ('localhost','zugang',password('zugang'));
flush privileges;
exit;


> SSH:
> SSH.com or OpenSSH - what is the way to install either?  Have found nothing definite.
> While I have SSL for Apache for one of my sites, I think I still need to install a different SSL package.
> Are there .pkg fiels for this that work?

Look at http://pkg.nl.cobalt.com for a SSH-Package.

Regards,
Daniel