Eye-Fi Server Setup

CentOS

Apache httpd

$ chkconfig httpd on
$ chkconfig —list httpd

MySQL

$ yum install mysql-server

$ cat /etc/my.cnf 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

$ service mysqld start

$ which mysql
/usr/bin/mysql

$ mysql -u root -p
mysql> USE mysql;
mysql> SHOW TABLES;
mysql> UPDATE user SET Password=PASSWORD('wanagi123') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> CREATE DATABASE `dev_eye_fi`;
mysql> CREATE USER 'dev'@'localhost' IDENTIFIED BY PASSWORD('unagi123');
mysql> GRANT ALL ON `dev_eye_fi`.* TO 'dev'@'localhost';
mysql> SHOW DATABASES;
mysql> SELECT User,Host FROM mysql.user;
mysql> SHOW GRANTS FOR dev@localhost;
mysql> 
mysql> exit

SELECT * FROM mysql.user WHERE User='dev';

$ mysqldump -u root -p --order-by-primary --tz-utc --databases dev_eye_fi > backup/mysql/dev_eye_fi.sql
Enter password: wanagi123
$ mysqldump -u root -p --tz-utc --no-data --databases dev_eye_fi > conf/mysql/dev_eye_fi.sql
Enter password: wanagi123

mysql -u root -p < dev_eye_fi.sql

define('DOMAIN_CURRENT_SITE', 'dev-staging.eye.fi' );
define('PATH_CURRENT_SITE', '/' );
define('BLOGID_CURRENT_SITE', '1' );
define('NOBLOGREDIRECT', 'http://dev-staging.eye.fi');

$ chkconfig mysqld on
$ chkconfig --list mysqld

GammaBot

$ ssh -A flexo.eye.fi
$ ssh gammabot
$ mysql -p
mysql> USE mysql;
mysql> SHOW TABLES;
mysql> SET PASSWORD FOR 'runeimp'@'localhost' = PASSWORD('NewPass');