If you plan on writing any python applications/scripts for performing any basic SQL query’s against an oracle database you will need to have the cx_oracle library files installed to your machine (or server) here are some quick instructions on how to install them. Please be aware i have only tested these instructions under Ubuntu 10.10 (32bit) using the 11.2 oracle instant client, when I have time I will try and install this on one of the x86_64 machines i have access to.
Debian echo "US/Pacific" > /etc/timezone dpkg-reconfigure --frontend noninteractive tzdata Ubuntu (assuming you are not root) echo "US/Pacific" | sudo tee /etc/timezone sudo dpkg-reconfigure --frontend noninteractive tzdata NOTE: there is no need to reboot the system for the new settings to apply
Here is a very good how to on setting up a mail server under ubuntu (can be modified to work under Debian Lenny as well just need to tweak some of the package versions :) ) http://flurdy.com/docs/postfix/ I’m working on tweaking my setup to get maildrop working so I can get some server side mail rules working, only down side i can see doing this is that you might see some slowness on mail being processed.
NOTE: openca-tools need to be compiled/installed first. Needed for openca apt-get install mysql-server apt-get install apache2 Needed for compiling apt-get install libssl-dev apt-get install build-essential apt-get install libapache2-mod-perl2 libcgi-session-perl libxml-parser-perl libauthen-sasl-perl libconvert-asn1-perl libdigest-hmac-perl libdigest-sha1-perl libintl-perl libio-socket-ssl-perl libio-stringy-perl libmime-lite-perl libmime-perl libmailtools-perl libnet-server-perl libnet-ldap-perl libparse-recdescent-perl libx500-dn-perl libxml-twig-perl libdbd-pg-perl libdbi-perl libpg-perl libxml-dom-perl libxml-sax-perl openca base export PATH=$PATH:/usr/local/openca/bin ./configure --prefix=/usr/local/openca --with-httpd-user=www-data --with-httpd-group=www-data --with-openca-prefix=/usr/local/openca --with-openssl-tools-prefix=/usr/local/openca --with-etc-prefix=/usr/local/openca/etc --with-module-prefix=/usr/local/openca/modules --enable-scep --with-service-mail-account=cacert@toon-net.local --with-cert-chars=UTF8 --with-ca-organization=ThinkSide --with-ca-locality=Cambridge --with-ca-state=Cambridgeshire --with-ca-country=GB --with-web-host=openca.toon-net.local --with-httpd-fs-prefix=/usr/local/openca/htdocs --with-dist-user=madwolf --with-dist-group=openca --with-db-type=mysql --with-db-user=openca --with-db-name=openca --with-db-host=localhost --with-db-port=3306 --with-db-passwd=openca --with-db-namespace= make make install-offline make install-online
Needed for openca apt-get install mysql-server apt-get install apache2 Needed for compiling apt-get install libssl-dev apt-get install build-essential apt-get install libapache2-mod-perl2 libcgi-session-perl libxml-parser-perl libauthen-sasl-perl libconvert-asn1-perl libdigest-hmac-perl libdigest-sha1-perl libintl-perl libio-socket-ssl-perl libio-stringy-perl libmime-lite-perl libmime-perl libmailtools-perl libnet-server-perl libnet-ldap-perl libparse-recdescent-perl libx500-dn-perl libxml-twig-perl libdbd-pg-perl libdbi-perl libpg-perl libxml-dom-perl libxml-sax-perl openca tools ./configure --prefix=/usr/local/openca --with-httpd-user=www-data --with-httpd-group=www-data --with-openca-prefix=/usr/local/openca --with-etc-prefix=/usr/local/openca/etc --with-module-prefix=/usr/local/openca/modules --with-web-host=openca.toon-net.local --enable-ocspd make make install
How much memory is being used pcanham@solman:~$ echo "`prtconf | grep 'Memory size' | awk '{print $3}'` - (`vmstat 1 2 | tail -1 | awk '{print $5}'` /1024)" | bc 4891 Workout total server memory pcanham@solman:~$ prtconf | grep 'Memory size' | awk '{print $3}' 8064 Percentage of memory in use pcanham@solman:~$ echo "4891/(8064/100)" | bc 61 61% of memory in use
Here is a very quick way to get the oracle client installed under Ubuntu, only down side i have found on this is that you have to install the build packages and X to the machine to get it to install which isn’t something I like doing on production machines i would rather have X and build tools else where and install just the needed packages but never mind. Install necessary package apt-get install ia32-libs xorg build-essential Extract the Oracle client into a temp directory I normally use either the roots home directory or /var/tmp
By default this is set to 10mb, if you want this to be set to a smaller value you will need to add this into your config file (main.cf) Quick way to check what its set to postconf | grep message_size_limit message_size_limit = 10240000 10240000 = 10mb
I have been using this forum when every i have had any questions about Netscalers and they do have a lot of very useful HOW-TO’s and debugging guides here so anyone who uses netscalers i would strongly recommend bookmarking this forum (http://www.netscalerkb.com). Any way here is a copy of the commands. If you want to: Uncompress an archived log file: gunzip newnslog.21.gz Discover the time period covered by the log: nsconmsg -K newnslog.
I have found a couple of times that i need to setup vncserver on a machine in one of the remote offices very useful when needing to load up either some web UI’s or applications locally due to either bandwidth limitations or licensing. These are the packages you need for being able to install vncserver from the opencsw repository (these should also work for the blastwave repo as well) system SUNWxwcft X Window System common (not required) fonts system SUNWxwdv X Windows System Window Drivers system SUNWxwfnt X Window System platform required fonts system SUNWxwice X Window System Inter-Client Exchange (ICE) Components system SUNWxwmod X Window System kernel modules system SUNWxwopt X Window System Optional Clients system SUNWxwplr X Window System platform software configuration system SUNWxwplt X Window System platform software system SUNWxwrtl X Window System & Graphics Runtime Library Links in /usr/lib system SUNWpl5u Perl 5.