I know not everyone wanna work with the same OS so i did try some that on that the files are working ( im think they work on all linux systems )
I not gona explain the firewall rules since this would get to big and for every OS are enought tuts for this on the i-net
all will be explained how to do it over Putty/WinSCP
DONT POSTER HERE OVER PERMISSION DENIED!! it will get ignored and direcktly removed
[Only registered and activated users can see links. Click Here To Register...]
1. Fedora 15/16/17/18
(fresh installed)
login with the terminal as user root and use this command's :
Update the server:
yum update
Installs all packets we need mysql php mono:
yum install -y mysql mysql-server mysql-devel mysql-libs php-mysql httpd php gcc-c++ libstdc++.so.6 libz.so.1 libstdc++-libc6.2-2.so.3 libgssapi_krb5.so.2 screen lm_sensors lm_sensors-devel gtk+ php-devel
yum groupinstall -y 'MySQL Database' 'Web Server' 'Development Tools' 'Development Libraries'
after all this is done add the [b]libraries that i give for download to the path /usr/lib:
[Only registered and activated users can see links. Click Here To Register...]
adding Apache and mysql at startup
chkconfig --add httpd
chkconfig httpd on
chkconfig --add mysqld
chkconfig mysqld on
starting Services we need:
service httpd start
service mysqld start
if you wanna use iptables:
systemctl disable firewalld.service
systemctl stop firewalld.service
systemctl enable iptables.service
systemctl enable ip6tables.service
systemctl start iptables.service
systemctl start ip6tables.service
Read down to see mysql settings
2. Debian 6.0
(fresh installed)
login with the terminal as user root and use this command's :
Update the server
apt-get update
Installs all packets we need mysql php mono
apt-get install mono-complete
apt-get install mono-devel
apt-get install mysql-server mysql-client
apt-get install php5-mysql
apt-get install lib32z1
after all this is done add the libraries that i give for download to the path /usr/lib32
[Only registered and activated users can see links. Click Here To Register...] Download Libs
3. CentOS is close the same as fedora... only for install mono look at my tut
$MySQL
set up the mysql accounts
login with the terminal as user root and use this command's :
mysql -u root -p
this will ask you for password if u not have set a password just hit enter
Generate an mysql User
GRANT ALL ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword'
example create user HateMe with password SuperMob
GRANT ALL ON *.* TO 'HateMe'@'%' IDENTIFIED BY 'SuperMob';
example create user LCSERVER with password MYSERVERROCKS only from ip 127.0.0.1 only
GRANT ALL ON *.* TO 'LCSERVER'@'127.0.0.1' IDENTIFIED BY 'MYSERVERROCKS'
to use the account LCSERVER for the files we need now to change the password to old_password
UPDATE mysql.user SET password=OLD_PASSWORD('MYSERVERROCKS') WHERE user='LCSERVER';
to make all this effects works waht we have done we need type
flush privileges;
now we can leave the mysql line with
quit
ok now another thing we all know its annoying upload over Navicat or HeidiSQL the databases bc they so big here i explain how you can do it faster and easy
open navicat
and create ur databases as example data, char, auth, post
now zip all your sql files as example newproject_data.sql, newproject_db.sql, newproject_auth.sql, newproject_post.sql
in this example i name the ZIPFILE, db.zip
upload it with WinSCP to ur home directory /home/
now login with the terminal as user root and use this command's :
cd
cd ..
now you should see something like this [root@localhost /]# go into home
cd home
.... [root@localhost home]
now unzip the db.zip that we have created
unzip db.zip
after unziping is done waht should have taken only few seconds we gona import them
mysql -u root -p DATA-BASE-NAME < data.sql
mysql -u root -p data < data.sql
mysql -u root -p char < char.sql
mysql -u root -p auth < auth.sql
mysql -u root -p post < post.sql
mysql -u root -p ep2web < ep2site.sql
