toic.org - Entries for the tag serverhttps://toic.org/blog/tags/server/The latest entries tagged with serveren-usZinniaFri, 08 Jan 2016 14:19:45 +0000Reclaiming InnoDB ibdata unused space. https://toic.org/blog/2012/reducing-innodb-ibdata-unused-space/<p><img align='left' src="/media/filer_public/9f/70/9f70cbfc-1a4f-4885-97e1-66196ea4e805/crystal_128_kcmpartitions.png" alt="ssh" width="120" height="120" style="margin-right:20px; margin-bottom:20px;" /></p> <p>As you well know InnoDB will store its data either in one big system tablespace called ibdata or you can store it in multiple tablespaces (<a href="http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_file_per_table">innodb_file_per_table</a>). In either case InnoDB by default will not reclaim unused space gained when deleting data. Using innodb_file_per_table will separate each InnoDB table in its own .ibd file and it can be easily reclaimed by doing optimize table, using system tablespace will get you stuck since there is no real supported method for reducing you ibdata file and reclaiming unused disk space.</p> <p>One could wonder why would anyone want to have its ibdata in system tablespace? Well there are some &quot;<a class="reference external" href="http://bugs.mysql.com/bug.php?id=51325">bugs</a>&quot; (in versions prior to 5.5) and performance issues that cause mysql lock-ups when using innodb_file_per_table and doing truncate table or drop table or even drop database queries with large buffer pools. In a nutshell MySQL will do a whole buffer pool lock and scan on each of the above mentioned commands effectively stoping the entire MySQL server until it scans over the entire buffer pool for references to those dropped/truncated tables.</p> <p>When given choice and when I do know the pattern of data input to my tablespace i will chose system tablespace.</p> <p>Recently I was a victim of my own system and uncontrolled input of data to my InnoDB table space which leaved me with almost 36Gb of garbage data over one night. Naturally i truncated the data, but it left me with 37Gb ibdata file.</p> <p>So here are the steps I've taken to reduce this system tablespace.</p> <p><strong>First of all backup!</strong></p> <p>I highly recommend <a class="reference external" href="http://www.percona.com/software/percona-xtrabackup">Xtrabackup</a> from Percona for this task, yes it will require additional 37Gb of space for backup but this is by far best point in time backup for MySQL.</p> <pre class="literal-block"> innobackupex $backupdir </pre> <p>And replace the backupdir with your preferred location</p> <p>Let's create a working environment, say you have a lots of space on /home</p> <pre class="literal-block"> mkdir /home/inno-reduce cd /home/inno-reduce </pre> <p>Ok, next stop dumping all the databases that have innodb tables inside, for this I've created a small bash script a while ago..</p> <pre class="code bash literal-block"> <span class="comment">#!/bin/bash </span><span class="name variable">CWD</span><span class="operator">=</span><span class="literal string backtick">`</span><span class="name builtin">pwd</span><span class="literal string backtick">`</span> mysql -e <span class="literal string double">&quot;SELECT distinct(table_schema) FROM information_schema.TABLES where ENGINE = 'InnoDB'&quot;</span> &gt; <span class="name variable">$CWD</span>/innodb-databases.list sed <span class="literal string double">&quot;/table_schema/d&quot;</span> <span class="name variable">$CWD</span>/innodb-databases.list &gt; <span class="name variable">$CWD</span>/tmp mv <span class="name variable">$CWD</span>/tmp <span class="name variable">$CWD</span>/innodb-databases.list <span class="keyword">for</span> database in <span class="literal string backtick">`</span>cat <span class="name variable">$CWD</span>/innodb-databases.list<span class="literal string backtick">`</span><span class="punctuation">;</span> <span class="keyword">do</span> <span class="name builtin">echo</span> <span class="literal string double">&quot;dumping data from </span><span class="name variable">$database</span><span class="literal string double"> to </span><span class="name variable">$CWD</span><span class="literal string double">/</span><span class="name variable">$database</span><span class="literal string double">.sql&quot;</span> /usr/bin/mysqldump --triggers --routines <span class="name variable">$database</span> &gt; <span class="name variable">$CWD</span>/<span class="name variable">$database</span>.sql<span class="punctuation">;</span> <span class="keyword">done</span> </pre> <p>Now would be a good time to cut off any application using MySQL (for example turn off Apache, or drop the packets in firewall). Just copy and paste this code in <strong>step1-dump.sh</strong> file, make it executable and run it. It will produce a .sql dump files in your current directory (hopefully we are still on /home/inno-reduce)</p> <p>Step2 script will iterate trough that dumped data files and drop all the databases that have innodb tables inside.</p> <pre class="code bash literal-block"> <span class="comment">#!/bin/bash </span><span class="name variable">CWD</span><span class="operator">=</span><span class="literal string backtick">`</span><span class="name builtin">pwd</span><span class="literal string backtick">`</span> <span class="keyword">for</span> database in <span class="literal string backtick">`</span>ls <span class="name variable">$CWD</span>/*.sql<span class="punctuation">|</span>awk -F<span class="literal string single">'/'</span> <span class="literal string single">'{print $NF}'</span><span class="punctuation">|</span>cut -d. -f1<span class="literal string backtick">`</span><span class="punctuation">;</span> <span class="keyword">do</span> <span class="name builtin">echo</span> <span class="literal string double">&quot;droping database </span><span class="name variable">$database</span><span class="literal string double">&quot;</span> mysqladmin drop <span class="name variable">$database</span> <span class="keyword">done</span> </pre> <p>Again just copy and paste this code in <strong>step2-drop.sh</strong>, make it executable and run it. At this point There shouldn't be any InnoDB tables in MySQL server.</p> <p>Now, it is a good time to shutdown your MySQL service and rm ibdata file. On typical CentOS system this would be done with</p> <pre class="literal-block"> service mysqld stop rm -f /var/lib/mysql/ibdata1 </pre> <p>If you are not running CentOS and default MySQL install or if you have ibdata file on some other path… please adjust the above. Starting MySQL service at this point would &quot;regenerate&quot; ibdata file with its smallest size increment as defined in my.cnf lets do so:</p> <pre class="literal-block"> service mysqld start </pre> <p>And now for the third script</p> <pre class="code bash literal-block"> <span class="comment">#!/bin/bash </span><span class="name variable">CWD</span><span class="operator">=</span><span class="literal string backtick">`</span><span class="name builtin">pwd</span><span class="literal string backtick">`</span> <span class="keyword">for</span> database in <span class="literal string backtick">`</span>ls <span class="name variable">$CWD</span>/*.sql<span class="punctuation">|</span>awk -F<span class="literal string single">'/'</span> <span class="literal string single">'{print $NF}'</span><span class="punctuation">|</span>cut -d. -f1<span class="literal string backtick">`</span><span class="punctuation">;</span> <span class="keyword">do</span> mysqladmin create <span class="name variable">$database</span> mysql <span class="name variable">$database</span> &lt; <span class="name variable">$CWD</span>/<span class="name variable">$database</span>.sql <span class="keyword">done</span> </pre> <p>As before copy and paste this script into <strong>step3-import.sh</strong> (remember to place this file at the same directory as other two, and dumps), make it executable and run it.</p> <p>Voila! your data is back in, ibdata reduced and MySQL up&amp;running.</p> <p>Remember to restore any access to your MySQL service (starting Apache, clearing firewall drops, etc..)</p> branko@toic.org (branko)Tue, 04 Dec 2012 23:05:56 +0000https://toic.org/blog/2012/reducing-innodb-ibdata-unused-space/ServicesWsgi on cPanel improved https://toic.org/blog/2011/wsgi-on-cpanel-improved/<p>There is a long time now from my original post on running Django with python 2.6 on cPanel based servers, and as time passed there was some issues while deploying Django in such a way. So I decided to post another post with some updates regarding deployment of any python based scripts trough mod_wsgi and cPanel.</p> <p><strong>What's changed since last post?</strong></p> <ul> <li><p class="first">There is a fix for easy_apache rebuilds, retaining the mod_wsgi and not braking rebuild process</p> </li> <li><p class="first">There was some additions in virtualhost include files, enabling python app to run as a user, not nobody</p> </li> <li><p class="first">A fix for cpanel's shell fork bomb protection while running python aps as a user and not nobody</p> </li> <li><p class="first">Some minor changes regarding media handling, so it get's included in virtualhost includes and not by eating up user's subdomains</p> </li> <li><p class="first">And of course python and Django version updates</p> <blockquote> <p>Disclaimer at the beginning, this setup works for me on latest RELESE cPanel build, running on top of CentOS 5.5. I'm posting this as a way how I managed to get it working, so this shouldn't be considered as a official way of running Django or any other python app on cPanell servers. Although, as per my last post &lt;a href=&quot;/blog/2010/django-on-cpanel-with-python2-6-virtualenv-and-mod_wsgi/&quot;&gt;Django on cpanel with python2.6, virtualenv and mod_wsgi&lt;/a&gt; lot's of people are reporting this is working for them also, and this version of deployment guide will bring some more enhancements.</p> </blockquote> </li> </ul> <div class="section" id="installing-python-and-dependencies"> <h1>Installing python and dependencies</h1> <pre class="literal-block"> mkdir /usr/src/python2.7 &amp;&amp; cd /usr/src/python2.7 </pre> <p>again, if you need sqlite, now is the time to install it.</p> <pre class="code bash literal-block"> wget http://www.sqlite.org/sqlite-autoconf-3070500.tar.gz tar zxvf sqlite-autoconf-3070500.tar.gz <span class="name builtin">cd </span>sqlite-autoconf-3070500 ./configure make make install </pre> <p>Since CentOS 5.5 is still running python 2.4 and if you don't wish to brake your system you should install your python 2.7 in alternate location:</p> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /usr/src/python2.7/ wget http://www.python.org/ftp/python/2.7.1/Python-2.7.1.tgz tar zxvf Python-2.7.1.tgz <span class="name builtin">cd </span>Python-2.7.1 ./configure --prefix<span class="operator">=</span>/opt/python2.7 --with-threads --enable-shared ./configure --help make make install </pre> <p>This will install python 2.7 in <strong>/opt/python2.7</strong> directory. To make any use of this alternate install we must do the following:</p> <pre class="code bash literal-block"> ln -s /opt/python2.7/bin/python /usr/bin/python2.7 <span class="name builtin">echo</span> <span class="literal string single">'/opt/python2.7/lib'</span>&gt;&gt; /etc/ld.so.conf.d/opt-python2.7.conf ldconfig </pre> <p>It will make a symbolic link in your path and instruct the system where to find libs for this alternate python install.</p> <p>Now is a good time to check if everything is working as it should</p> <pre class="code python literal-block"> <span class="name">root</span><span class="name decorator">&#64;toy2</span> <span class="punctuation">[</span><span class="operator">/</span><span class="name">usr</span><span class="operator">/</span><span class="name">src</span><span class="operator">/</span><span class="name">python2</span><span class="operator">.</span><span class="literal number integer">7</span><span class="punctuation">]</span><span class="comment"># /usr/bin/python2.7</span> <span class="name">Python</span> <span class="literal number float">2.7</span><span class="operator">.</span><span class="literal number integer">1</span> <span class="punctuation">(</span><span class="name">r271</span><span class="punctuation">:</span><span class="literal number integer">86832</span><span class="punctuation">,</span> <span class="name">Mar</span> <span class="literal number integer">26</span> <span class="literal number integer">2011</span><span class="punctuation">,</span> <span class="literal number integer">22</span><span class="punctuation">:</span><span class="literal number integer">31</span><span class="punctuation">:</span><span class="literal number integer">33</span><span class="punctuation">)</span> <span class="punctuation">[</span><span class="name">GCC</span> <span class="literal number float">4.1</span><span class="operator">.</span><span class="literal number integer">2</span> <span class="literal number integer">20080704</span> <span class="punctuation">(</span><span class="name">Red</span> <span class="name">Hat</span> <span class="literal number float">4.1</span><span class="operator">.</span><span class="literal number integer">2</span><span class="operator">-</span><span class="literal number integer">48</span><span class="punctuation">)]</span> <span class="name">on</span> <span class="name">linux2</span> <span class="name">Type</span> <span class="literal string">&quot;help&quot;</span><span class="punctuation">,</span> <span class="literal string">&quot;copyright&quot;</span><span class="punctuation">,</span> <span class="literal string">&quot;credits&quot;</span> <span class="operator word">or</span> <span class="literal string">&quot;license&quot;</span> <span class="keyword">for</span> <span class="name">more</span> <span class="name">information</span><span class="operator">.</span> <span class="operator">&gt;&gt;&gt;</span> <span class="keyword namespace">import</span> <span class="name namespace">sqlite3</span> <span class="operator">&gt;&gt;&gt;</span> </pre> <p><strong>Type CTRL+D to exit.</strong></p> <p>Next thing to do is installation of python-setup tools:</p> <pre class="code bash literal-block"> /usr/bin/python2.7 <span class="name builtin">cd</span> /usr/src/python2.7/ wget http://pypi.python.org/packages/2.7/s/setuptools/setuptools-0.6c11-py2.7.egg sh setuptools-0.6c11-py2.7.egg --prefix<span class="operator">=</span>/opt/python2.7 </pre> <p>In this tutorial, I'm skipping the installation of mysql for python since you will have to install it per user basis in their virtual environments. All we need to do next is to install virtualenv to our python 2.7 so we can distribute them to our users</p> <pre class="literal-block"> cd /opt/python2.7/bin/ ./easy_install virtualenv </pre> </div> <div class="section" id="mod-wsgi-installation"> <h1>mod_wsgi installation</h1> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /opt/python2.7/lib/python2.7/config/ ln -s ../../libpython2.7.so . <span class="name builtin">cd</span> /usr/src/python2.7/ wget http://modwsgi.googlecode.com/files/mod_wsgi-3.3.tar.gz tar zxvf mod_wsgi-3.3.tar.gz <span class="name builtin">cd </span>mod_wsgi-3.3 ./configure --with-python<span class="operator">=</span>/opt/python2.7/bin/python make make install </pre> <p>Now this will install mod_wsgi.so file in /usr/local/apache/modules folder, as I experienced during cPanel easy_apache rebuilds it will completely empty this folder, thus any virtualhost includes relying on mod_wsgi will fail and easy_apache will not be able to properly rebuild your httpd.conf file and whole apache or php upgrade you were running will fail and revert back to last good state.</p> <p>To avoid this we will now copy the mod_wsgi to different folder:</p> <pre class="literal-block"> mkdir /usr/local/apache/extramodules mv /usr/local/apache/modules/mod_wsgi.so /usr/local/apache/extramodules/ </pre> <p><strong>Note that this wsgi module is built with python 2.7 and will not work with any other version.</strong> If for some strange reason later on you try to run any given python application with system's default python2.4 it will not work.</p> <p>Anyways, all we need to do next is to include mod_wsgi into the apache configuration:</p> <pre class="literal-block"> nano /usr/local/apache/conf/includes/pre_virtualhost_global.conf </pre> <p>and paste:</p> <pre class="literal-block"> LoadModule wsgi_module /usr/local/apache/extramodules/mod_wsgi.so AddHandler wsgi-script .wsgi </pre> <p>Now do configtest:</p> <pre class="literal-block"> root&#64;toy2 [~]# service httpd configtest Syntax OK </pre> <p>If you get <strong>Syntax OK</strong> at the end, you can safely restart your apache:</p> <pre class="literal-block"> /scripts/restartsrv httpd </pre> <p>This is it, our apache can now serve python apps like Django, pylons, etc...</p> </div> <div class="section" id="setting-up-django-projects"> <h1>Setting up Django projects</h1> <p>Just like in my <a class="reference external" href="/blog/2010/django-on-cpanel-with-python2-6-virtualenv-and-mod_wsgi/">previous post</a> I'll use '<strong>[username]</strong>' for cpanel username reference and '<strong>[domain]</strong>' for that user's domain. To match your needs you will have to replace those where appropriate.</p> <p>We will quickly setup user's virtualenv, be aware though some of the python packages requires compile rights, and most of the cPanel setups I've seen so far are forbidding compiler access to their users. You can either make an permanent exception for this user, or you can instruct your user to contact you whenever he needs to install some package that requires compile rights (PIL, mysql...).</p> <p>To enable compile rights for that specific user you can find that user in WHM <strong>WHM-&gt;Compiler Access-&gt;Allow specific users to use the compilers</strong> or if you don't like to exit the shell you can do it like this:</p> <pre class="literal-block"> gpasswd -a [username] compiler </pre> <p>to remove it, use the same path in WHM and in shell:</p> <pre class="literal-block"> gpasswd -d [username] compiler </pre> <p>For now, lets add this user to the compiler group since we will be installing some python packages for him in the start. Also you will have to enable your user a normal login shell, let's first check what shell this user has.</p> <pre class="literal-block"> cat /etc/passwd |grep [username] </pre> <p>it should return something like this:</p> <pre class="literal-block"> [username]:x:928:923::/home/[username]:/usr/local/cpanel/bin/jailshell </pre> <p>This user has jailshell enabled to change that into normal shell do this:</p> <pre class="literal-block"> usermod -s /bin/bash [username] </pre> <p>If it's already bash, don't change it. You can also do this via <strong>WHM-&gt; Manage Shell Access.</strong></p> <p>So let's finaly create a virtualenv for our user:</p> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /home/<span class="operator">[</span>username<span class="operator">]</span> /opt/python2.7/bin/virtualenv --no-site-packages --distribute virtualenv chown -R <span class="operator">[</span>username<span class="operator">]</span>.<span class="operator">[</span>username<span class="operator">]</span> virtualenv </pre> <p>this will create a new directory <strong>/home/[username]/virtualenv</strong> with our new virtual python environment for our user. From this point on we will do everything as the user and not root, until told otherwise.</p> <pre class="literal-block"> su [username] source virtualenv/bin/activate </pre> <p>And the promt will change to something like this:</p> <pre class="literal-block"> (virtualenv)[username]&#64;[domain] [~]# </pre> <p>that way we know we are loged in as user and we are using his virtualenv. Now let's install Django in this users environment, simply enter:</p> <pre class="literal-block"> easy_install django </pre> <p>Now is also a good time to install additional python site-packages like mysql and PIL.</p> <pre class="literal-block"> easy_install pil easy_install mysql-python </pre> <p>So we have the django installed inside the users virtualenv, all we have to do now is start one of the instance. It's probably the best practice to keep django sites outside of public_html folders on cpanel servers. So we will do (<strong>still as a user</strong>)</p> <pre class="code bash literal-block"> <span class="name builtin">cd </span>mkdir djangosites <span class="name builtin">cd </span>djangosites django-admin.py startproject <span class="operator">[</span>projectname<span class="operator">]</span> </pre> <p>So by now we should have a directory structure like this:</p> <pre class="literal-block"> /home/[username]/virtualenv &lt; - python virtual environment /home/[username]/djangosites &lt;- django sites folder /home/[username]/djangosites/[projectname] &lt;- django project </pre> <p>Create the wsgi script for that project, usualy <strong>[projectname].wsgi</strong> in django sites folder</p> <pre class="literal-block"> nano /home/[username]/djangosites/[projectname].wsgi </pre> <p>and paste the following code:</p> <pre class="code python literal-block"> <span class="keyword namespace">import</span> <span class="name namespace">sys</span> <span class="keyword namespace">import</span> <span class="name namespace">site</span> <span class="keyword namespace">import</span> <span class="name namespace">os</span> <span class="name">vepath</span> <span class="operator">=</span> <span class="literal string">'/home/[username]/virtualenv/lib/python2.7/site-packages'</span> <span class="name">prev_sys_path</span> <span class="operator">=</span> <span class="name builtin">list</span><span class="punctuation">(</span><span class="name">sys</span><span class="operator">.</span><span class="name">path</span><span class="punctuation">)</span> <span class="name">site</span><span class="operator">.</span><span class="name">addsitedir</span><span class="punctuation">(</span><span class="name">vepath</span><span class="punctuation">)</span> <span class="name">sys</span><span class="operator">.</span><span class="name">path</span><span class="operator">.</span><span class="name">append</span><span class="punctuation">(</span><span class="literal string">'/home/[username]/djangosites'</span><span class="punctuation">)</span> <span class="name">new_sys_path</span> <span class="operator">=</span> <span class="punctuation">[</span><span class="name">p</span> <span class="keyword">for</span> <span class="name">p</span> <span class="operator word">in</span> <span class="name">sys</span><span class="operator">.</span><span class="name">path</span> <span class="keyword">if</span> <span class="name">p</span> <span class="operator word">not</span> <span class="operator word">in</span> <span class="name">prev_sys_path</span><span class="punctuation">]</span> <span class="keyword">for</span> <span class="name">item</span> <span class="operator word">in</span> <span class="name">new_sys_path</span><span class="punctuation">:</span> <span class="name">sys</span><span class="operator">.</span><span class="name">path</span><span class="operator">.</span><span class="name">remove</span><span class="punctuation">(</span><span class="name">item</span><span class="punctuation">)</span> <span class="name">sys</span><span class="operator">.</span><span class="name">path</span><span class="punctuation">[:</span><span class="literal number integer">0</span><span class="punctuation">]</span> <span class="operator">=</span> <span class="name">new_sys_path</span> <span class="keyword namespace">from</span> <span class="name namespace">django.core.handlers.wsgi</span> <span class="keyword namespace">import</span> <span class="name">WSGIHandler</span> <span class="name">os</span><span class="operator">.</span><span class="name">environ</span><span class="punctuation">[</span><span class="literal string">'DJANGO_SETTINGS_MODULE'</span><span class="punctuation">]</span> <span class="operator">=</span> <span class="literal string">'[projectname].settings'</span> <span class="name">application</span> <span class="operator">=</span> <span class="name">WSGIHandler</span><span class="punctuation">()</span> </pre> <p>give the scripts execute permissions:</p> <pre class="literal-block"> chmod +x /home/[username]/djangosites/[projectname].wsgi </pre> <p>and exit user login with:</p> <pre class="literal-block"> exit </pre> <p>now you will have your <strong>root propmt</strong> at the shell:</p> <pre class="literal-block"> root&#64;servername [/home/username]# </pre> <p><strong>If you have decided so, now is the good time to disable the compiler access for this user.</strong></p> <p>create the apache include folder for that virtualhost:</p> <pre class="literal-block"> mkdir -p /usr/local/apache/conf/userdata/std/2/[username]/[domain]/ nano /usr/local/apache/conf/userdata/std/2/[username]/[domain]/django.conf </pre> <p>and add:</p> <pre class="code apacheconf literal-block"> <span class="name tag">&lt;ifmodule</span> <span class="literal string">mod_wsgi.c</span><span class="name tag">&gt;</span> <span class="name builtin">WSGIScriptAlias</span> / <span class="literal string other">/home/</span>[username]/djangosites/[projectname].wsgi <span class="name builtin">WSGIDaemonProcess</span> [projectname] <span class="keyword">user</span>=[username] <span class="keyword">group</span>=[username] processes=5 threads=15 display-name=%{GROUP} <span class="name builtin">WSGIProcessGroup</span> [projectname] <span class="name builtin">WSGIApplicationGroup</span> %{GLOBAL} <span class="name tag">&lt;/ifmodule&gt;</span> </pre> <p>Ok, so this will create a processgroup for this specific django projects with 5 processes each 15 threads with our user's uid and gid. This is great since we have isolated this user to his own application pool and his own home path, also we are enforcing user quotas since if we omit &quot;user=[username] group=[username]&quot; from WSGIDaemonProcess the deamon process will run ass apache user nobody, and all files made/uploaded via this application will not count into this user's quota. They will also make lot's of problems if the user don't grant global write permissions on some folders. Just like mod_php and php_suexec.</p> </div> <div class="section" id="shell-fork-bomb-exception"> <h1>Shell fork bomb exception</h1> <p>On the other hand, running 5 processes each with 15 threads (you can customize this ofcourse), will hit the defaults ulimits enforced by cPanels shell fork bomb protection (if enabled). You could either disable the protection, or you can make a little adjustments to its logic so that you can make exceptions per user allowing them a bit more freedom but still not unlimited.</p> <p>I have found this method somewhere on cPanel forums (I can't seem to find the exact post right now, but I will update this post when I find it), anyways with little patching of profile, limits and bashrc you can create a list of users that have a slightly higher limits, so our django users won't run into any memory or fork limits normally enforced by <strong>fork bomb protection</strong>.</p> <p>I've created a little tarball with installer scripts for patched fork bomb logic, I advise you to check the files prior to installing them. Script will make a copies of your original files, to the same destination with .orig suffixes.</p> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /usr/src/ wget https://toic.org/files/django/forkbomb.tar.gz tar zxvf forkbomb.tar.gz <span class="name builtin">cd </span>forkbomb ./install.sh </pre> <p>Now all you have to do is put one username per line in <strong>/etc/profile.exclude</strong></p> <p>Each user in that line will have slightly bigger ulimits</p> </div> <div class="section" id="back-to-the-django"> <h1>Back to the Django</h1> <p>Let's also make admin media paths and media folder paths</p> <div class="system-message"> <p class="system-message-title">System Message: WARNING/2 (<tt class="docutils">&lt;string&gt;</tt>, line 323)</p> Literal block expected; none found.</div> <p>mkdir /home/[username]/djangosites/[projectname]/media nano /usr/local/apache/conf/userdata/std/2/[username]/[domain]/django-media.conf</p> <p>and add.</p> <pre class="code apacheconf literal-block"> <span class="name builtin">Alias</span> <span class="literal string other">/admin_media/</span> <span class="literal string other">/home/</span>[username]/virtualenv/lib/python2.7/site-packages/Django-1.2.4-py2.7.egg/django/contrib/admin/media/ <span class="name tag">&lt;Directory</span> <span class="literal string">/home/[username]/virtualenv/lib/python2.7/site-packages/Django-1.2.4-py2.7.egg/django/contrib/admin/media</span><span class="name tag">&gt;</span> <span class="name builtin">Order</span> deny,allow <span class="name builtin">Allow</span> from <span class="keyword">all</span> <span class="name tag">&lt;/Directory&gt;</span> <span class="name builtin">Alias</span> <span class="literal string other">/media/</span> <span class="literal string other">/home/</span>[username]/djangosites/[projectname]/media/ <span class="name tag">&lt;Directory</span> <span class="literal string">/home/[username]/djangosites/[projectname]/media</span><span class="name tag">&gt;</span> <span class="name builtin">Order</span> deny,allow <span class="name builtin">Allow</span> from <span class="keyword">all</span> <span class="name tag">&lt;/Directory&gt;</span> </pre> <p>Just replace your python version, django version and username and projectname in paths. This will create [domain]/media - for site media and [domain]/admin_media/ for admin media</p> <p>Now verify those apache include files and rebuild apache conf:</p> <pre class="literal-block"> /scripts/verify_vhost_includes /scripts/rebuildhttpdconf </pre> <p>As always you can make subdomains for your media files, you will just need to update your [projectname]/settings.py</p> <p>And that's it, hope you enjoy your django installation</p> </div> branko@toic.org (branko)Sun, 27 Mar 2011 20:01:02 +0000https://toic.org/blog/2011/wsgi-on-cpanel-improved/CodingLinuxTutorialsDjango on cpanel with python2.6, virtualenv and mod_wsgi https://toic.org/blog/2010/django-on-cpanel-with-python2-6-virtualenv-and-mod_wsgi/<p><img align='left' src="/media/filer_public/47/a4/47a4abec-d7e5-4beb-b61e-cb2688d0dc02/umltopython.png" alt="ssh" style="padding-top: 20px; margin-right:20px; margin-bottom: 20px;" /><br />Here is the simple to follow step by step tutorial on howto run latest Django on cpanel powered servers with python 2.6, virtual env and mod_wsgi.<br />If you are running cPanel on your server it's most probably a rhel or centos distro, and those will have by default python2.4 installed. You can't just overwrite your python2.4 as many of the system utilities are depended on the python2.4 So what we will do is install an alternate python 2.6 and setup our server to run Django instances with python2.6</p> <p>First of all let's make a folder where we will download all those source packages</p> <div class="section" id="installing-python-and-dependencies"> <h1>Installing python and dependencies</h1> <pre class="literal-block"> mkdir -p /usr/src/python26 &amp;&amp; cd /usr/src/python26 </pre> <p>Next, we have to download and install sqlite3 dependency. It's not needed if your Django instances will not run sqlite databases, but on a safe side it's better to install it than not.</p> <pre class="code bash literal-block"> wget http://www.sqlite.org/sqlite-amalgamation-3.6.4.tar.gz tar zxvf sqlite-amalgamation-3.6.4.tar.gz <span class="name builtin">cd </span>sqlite-3.6.4 ./configure make make install </pre> <p>If all went well it's time to install python 2.6 as alternate install.</p> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /usr/src/python26 wget http://www.python.org/ftp/python/2.6.5/Python-2.6.5.tgz tar zxvf Python-2.6.5.tgz <span class="name builtin">cd </span>Python-2.6.5 ./configure --prefix<span class="operator">=</span>/opt/python2.6 --with-threads --enable-shared make make install </pre> <p>This will install python 2.6 in <strong>/opt/python2.6</strong> and will not interfere with system python install. Let's make a symbolic link to our newly installed python:</p> <pre class="literal-block"> ln -s /opt/python2.6/bin/python /usr/bin/python2.6&lt; </pre> <p>Also we must instruct our system where it should find the libs for new python.</p> <pre class="code bash literal-block"> <span class="name builtin">echo</span> <span class="literal string single">'/opt/python2.6/lib'</span> &gt;&gt; /etc/ld.so.conf.d/opt-python2.6.conf ldconfig </pre> <p>You shoud check if your new python install is working as it should:</p> <pre class="code python literal-block"> <span class="operator">/</span><span class="name">usr</span><span class="operator">/</span><span class="name builtin">bin</span><span class="operator">/</span><span class="name">python2</span><span class="operator">.</span><span class="literal number integer">6</span> <span class="name">Python</span> <span class="literal number float">2.6</span><span class="operator">.</span><span class="literal number integer">5</span> <span class="punctuation">(</span><span class="name">r265</span><span class="punctuation">:</span><span class="literal number integer">79063</span><span class="punctuation">,</span> <span class="name">Jul</span> <span class="literal number integer">15</span> <span class="literal number integer">2010</span><span class="punctuation">,</span> <span class="literal number integer">16</span><span class="punctuation">:</span><span class="literal number integer">55</span><span class="punctuation">:</span><span class="literal number integer">23</span><span class="punctuation">)</span> <span class="punctuation">[</span><span class="name">GCC</span> <span class="literal number float">4.1</span><span class="operator">.</span><span class="literal number integer">2</span> <span class="literal number integer">20080704</span> <span class="punctuation">(</span><span class="name">Red</span> <span class="name">Hat</span> <span class="literal number float">4.1</span><span class="operator">.</span><span class="literal number integer">2</span><span class="operator">-</span><span class="literal number integer">48</span><span class="punctuation">)]</span> <span class="name">on</span> <span class="name">linux2</span> <span class="name">Type</span> <span class="literal string">&quot;help&quot;</span><span class="punctuation">,</span> <span class="literal string">&quot;copyright&quot;</span><span class="punctuation">,</span> <span class="literal string">&quot;credits&quot;</span> <span class="operator word">or</span> <span class="literal string">&quot;license&quot;</span> <span class="keyword">for</span> <span class="name">more</span> <span class="name">information</span><span class="operator">.</span> <span class="operator">&gt;&gt;&gt;</span> </pre> <p>Type <strong>CTRL+D</strong> to exit. Next thing to do is installation of python-setup tools:</p> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /usr/src/python26 wget http://pypi.python.org/packages/2.6/s/setuptools/setuptools-0.6c11-py2.6.egg sh setuptools-0.6c11-py2.6.egg --prefix<span class="operator">=</span>/opt/python2.6 </pre> <p>Make sure to define the prefix on where your new python 2.6 installation is residing. We should make a temporary alias for new python as it will be needed for installation of python mysql package:</p> <pre class="literal-block"> alias python=&quot;/opt/python2.6/bin/python&quot; </pre> <p>Let's check if everything is working ok:</p> <pre class="code python literal-block"> <span class="name">python</span> <span class="name">Python</span> <span class="literal number float">2.6</span><span class="operator">.</span><span class="literal number integer">5</span> <span class="punctuation">(</span><span class="name">r265</span><span class="punctuation">:</span><span class="literal number integer">79063</span><span class="punctuation">,</span> <span class="name">Jul</span> <span class="literal number integer">15</span> <span class="literal number integer">2010</span><span class="punctuation">,</span> <span class="literal number integer">16</span><span class="punctuation">:</span><span class="literal number integer">55</span><span class="punctuation">:</span><span class="literal number integer">23</span><span class="punctuation">)</span> <span class="punctuation">[</span><span class="name">GCC</span> <span class="literal number float">4.1</span><span class="operator">.</span><span class="literal number integer">2</span> <span class="literal number integer">20080704</span> <span class="punctuation">(</span><span class="name">Red</span> <span class="name">Hat</span> <span class="literal number float">4.1</span><span class="operator">.</span><span class="literal number integer">2</span><span class="operator">-</span><span class="literal number integer">48</span><span class="punctuation">)]</span> <span class="name">on</span> <span class="name">linux2</span> <span class="name">Type</span> <span class="literal string">&quot;help&quot;</span><span class="punctuation">,</span> <span class="literal string">&quot;copyright&quot;</span><span class="punctuation">,</span> <span class="literal string">&quot;credits&quot;</span> <span class="operator word">or</span> <span class="literal string">&quot;license&quot;</span> <span class="keyword">for</span> <span class="name">more</span> <span class="name">information</span><span class="operator">.</span> <span class="operator">&gt;&gt;&gt;</span> <span class="name">CTRL</span> <span class="operator">+</span> <span class="name">D</span> </pre> <p>So next in line is mysql for python:</p> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /usr/src/python26 wget http://netcologne.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz tar zxvf MySQL-python-1.2.3.tar.gz <span class="name builtin">cd </span>MySQL-python-1.2.3 python setup.py build python setup.py install </pre> <p>Again let's verify the install:</p> <pre class="code python literal-block"> <span class="name">cd</span> <span class="operator">/</span><span class="name">usr</span><span class="operator">/</span><span class="name">src</span><span class="operator">/</span><span class="name">python26</span> <span class="name">python</span> <span class="name">Python</span> <span class="literal number float">2.6</span><span class="operator">.</span><span class="literal number integer">5</span> <span class="punctuation">(</span><span class="name">r265</span><span class="punctuation">:</span><span class="literal number integer">79063</span><span class="punctuation">,</span> <span class="name">Jul</span> <span class="literal number integer">15</span> <span class="literal number integer">2010</span><span class="punctuation">,</span> <span class="literal number integer">17</span><span class="punctuation">:</span><span class="literal number integer">57</span><span class="punctuation">:</span><span class="literal number integer">29</span><span class="punctuation">)</span> <span class="punctuation">[</span><span class="name">GCC</span> <span class="literal number float">4.1</span><span class="operator">.</span><span class="literal number integer">2</span> <span class="literal number integer">20080704</span> <span class="punctuation">(</span><span class="name">Red</span> <span class="name">Hat</span> <span class="literal number float">4.1</span><span class="operator">.</span><span class="literal number integer">2</span><span class="operator">-</span><span class="literal number integer">48</span><span class="punctuation">)]</span> <span class="name">on</span> <span class="name">linux2</span> <span class="name">Type</span> <span class="literal string">&quot;help&quot;</span><span class="punctuation">,</span> <span class="literal string">&quot;copyright&quot;</span><span class="punctuation">,</span> <span class="literal string">&quot;credits&quot;</span> <span class="operator word">or</span> <span class="literal string">&quot;license&quot;</span> <span class="keyword">for</span> <span class="name">more</span> <span class="name">information</span><span class="operator">.</span> <span class="operator">&gt;&gt;&gt;</span> <span class="keyword namespace">import</span> <span class="name namespace">sqlite3</span> <span class="operator">&gt;&gt;&gt;</span> <span class="keyword namespace">import</span> <span class="name namespace">MySQLdb</span> <span class="operator">&gt;&gt;&gt;</span> <span class="name">CTRL</span> <span class="operator">+</span> <span class="name">D</span> </pre> <p>It shouldn't return any errors while issuing import statements. Ok for the end let's install the virtualenv so we can create a virtual python enviroment for each user and his Django instances</p> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /opt/python2.6/bin ./easy_install virtualenv </pre> <p>And here we conclude the python instalation. Next order of business is mod_wsgi</p> </div> <div class="section" id="mod-wsgi-installation"> <h1>mod_wsgi installation</h1> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /opt/python2.6/lib/python2.6/config/ ln -s ../../libpython2.6.so . <span class="name builtin">cd</span> /usr/src/python26 wget http://modwsgi.googlecode.com/files/mod_wsgi-3.2.tar.gz tar zxvf mod_wsgi-3.2.tar.gz <span class="name builtin">cd </span>mod_wsgi-3.2 ./configure –with-python<span class="operator">=</span>/opt/python2.6/bin/python make make install </pre> <p>This will install mod_wsgi in <strong>/usr/local/apache/modules/mod_wsgi.so</strong> Note that this wsgi module is built with python 2.6 and will not work with any other version. All we have to do now is add the mod_wsgi in our apache conf. You can do that on cpanel servers via WHM. Log into <strong>WHM</strong> , click on <strong>Apache Configuration</strong> then <strong>Include Editor</strong> then <strong>Pre-Virtualhost</strong> Include and select <strong>All versions</strong> Paste this:</p> <pre class="literal-block"> LoadModule wsgi_module /usr/local/apache/modules/mod_wsgi.so AddHandler wsgi-script .wsgi </pre> <p>** Save and restart apache.** And that's it. Our apache is now ready to serve python scripts via mod_wsgi Now all we have to do is install some Django instances for our user.</p> </div> <div class="section" id="setting-up-django-projects"> <h1>Setting up Django projects</h1> <p>I'll use '<strong>[username]</strong> ' for cpanel username reference and '<strong>[domain]</strong> ' for that user's domain. To match your needs you will have to replace those where appropriate. First of all you will have to decide if you will do empty virtual environments so that the user can decide what python site-packages will he use or will you preinstall some packages so that user can only update his virtualenv with packages that are missing. If you are choosing the first method user will have to have compile rights under security setting of cpanel WHM otherwise he will not be able to install packages as python mysql, PIL and some others. If you choose the former method you can preinstall those packages systemwide for our alternate python install, but whenever you update those packages all virtual environments will be updated with them. It's a matter of personal preference. I for myself rather like the clean virtualenv, and before delivering it to the client you as root preinstall in his virtualenv those packages requiring gcc rights. So let's create a virtualenv for our user:</p> <pre class="code bash literal-block"> <span class="name builtin">cd</span> /home/<span class="operator">[</span>username<span class="operator">]</span> /opt/python2.6/bin/virtualenv --no-site-packages --distribute virtualenv chown -R <span class="operator">[</span>username<span class="operator">]</span>.<span class="operator">[</span>username<span class="operator">]</span> virtualenv </pre> <p>this will create a new directory __ /home/[username]/virtualenv __ with our new virtual python environment for our user. You will have to enable normal shell for this user, let's first check what shell this user has.</p> <pre class="literal-block"> cat /etc/passwd |grep [username] </pre> <p>it should return something like this:</p> <pre class="literal-block"> [username]:x:928:923::/home/[username]:/usr/local/cpanel/bin/jailshell </pre> <p>This user has jailshell enabled to change that into normal shell do this:</p> <pre class="literal-block"> usermod -s /bin/bash [username] </pre> <p>You can also do this via <strong>WHM-&gt; Manage Shell Access.</strong> From this point on we will do everything as the user and not root, until told otherwise.</p> <pre class="literal-block"> su [username] source virtualenv/bin/activate </pre> <p>And the promt will change to something like this:</p> <pre class="literal-block"> (virtualenv)[username]&#64;[domain] [~]# </pre> <p>that way we know we are loged in as user and we are using his virtualenv. Now let's install Django in this users environment, simply enter:</p> <pre class="literal-block"> easy_install django </pre> <p>Now is also a good time to install additional python site-packages like mysql and PIL. First temporarily enable compilers for this user via <strong>WHM-&gt;Compiler Access-&gt;Allow specific users to use the compilers</strong> do the modules install with:</p> <pre class="literal-block"> easy_install [module_name] </pre> <p><strong>disable the compiler access afterwards</strong></p> <p>So we have the django installed inside the users virtualenv, all we have to do now is start one of the instance. It's probably the best practice to keep django sites outside of public_html folders on cpanel servers. So we will do (<strong>still as a user</strong>)</p> <pre class="literal-block"> cd mkdir djangosites cd djangosites django-admin.py startproject [projectname] </pre> <p>So by now we should have a directory structure like this:</p> <pre class="literal-block"> /home/[username]/virtualenv &lt; - python virtual environment /home/[username]/djangosites &lt;- django sites folder /home/[username]/djangosites/[projectname] &lt;- django project </pre> <p>Create the wsgi script for that project, usualy <strong>[projectname].wsgi</strong> in django sites folder</p> <pre class="literal-block"> nano /home/[username]/djangosites/[projectname].wsgi </pre> <p>and paste the following code:</p> <pre class="code python literal-block"> <span class="keyword namespace">import</span> <span class="name namespace">sys</span> <span class="keyword namespace">import</span> <span class="name namespace">site</span> <span class="keyword namespace">import</span> <span class="name namespace">os</span> <span class="name">vepath</span> <span class="operator">=</span> <span class="literal string">'/home/[username]/virtualenv/lib/python2.6/site-packages'</span> <span class="name">prev_sys_path</span> <span class="operator">=</span> <span class="name builtin">list</span><span class="punctuation">(</span><span class="name">sys</span><span class="operator">.</span><span class="name">path</span><span class="punctuation">)</span> <span class="name">site</span><span class="operator">.</span><span class="name">addsitedir</span><span class="punctuation">(</span><span class="name">vepath</span><span class="punctuation">)</span> <span class="name">sys</span><span class="operator">.</span><span class="name">path</span><span class="operator">.</span><span class="name">append</span><span class="punctuation">(</span><span class="literal string">'/home/[username]/djangosites'</span><span class="punctuation">)</span> <span class="name">new_sys_path</span> <span class="operator">=</span> <span class="punctuation">[</span><span class="name">p</span> <span class="keyword">for</span> <span class="name">p</span> <span class="operator word">in</span> <span class="name">sys</span><span class="operator">.</span><span class="name">path</span> <span class="keyword">if</span> <span class="name">p</span> <span class="operator word">not</span> <span class="operator word">in</span> <span class="name">prev_sys_path</span><span class="punctuation">]</span> <span class="keyword">for</span> <span class="name">item</span> <span class="operator word">in</span> <span class="name">new_sys_path</span><span class="punctuation">:</span> <span class="name">sys</span><span class="operator">.</span><span class="name">path</span><span class="operator">.</span><span class="name">remove</span><span class="punctuation">(</span><span class="name">item</span><span class="punctuation">)</span> <span class="name">sys</span><span class="operator">.</span><span class="name">path</span><span class="punctuation">[:</span><span class="literal number integer">0</span><span class="punctuation">]</span> <span class="operator">=</span> <span class="name">new_sys_path</span> <span class="keyword namespace">from</span> <span class="name namespace">django.core.handlers.wsgi</span> <span class="keyword namespace">import</span> <span class="name">WSGIHandler</span> <span class="name">os</span><span class="operator">.</span><span class="name">environ</span><span class="punctuation">[</span><span class="literal string">'DJANGO_SETTINGS_MODULE'</span><span class="punctuation">]</span> <span class="operator">=</span> <span class="literal string">'[projectname].settings'</span> <span class="name">application</span> <span class="operator">=</span> <span class="name">WSGIHandler</span><span class="punctuation">()</span> </pre> <p>give the scripts execute permissions:</p> <pre class="literal-block"> chmod +x /home/[username]/djangosites/[projectname].wsgi </pre> <p>and exit user login with:</p> <pre class="literal-block"> exit </pre> <p>now you will have your <strong>root propmt</strong> at the shell:</p> <pre class="literal-block"> root&#64;servername [/home/username]# </pre> <p>create the apache include folder for that virtualhost:</p> <pre class="literal-block"> mkdir -p /usr/local/apache/conf/userdata/std/2/[username]/[domain]/ nano /usr/local/apache/conf/userdata/std/2/[username]/[domain]/django.conf </pre> <p>and add:</p> <pre class="code apacheconf literal-block"> <span class="name tag">&lt;ifmodule</span> <span class="literal string">mod_wsgi.c</span><span class="name tag">&gt;</span> <span class="name builtin">WSGIScriptAlias</span> / <span class="literal string other">/home/</span>[username]/djangosites/[projectname].wsgi <span class="name builtin">WSGIDaemonProcess</span> [username] processes=7 threads=1 display-name=%{GROUP} <span class="name builtin">WSGIProcessGroup</span> [username] <span class="name builtin">WSGIApplicationGroup</span> %{GLOBAL} <span class="name tag">&lt;/ifmodule&gt;</span> </pre> <p>edit the virtualhost entry for that domain:</p> <pre class="literal-block"> nano /usr/local/apache/conf/httpd.conf </pre> <p>and in that virtualhost add:</p> <pre class="literal-block"> Include &quot;/usr/local/apache/conf/userdata/std/2/[username]/[domain]/*.conf&quot; </pre> <p>save &amp; exit</p> <p><strong>test the apache configuration prior to reload:</strong></p> <pre class="literal-block"> service httpd configtest </pre> <p>Should say syntax OK at the end, if so reload the apache:</p> <pre class="literal-block"> /scripts/restartsrv_httpd </pre> <p>And voila, you have your django instance up&amp; running You can now add via User's cpanel media subdomain for django media files, and define the path to the subdomain root in setings.py media root can live inside public_html folder. You can also create additional subdomain for admin media and copy the admin media content to that subdoman. For example: admin-media.[domain]:</p> <pre class="literal-block"> cp -r /home/[username]/virtualenv/lib/python2.6/site-packages/Django-1.2.1-py2.6.egg/django/contrib/admin/media/* /home/[username]/public_html/admin-media/ </pre> </div> branko@toic.org (branko)Sat, 14 Aug 2010 19:59:44 +0000https://toic.org/blog/2010/django-on-cpanel-with-python2-6-virtualenv-and-mod_wsgi/CodingLinuxTutorialsSSH port forwarding https://toic.org/blog/2010/ssh-port-forwarding/<p>In one of my previous post I made a tutorial <a href="/blog/2009/reverse-ssh-port-forwarding/">how to bypass corporate firewalls</a> and gain access into your office computer. It work well if you are at your home and you need ssh access (or any other service) to your office computer. However if the situation is reversed, and you need to access some outside service which your firewall is blocking then you would use this little tutorial with explanations. Although all this is covered in the ssh man pages, one always learn best by real life examples, so here I'll try to cover few of them.</p> <p>To better explain our first problem look at the picture below:</p> <div class="section" id="first-problem"> <h1>First problem</h1> <img alt="/media/filer_public/0e/81/0e819bee-0668-49a6-88f9-0159dfecd287/problem.png" src="/media/filer_public/0e/81/0e819bee-0668-49a6-88f9-0159dfecd287/problem.png" /> <p>We are located at our office computer which is behind very restrictive firewall, and we want to get to the non-standard service running on remote server.</p> <p>Normally I'll use Mysql Administrator for example, to connect on my MySql database on a remote server. That communication would happen on port 3306, and for this to work Mysql Administrator must have appropriate rules set in our firewall to allow that traffic.</p> <p><strong>But what if traffic on that port is blocked?</strong></p> <p>Here is where we come to <strong>ssh port forwarding</strong>. If we have ssh access on any outside computer we can route our traffic through the tunnel and gain access to the service via standard ports.</p> </div> <div class="section" id="second-problem"> <h1>Second problem</h1> <p>Ssh tunnel can be also used to establish connection from insecure networks to standard and non-standard services inside secured firewalled network as shown in picture bellow:</p> <img alt="/media/filer_public/29/44/2944d5e5-2bf1-4d3f-a267-ead351c8c8ae/problem2.png" src="/media/filer_public/29/44/2944d5e5-2bf1-4d3f-a267-ead351c8c8ae/problem2.png" /> <p>As you can see here, server is behind firewall and all the standard ports on that server (like http, pop, imap...) are allowed. Server is also running MySQL service which is listening on port 3306. To connect to it server's firewall should allow this incoming connection.</p> <p><strong>But what if it doesn't?</strong></p> <p>What if the network from which we are connecting is insecure and we wish to maintain our data private while communicating with our trusted, firewalled network?</p> <p>Again we can solve this problem with ssh port forwarding. If we have clear and working ssh access on server or any other machine in the firewalled network, we can route our traffic through that ssh connection.</p> </div> <div class="section" id="solving-the-first-problem"> <h1>Solving the first problem</h1> <p>If our firewall is very restrictive (inbound and outbound), and you don't have control over it, you can use ssh port forwarding to your advantage. Essential things you will need are:</p> <blockquote> <ul class="simple"> <li>allowed ssh traffic on your restrictive firewall, port 22 by default</li> <li>a remote server to which you can connect via ssh, and preferably control over that remote server's firewall.</li> </ul> </blockquote> <p>If even port 22 is blocked in your restrictive firewall you can setup your outside ssh server to listen on some other port that is allowed through your firewall. You can than use <strong>-p</strong> switch in your ssh command to connect on your server. If you don't really know anything about ssh, you can always read <a class="reference external" href="/blog/2008/ssh-basics">ssh basics</a> and than come back here.</p> <p>So in our real example we want to connect to mysql service running on remote server and our firewall won't allow it. We have ssh access on that server so we will use it to tunnel this traffic.</p> <img alt="/media/filer_public/22/4b/224b7310-4743-4e27-bc7a-574dcafc11d7/solution1-1.png" src="/media/filer_public/22/4b/224b7310-4743-4e27-bc7a-574dcafc11d7/solution1-1.png" /> <p>To start up this tunnel this command will be used:</p> <pre class="literal-block"> ssh -L 3306:localhost:3306 username&#64;server </pre> <p>This will actually open up a port 3306 on our local computer listening on loopback interface through established ssh connection on to server's port 3306. If we already have mysql server running on local machine then the port 3306 is already in use, so we need to use another port on our loopback interface, so the command would look like:</p> <pre class="literal-block"> ssh -L 3307:localhost:3306 username&#64;server </pre> <p>Then we use our service client, in this case Mysql administrator and instruct it to connect to <strong>127.0.0.1</strong> at our specified port. We can use the same command to tunnel any other port and or service this way.</p> <div class="section" id="extending-this-example"> <h2>Extending this example</h2> <p>We can also use this connection method to our remote server for routing traffic to some other servers. Of course our remote server must to be able to connect to that remote service. This is usually very popular to forward traffic to some online games running on non standard ports, EvE, Warcraft, and any other game (this might produce additional lag on FPS games).</p> <img alt="/media/filer_public/1b/b4/1bb407b5-0aee-4081-8511-d2d66eb75abb/solution1-2.png" src="/media/filer_public/1b/b4/1bb407b5-0aee-4081-8511-d2d66eb75abb/solution1-2.png" /> <p>As shown on picture, for example we have outside gaming server running at port 66732, and that port is blocked in our firewall. We can use our remote server with ssh connection to establish a ssh tunnel and then route that traffic to our local computer.</p> <p>To do so we would use this command:</p> <pre class="literal-block"> ssh -L 66732:remote.gameserver:66732 username&#64;our.server </pre> <p>On our loopback interface (127.0.0.1), this will create a listening port <strong>66732</strong> which will then be forwarded to <strong>remote.gameserver</strong>'s port <strong>66732</strong> through our ssh connection on port 22. All you need to do is instruct your game client to connect on localhost. This can also be used in constructive purposes, like using your remote shell server to route traffic this way to remote mysql server on which you don't have ssh access but is available to your remote server via 3306 port. Bare in mind that your remote ssh server will have to be able to connect to remote.gameserver/mysql server on appropriate port, it your remote server have any outbound firewall rules filtering this traffic, this example will not work until you open that port.</p> <p>As with <a class="reference external" href="/blog/2009/reverse-ssh-port-forwarding/">reverse ssh port forwarding</a> we can make this connection available to other computers on our LAN by specifying listening interface while establishing the tunnel. I'll go with remote gameserver example and enable our co-workers to connect via same ssh tunnel to remote gameserver without them needing to create their own tunnels.</p> <p>If you have multiple network interfaces on your computer you will specify the one whit which you are connected to your co workers, but you can also enable it on all interfaces like this:</p> <img alt="/media/filer_public/98/28/98282ce6-94d4-4e0a-af3e-23031da34173/solution1-3.png" src="/media/filer_public/98/28/98282ce6-94d4-4e0a-af3e-23031da34173/solution1-3.png" /> <pre class="literal-block"> ssh -L 0.0.0.0:66732:remote.gameserver:66732 username&#64;our.server </pre> <p>when you do <strong>netstat -ntl</strong> on your machine you will see it's listening on <strong>0.0.0.0:66732</strong>. Your co-workers can now connect to your's office pc ip on that port and their connections will be also tunneled via this established ssh connection. Bare in mind that the <strong>remote.gameserver</strong> will see all the connections comming from our.server so if the remote.gameserver have any per ip connection count limit this will obviously be a problem.</p> </div> </div> <div class="section" id="solving-the-second-problem"> <h1>Solving the second problem</h1> <p>How is this problem different form the first one. In essence it's not, only differences is that our firewall is permitting the non standard traffic, or we don't even have a firewall to worry about, but the server's firewalled network is very restrictive and its blocking our non standard ports. Ssh tunnel commands used in this example will be the same. However I can use this example for demonstrating why ssh tunnel can be useful for.</p> <p>Say we don't have firewall and port limitations, but we are temporary on insecure network and server is on secured/trusted network. If we were to use any of the old plain test services like ftp, pop3, imap, synergy, etc... malicious hosts/users can sniff out that traffic and find out any usernames and passwords sent via plain text. Even the contents of the connection. So here's were ssh tunnel steps in again.</p> <p>We can start an ssh tunnel from our insecure network to our secured server's network and tunnel any plain text/insecure traffic through it. By default ssh tunnel binds its self to loopback interface on our computer, which malicious network user doesn't have the access to, and as the ssh is encrypted, all the traffic passing through this tunnel will be plain gibberish to any malicious user sniffing our traffic on this insecure network.</p> <p>Just like in one of the previous posts (<a class="reference external" href="/blog/2009/secure-synergy-setup/">secure synergy setup</a>) we will use this tunnel to secure our traffic from eavesdropping. Ftp actually has sftp (ftp over ssh) so if you already have ssh you will want to use that instead of tunneling ftp traffic, but if for any reason you are not able to use it then this should work as well.</p> <p>I'll take my example on pop3:</p> <img alt="/media/filer_public/50/3e/503e2672-c102-4a04-9889-09a0e71365c4/problem2-1.png" src="/media/filer_public/50/3e/503e2672-c102-4a04-9889-09a0e71365c4/problem2-1.png" /> <p>We establish ssh connection to secured remote server and tunnel the port 110 on our loopback interface to server's 110 through established ssh session. Then we connect with our mail client to localhost and preform plain text pop3 authentication through secure ssh tunnel.</p> <pre class="literal-block"> ssh -L 110:localhost:110 user&#64;secure.server </pre> <p>If you don't have access to the mail server's ssh then you can use another ssh host on secured network to route traffic with this:</p> <pre class="literal-block"> ssh -L 110:mailserver:110 user&#64;secure.server </pre> <div class="section" id="few-useful-tips"> <h2>Few useful tips</h2> <p>As mentioned few times before, perhaps the firewall will not allow standard ssh ports through, or your ssh server is running on different port in which case you should use <strong>-p</strong> switch with ssh. For example your ssh server is running on port 2210 then to forward pop3 traffic you would use:</p> <pre class="literal-block"> ssh -p 2210 -L 110:mailserver:110 user&#64;secure.server </pre> <p>You can also speed things up by using <a class="reference external" href="/blog/2008/ssh-basics/#ssh-key">ssh keys</a> and <a class="reference external" href="/blog/2008/ssh-basics/#ssh-agent">ssh-agent</a></p> <p>And of course if you wish to use your ssh connection only for port forwarding an wish to put it into background you would use:</p> <pre class="literal-block"> ssh -N -f -L 110:mailserver.110 user&#64;secure.server </pre> <p>And from here it's all combinations of above used commands.</p> <p>Have fun!</p> </div> </div> branko@toic.org (branko)Tue, 16 Feb 2010 20:58:36 +0000https://toic.org/blog/2010/ssh-port-forwarding/LinuxTutorialsHowto create rsync server https://toic.org/blog/2009/howto-create-rsync-server/<p>There are tons of reasons why would one want to create a rsync server. For example you wish to backup your data to a remote server but you don't want to backup everything every time. <br /><blockquote>rsync is an open source utility that provides fast incremental file transfer. rsync is freely available under the GNU General Public License and is currently being maintained by Wayne Davison. </blockquote></p> <p>As you can see rsync is ideal for this. You can use it within ssh protocol, rsh and rsync itself. Creating a rsync server will allow you to create easily accessible storage server, update server for your scripts, etc.</p> <p>Anyway let's get started on configuring rsync server which will serve as remote backup server.</p> <p>First make sure you have tcp and udp port <strong>873</strong> open in your firewall. Next install rsync on your machine (if you don't have it yet), and xinetd as well.</p> <pre class="literal-block"> yum install -y rsync xinetd </pre> <p>We will make rsync available trouh xinetd so you must enable it by editing its conf file</p> <pre class="literal-block"> nano /etc/xinetd.d/rsync </pre> <p>edit the line saying:</p> <pre class="literal-block"> disable = yes </pre> <p>to:</p> <pre class="literal-block"> disable = no </pre> <p>so the entire file should look something like this:</p> <pre class="literal-block"> service rsync { disable = no socket_type = stream wait = no user = root server = /usr/bin/rsync server_args = --daemon log_on_failure += USERID } </pre> <p>Next we want to create rsync client username and password:</p> <pre class="literal-block"> nano /etc/rsyncd.secrets </pre> <p>and enter a username and password in format:</p> <pre class="literal-block"> username:password </pre> <p>yes it's plain text.</p> <p>Let's create a rsync server conf file:</p> <pre class="literal-block"> nano /etc/rsyncd.conf </pre> <p>now here enter:</p> <pre class="literal-block"> #maximum allowed connections max connections = 10 #where to log log file = /var/log/rsync.log timeout = 300 </pre> <p>To create a share using a password and being able to send files to rsync server, we shoulwd add to our /etc/rsyncd.conf:</p> <pre class="literal-block"> [backup] comment = Backup place for my office computers path = /backup/ read only = false list = yes uid = backup gid = backup hosts allow = 192.168.0.0/24 # i want to limit the rsnyc server only to this group of hosts secrets file = /etc/rsyncd.secrets auth users = username #enter username specified in secrets file </pre> <p>Now we have a rsync server module at path /backup which will allow only hosts within 192.168.0.0/24 network and users authenticated by username specified in secrets file.</p> <p>To make sure this will be somewhat secure let's change permissions on rsync config files</p> <pre class="literal-block"> chown root.root /etc/rsyncd.* chmod 600 /etc/rsyncd.* </pre> <p>Restart the xinetd:</p> <pre class="literal-block"> service xinetd restart </pre> <p>and voila.</p> <p>Let's go test it out from one of our client hosts:</p> <pre class="literal-block"> rsync rsync.server.com:: backup Backup place for my office computers </pre> <p>To actually backup something onto this host we would use:</p> <pre class="literal-block"> rsync -avz ./ username&#64;rsync.server.com::backup </pre> <p>the command would ask us for a password specified in secrets file. After successful login rsync will start to transfer files to remote machine. Next time we start it it will only transfer the differences since last time.</p> <p>If you would like to script this, entering a password could be a problem. Luckily rsync offers a solution as password file.</p> <pre class="literal-block"> nano /home/branko/.rsync.pass </pre> <p>enter your password here and chmod this file to 600 so it's only readable by you. start the rsync with following command:</p> <pre class="literal-block"> rsync -avz --password-file=/home/branko/.rsync.passw ./ username&#64;rsync.server.com::backup </pre> <p>To setup another share for download only we would create a read-only share without passwords. just append this to your /etc/rsyncd.conf file:</p> <pre class="literal-block"> [update] comment = update downloads path = /home/branko/update read only = true list = yes uid = branko gid = branko hosts allow = 192.168.0.0/24 </pre> <p>Now you may see there is no auth user or secrets password. So when we issue the rsync command on our server again:</p> <pre class="literal-block"> rsync rsync.server.com:: </pre> <p>you will se another module available by the name update.</p> <p>to rsync content from this module just use:</p> <pre class="literal-block"> rsync -avz rsync.server.com::update ./ </pre> branko@toic.org (branko)Wed, 21 Oct 2009 19:57:21 +0000https://toic.org/blog/2009/howto-create-rsync-server/Tutorials