mysql -u root -p my_database < dump.sqlThen raised:
ERROR 1153 (08S01) at line 75: Got a packet bigger than 'max_allowed_packet' bytesGoogling and found:
vi /etc/my.cnfadd these line under [mysqld]
[mysqld] # added to avoid err "Got a packet bigger than 'max_allowed_packet' bytes" # net_buffer_length=1000000 max_allowed_packet=1000000000 #Restart the mysql db:
service mysqld restartFinally, i import the database with successfully:
mysql -u root -p my_database < dump.sql
130306 22:02:18 mysqld_safe Number of processes running now: 0 130306 22:02:18 mysqld_safe mysqld restarted 130306 22:02:18 [Note] Plugin 'FEDERATED' is disabled. 130306 22:02:18 InnoDB: The InnoDB memory heap is disabled 130306 22:02:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130306 22:02:18 InnoDB: Compressed tables use zlib 1.2.3 130306 22:02:18 InnoDB: Using Linux native AIO 130306 22:02:18 InnoDB: Initializing buffer pool, size = 128.0M 130306 22:02:18 InnoDB: Completed initialization of buffer pool 130306 22:02:18 InnoDB: highest supported file format is Barracuda.Googling and fix the problem:
sudo service mysqld stopBackup your Database:
mkdir -p /opt/database/backup/
cp -r /var/lib/mysql/* /opt/database/backup/Adding script for recovery:
vi /etc/my.cnfthen add this line
innodb_force_recovery = 4Restart your mysql:
service mysqld restartDump all tables:
mysqldump -u root -p db_name > dump.sqlDrop all databases which need recovery:
mysql>DROP TABLE table_name;Stop MySQL:
service mysqld stop
rm -rf /var/lib/mysql/ib*Comment out recovery script:
vi /etc/my.cnf
#innodb_force_recoveryRestart your mysql:
service mysqld restartRestore your tables of database:
mysql -u root -p db_name < dump.sql
sudo service apache2 stop
sudo apt-get install nginx php5-fpm
sudo nano /etc/php5/fpm/php.inifind (CTRL + W) cgi.fix_pathinfo word and set like the below value:
cgi.fix_pathinfo=0will modify another PHP configuration
sudo nano /etc/php5/fpm/pool.d/www.conffind the "listen = ", We will modify this to use a socket for communication with the web server
listen = /var/run/php5-fpm.sockRestart the PHP-FPM
sudo service php5-fpm restart
sudo nano /etc/nginx/sites-available/myvhost.confadd this lines to configure your site, for more example script you can find at /etc/nginx/sites-available/default
server {
listen 80;
root /var/www;
index index.php index.html index.htm;
}
unlink the default configuration
sudo unlink /etc/nginx/sites-enabled/defaultStart the Nginx web server
sudo nano service nginx start
dpkg --get-selections | grep apachewill display:
apache2 install apache2-doc install apache2-mpm-prefork install apache2-threaded-dev install apache2-utils install apache2.2-bin install apache2.2-common install libapache2-mod-auth-mysql install libapache2-mod-passenger installremove
sudo apt-get remove apache2 apache2-mpm-prefork apache2-utils apache2.2-bin apache2.2-common libapache2-mod-auth-mysql libapache2-mod-php5for the clear remove dependencies run this command
sudo apt-get autoremove
sudo apt-get install nodejs
sudo apt-get update
sudo apt-get upgradeafter done, you need to restart the server for clean.
sudo shutdown -r now
sudo apt-get install mysql-server mysql-client libapache2-mod-auth-mysql php5-mysqlNeed, install the PHP for using phpmyadmin
sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt
sudo apt-get install build-essential openssl libreadline6 libreadline6-dev curl git-core zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bison subversion libpq-dev
sudo apt-get install curl
\curl -L https://get.rvm.io | bash -s stable --ruby
source ~/.rvm/scripts/rvmAfter installed RVM, close your terminal and login back to use the "rvm" command: RVM has some dependencies to need install, run this command.
rvm requirementsand if any install some recommended dependencies
rvm list knownWill display like this:
# MRI Rubies [ruby-]1.8.6[-p420] [ruby-]1.8.7[-head] # security released on head [ruby-]1.9.1[-p431] [ruby-]1.9.2[-p330] [ruby-]1.9.3[-p547] [ruby-]2.0.0-p481 [ruby-]2.0.0[-p576] [ruby-]2.1.2 [ruby-]2.1[.3] [ruby-]2.1-head ruby-head
rvm install 2.1.2
rvm use 2.1.2 --defaultcheck the version installed Ruby and Gem
ruby -v gem -v
gem install rails
sudo apt-get install libmysqlclient-dev
gem install mysql2
sudo apt-get install imagemagick
sudo apt-get install nodejs
gem install passengerView script apache installation run this script:
passenger-install-apache2-module
touch /Users/arul/holidays_2014.txt
nano /Users/arul/holidays_2014.txt
2014-01-01 2014-01-14 2014-01-30 2014-03-31 2014-04-18
touch /Users/arul/runner.sh
nano /Users/arul/runner.sh
TODAY=$(date "+%Y-%m-%d") if grep -q "$TODAY" /Users/arul/holiday.txt; then /usr/bin/php /Users/arul/test.php else echo "Not found the date" exit 0 fi
crontab -eExample the crontab will run every two hours start from Monday through Friday
0 */2 * * mon-fri sh /Users/arul/runner.sh
svn: warning: cannot set LC_CTYPE locale svn: warning: environment variable LC_CTYPE is UTF-8 svn: warning: please check that your locale name is correct
locale -a
export LC_ALL=C
sudo yum install subversion mod_dav_svnCreate the directory svn
mkdir /var/www/svn
svnadmin create myrepo
chown -R apache.apache myrepoEdit subversion configuration file
vi /etc/httpd/conf.d/subversion.confAdd these line
LoadModule dav_svn_module modules/mod_dav_svn.so LoadModule authz_svn_module modules/mod_authz_svn.so < Location /svn > DAV svn SVNPath /var/www/svn AuthType Basic AuthName "Subversion repositories" AuthUserFile /etc/svn-auth-users Require valid-user < /Location >Adding new user
sudo htpasswd -cm /etc/svn-auth-users username
New password: Re-type new password: Adding password for user new_userRestart your server
sudo service httpd restartFinally, access your svn url:
sudo yum install nodejs npm
sudo yum install mysql-devel
gem install mysql2
sudo yum remove ruby
ruby -v
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 7778 -j ACCEPT
sudo setenforce 0
mkdir /home/kloxo cd /home/kloxo
wget http://download.lxcenter.org/download/kloxo/production/kloxo-installer.sh
sh ./kloxo-installer.sh --type=master
sudo yum update
sudo yum install curl
curl -L get.rvm.io | bash -s stableAfter installed RVM, close your terminal and login back to use the "rvm" command:
rvm requirementsand install some recommended dependencies:
rvmsudo yum install -y gcc-c++ patch readline readline-devel zlib zlib-devel libyaml-devel libffi-devel openssl-devel make bzip2 autoconf automake libtool bison iconv-devel
rvm list knownWill display like this:
# MRI Rubies [ruby-]1.8.6[-p420] [ruby-]1.8.7[-p374] [ruby-]1.9.1[-p431] [ruby-]1.9.2[-p320] [ruby-]1.9.3[-p545] [ruby-]2.0.0-p353 [ruby-]2.0.0[-p451] [ruby-]2.1.1 [ruby-]2.1-head ruby-headInstall the Ruby
rvm install 2.1.1
rvm use 2.1.1 --defaultcheck the version installed Ruby and Gem
ruby -v gem -v
gem install rails
sudo yum install mysql-devel
gem install mysql2
gem install passenger
yum install curl-devel httpd-devel
passenger-install-apache2-modulePut these lines to end of file in httpd.conf, edit the file at /etc/httpd/conf/httpd.conf
LoadModule passenger_module /usr/local/rvm/gems/ruby-2.1.1/gems/passenger-4.0.37/buildout/apache2/mod_passenger.so
< IfModule mod_passenger.c >
PassengerRoot /usr/local/rvm/gems/ruby-2.1.1/gems/passenger-4.0.37
PassengerDefaultRuby /usr/local/rvm/gems/ruby-2.1.1/wrappers/ruby
< /IfModule >
Adding new virtual host:vi /etc/httpd/conf.d/your_vhost_name.confAdd these line, set up your public app directory:
< VirtualHost *:80 >
ServerName www.yourhost.com
# !!! Be sure to point DocumentRoot to 'public'!
DocumentRoot /somewhere/public
< Directory /somewhere/public >
# This relaxes Apache security settings.
AllowOverride all
# MultiViews must be turned off.
Options -MultiViews
< /Directory >
< /VirtualHost >
Restart your apache
service httpd restart
sudo yum update
sudo yum install httpd
sudo service httpd start
sudo yum install mysql-server
sudo service mysqld startYou can set a root MySQL password with these command:
sudo /usr/bin/mysql_secure_installation
sudo yum install php php-mysql
yum search php-Then terminal will show list of modules:
php53-process.i386 : Modules for PHP script using system process interfaces php53-pspell.i386 : A module for PHP applications for using pspell interfaces php53-snmp.i386 : A module for PHP applications that query SNMP-managed devices php53-soap.i386 : A module for PHP applications that use the SOAP protocol php53-xml.i386 : A module for PHP applications which use XML php53-xmlrpc.i386 : A module for PHP applications which use the XML-RPC protocolTo see more detail:
yum info name_of_moduleTo install the module:
yum install name_of_moduleFinally, restart your apache to see the effect for the changed:
sudo service httpd restart
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that a host key has just been changed. The fingerprint for the RSA key sent by the remote host is 80:54:8b:9b:39:fb:f1:23:af:0f:4d:af:eb:24:70:44. Please contact your system administrator. Add correct host key in /Users/arul/.ssh/known_hosts to get rid of this message. Offending RSA key in /Users/arul/.ssh/known_hosts:1 RSA host key for 192.168.10.50 has changed and you have requested strict checking. Host key verification failed.That messages show up, because RSA host key had change
vi ~/.ssh/known_hostsDone, now i can remote with SSH
apt-get remove webminOther way to uninstall webmin
/etc/webmin/uninstall.sh .
sudo vi /etc/apt/sources.list
deb http://download.webmin.com/download/repository sarge contrib deb http://webmin.mirror.somersettechsolutions.co.uk/repository sarge contribNow you need to download GPG key
wget http://www.webmin.com/jcameron-key.asc sudo apt-key add jcameron-key.asc
sudo apt-get update
sudo apt-get install webmin
ssh root@100.100.100.100 #VPS IP Address
password: {your_password}
adduser your_username
password {enter_the_password_user}
sudo apat-get update
sudo apat-get install nano
sudo apat-get install curlThen, install the RVM
\curl -L https://get.rvm.io | bash -s stableAfter installing is done, load the RVM. You may first need to exit out out your shell session (terminal) and start up a new one
source ~/.rvm/scripts/rvm
rvm requirements
sudo apt-get install build-essential openssl libreadline6 libreadline6-dev zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bisonNow we can list all the availabel versions of Ruby that are available:
rvm list knownWill show list all Ruby version like this:
# MRI Rubies [ruby-]1.8.6[-p420] [ruby-]1.8.7[-p374] [ruby-]1.9.1[-p431] [ruby-]1.9.2[-p320] [ruby-]1.9.3[-p484] [ruby-]2.0.0-p195 [ruby-]2.0.0[-p353] [ruby-]2.1.0 [ruby-]2.1.0-head ruby-headSelect newest Ruby version and install with rvm:
rvm install 2.1.0
rvm --default use 2.1.0Finally, you need to check installed the Ruby on your computer
ruby -v gem -v
sudo gem install railsCheck rails version
raisl -v