Author: gustavflober_ngbdku62

Apache, Mysql, PHP, Vernish, Webmin on Debian-Ubuntu

Most of all servers come with installed apache,php and mysql but but without vernish and webmin we need to install this soft manually on Debian or ubuntu.

We will start to upgrade out system:

apt-get update
apt-get dist-upgrade

Now if apache is not installed we should install it:

apt-get install apache2

install mysql server:

apt-get install mysql-server

install PHP:

apt-get install php5 php-pear php5-mysql php5-common php5-mcrypt php5-curl php5-cli php5-gd php5-dev

install curl(is needed for vernish) and unzip(if not installed):

apt-get install curl unzip

Now we must install dependencies for webmin control panel:

apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions python

Wget webmin and install it:

wget http://prdownloads.sourceforge.net/webadmin/webmin_1.660_all.deb
dpkg –install webmin_1.660_all.deb

at least install vernish:

curl http://repo.varnish-cache.org/debian/GPG-key.txt | apt-key add –
echo “deb http://repo.varnish-cache.org/debian/ wheezy varnish-3.0” >> /etc/apt/sources.list
apt-get update
apt-get install varnish

Now all software installed you can access your webmin control panel using https://yourip:10000

Install Nginx, PHP, Mysql – Debian

Nginix is great web server it’s much faster then apache server, but we need to make some tasks to install and configure Nginix with PHP.

1) Install mysql server and other tools which we need

apt-get install gcc libpcre3 libpcre3-dev zlib1g zlib1g-dev libssl-dev openssl libxml2-dev libevent-dev mysql-client mysql-server

2) Normally debian already includes Nginix

apt-get update

apt-get install nginx

3) Now we can install PHP and extensions

apt-get update

apt-get install php5 php5-fpm php-pear php5-common php5-mcrypt php5-mysql php5-curl php5-cli php5-gd php5-dev

4) Start all services

service nginx start

service php5-fpm start

service mysql start

5) Start php,mysql,nginx at start

update-rc.d nginx default

update-rc.d mysql defaults

update-rc.d php5-fpm defaults

There was a problem creating the parked domain – Cpanel

There was a problem creating the parked domain. Show Details

Error from park wrapper: Using nameservers with the following IPs: xxx.xxx.xxx.xxx,xxx.xxx.xxx.xxx Sorry, the domain is already pointed to an IP address that does not appear to use DNS servers associated with this server. Please transfer the domain to this servers nameservers or have your administrator add one of its nameservers to /etc/ips.remotedns and make the proper A entries on that remote nameserver.

FIX :

If you have access to WHM you must make this change –

WHM > Tweak Settings > Domains > Allow Remote Domains > On

Delete Duplicate Rows In Mysql With PHP

$dupq = mysql_query("SELECT * FROM `db`");
$dups = mysql_fetch_array($dupq);
foreach($dups as $dup){
mysql_query("DELETE FROM db WHERE duplicate_COLUMN='".$dup['duplicate_column']."' AND id!='".$dup['id']."'");
}

duplicate_COLUMN – Name of column and $dup[‘column_name’] delete duplicates which include same column data.