Unix Hosting News & Commentary

irgendwie stehen wir grad auf der Leitung: Anforderung ist, einen MySQL-Server auf Port 80 laufen zu lassen, um gängige Firewalls zu umgehen.

Der Lösungsansatz lautete: VServer aufsetzen, MySQL drauf und Port 80 hierfür einrichten.

Weit gefehlt, denn MySQL läuft nicht unter root und darf damit keine Ports < 1024 belegen.

IpTables zum Umleiten nutzen scheidet aus, weil NAT unter dem VServer nicht verfügbar ist.

Hat jemand eine dusselige Idee, wie man MySQL dennoch auf den Port 80 bringen kann?

Webalizer

Webalizer is a web server log file analysis program, which produces usage statistics in HTML format for viewing with a browser. The results are presented in both columnar and graphical format, which facilitates interpretation. Yearly, monthly, daily and hourly usage statistics are presented, along with the ability to display usage by site, URL, referrer, user agent, browser and country, user agent and referrer are only available if your web server produces Combined log format files. The person who write this program can be reached with Bradford L. Barrett, brad@mrunix.net.

  1. Webalizer RPM is installed by default. Uninstall Webalizer
    rpm –e

    Install GeoIP library

    1. tar –zxvf /usr/src/GeoIP.tar.gz
    2. cd /usr/src/GeoIP-version
    3. make
    4. make

      Install and patch Webalizer with geolizer

      1. tar –zxvf style=”list-style-type : lower-alpha;”>tar –zxvf style=”list-style-type : lower-alpha;”>cd /usr/src
      2. patch –p0 < style="list-style-type : lower-alpha;">rpm –Uvh style=”list-style-type : lower-alpha;”>rpm –Uvh style=”list-style-type : lower-alpha;”>Add share libraries path /usr/lib to /etc/ld.so.conf
      3. ldconfig
      4. cd style=”list-style-type : lower-alpha;”>./configure –-enable-geoip
      5. make
      6. make

        Webalizer configuration file webalizer.conf.sample can be found in /etc

      7. Create a folder to host respective webalizer configure file for each virtual hosting, mkdir

        mv /etc/webalizer.conf.sample
        vi 300GeoIP yesGeoIPDatabase clfOutputDir webalizer.histIncremental yesIncrementalName webalizer.currentReportTitle Usage Statistics forHostName PageType cgiPageType phpPageType shtmlHTMLBody HTMLBody BODY.body {font-family: Helvetica, Arial}A:hover {color:#4F709F}HTMLBody Quiet yesFoldSeqErr yesHideURL *.gifHideURL *.GIFHideURL *.jpgHideURL *.JPGHideURL *.pngHideURL *.PNGHideURL *.raSearchEngine yahoo.com p=SearchEngine altavista.com q=SearchEngine google.com q=SearchEngine eureka.com q=SearchEngine lycos.com query=SearchEngine hotbot.com MT=SearchEngine msn.com MT=SearchEngine infoseek.com qt=SearchEngine webcrawler searchText=SearchEngine excite search=SearchEngine netscape.com search=SearchEngine mamma.com query=SearchEngine alltheweb.com query=SearchEngine northernlight.com qr

    5. To update GeoIP.dat in future:
      wget -P /usr/src

      gunzip /usr/src/GeoIP.dat.gz

      mv /usr/src/GeoIP.dat

      Run webalizer, webalizer –c />You may want to add shared libraries path for libGeoIp into /etc/ld.so.conf
      By default, libGeoIP library is installed in Run ldconfig after changes.

      Add a crontab entry as follow (runs everyday at 0010am):

      10 0 * * * for i in /etc/webalizer/*.conf; do /usr/local/bin/webalizer -d –c $i; done

CGIWrap

Assume we have main web root directory at /home/admin/web, and we would like to have CGIWrap transparently at the background. The cgi-bin folder is located inside web folder. Please change both the user and group in httpd.conf to apache.

  1. tar -zxvf

    ./configure –with-httpd-user=apache

    make install

  2. Update the httpd.conf file with

    ScriptAlias /cgi-bin/

    RewriteEngine On
    RewriteMap lowercase int:tolower
    RewriteRule ^/cgi-bin/(.*) /cgi-bin/cgiwrap/admin/$1 [PT]

    Sample of error message for CGIWrap:

« Previous Posts

Categories

Site Directory

Top Web Hosts
1.  
StartLogic Review
2.  
PowWeb Review
3.  
Just Host
4.  
1&1 Hosting
5.  
Hostmonster Review
6.  
Yahoo Review
7.  
IX Web Review
8.  
Hostgator Review
9.  
iPowerWeb Review
10.  
Dot5 Review
-   
Go Daddy Review
-   
Network Solutions Review

Blogroll

Powered by Technorati