MDB to Postgresql

One of the more daunting tasks of installing new solutions is data migration from old systems. Years of work and data colection cannot be wasted. And since I’ve always found fun in doing this kind of exploration of old application databases this article describes something which should not even be considered legacy migration: migrating data from access (mdb files) to postgresql. The solution I thought this will be a very simple task using the mdb-tools package also available as a ubuntu package:...

December 21, 2008 · len

Vanzare si educatie

Prezentarea unei masini, la sediul clientului: V(anzatorul, agent/reprezentant de vanzari): Va prezint masina noastra M, este o masina perfect adaptata pentru nevoile dumneavoastra P(otentialul cumparator): Stati asa, ce stie sa faca V: Va ajuta sa va deplasati dintr-un punct intr-altul P: Si de ce imi trebuie o masina, pot foarte bine sa merg cu caruta V: Pai are motor, si ajungeti mai repede P: Si ce-i asa deosebit cu motorul asta?...

December 12, 2008 · len

Secure JBoss JMX Console

Since JBoss can now be installed from a zip file it comes with a default unsecured jmx-console. This is unacceptable for production so here is the method to secure the jmx-console using http authentication (applies to JBoss 4.2.2.GA). 1. Edit jboss/server/default/deploy/jmx-console.war/WEB-INF/web.xml and uncomment the security-constraint element: <security-constraint> <web-resource-collection> <web-resource-name>HtmlAdaptor</web-resource-name> <description>An example security config that only allows users with the role JBossAdmin to access the HTML JMX console web application </description> <url-pattern>/*</url-pattern> <http-method>GET</http-method> <http-method>POST</http-method> </web-resource-collection> <auth-constraint> <role-name>JBossAdmin</role-name> </auth-constraint> </security-constraint> 2....

December 8, 2008 · len

Lost Edgy repositories?

Where are my edgy repositories? Failed to fetch http://security.ubuntu.com/ubuntu/dists/edgy-security/main/binary-i386/Packages.gz 404 Not Found Failed to fetch http://security.ubuntu.com/ubuntu/dists/edgy-security/restricted/binary-i386/Packages.gz 404 Not Found I tried at least 5 mirrors from ubuntu and none of them seems to have them. I finally found the solution in this post which is to add the following in /etc/apt/sources.list deb http://old-releases.ubuntu.com/ubuntu/ edgy main restricted deb-src http://old-releases.ubuntu.com/ubuntu/ edgy main restricted deb http://old-releases.ubuntu.com/ubuntu/ edgy-updates main restricted deb-src http://old-releases.ubuntu.com/ubuntu/ edgy-updates main restricted deb http://old-releases....

December 5, 2008 · len

VNC based presentations

VNC based connectivity is one of the most usefull things I know close to ssh connections. This is a simple example on how to use VNC for presentations purposes on linux platforms. Full screen presentations This assumes you wish to share you entire screen for your presentation. install the required packages apt-get install tightvncserver x11vnc xtightvncviewer start the vnc server on your station x11vnc or start with some options I use frequently....

December 2, 2008 · len

Oracle and java.util.Date

Q: Assume someone, for compatibility is storing java.util.Date values in Oracle as long values (number of milliseconds since the standard base time known as “the epoch”, namely January 1, 1970, 00:00:00 GMT), how to read these dates in sql? A: select TO_CHAR(TO_DATE('19700101000000','YYYYMMDDHH24MISS') + NUMTODSINTERVAL(start_time/1000, 'SECOND'), 'YYYY-MM-DD HH24:MI:SS') from qrtz_triggers

December 1, 2008 · len

Cycling GPS usage tips

I’ve been using my GPS for cycling trips for a few months now and I’ve decided to write a small list of tips and tricks I’ve found useful or found out during these months. Most of the concepts here are general but the technical examples applies to linux which is my main operating system. Terms A waypoint is a set of coordinates for your orientation. It can either be created on the track to mark a position or it can be created on the map and used on the track for in track later orientation....

November 30, 2008 · len

Harta blogosferei – la feminin

\function getParam(name) { var index = document.URL.indexOf('?'); var params = new Array(); if ( index != -1 ) { var nameValuePairs=document.URL.substring(index+1,document.URL.length).split('&'); for ( var i=0; i<nameValuePairs.length; i++ ) { nameVal = nameValuePairs[i].split('='); params[nameVal[0]] = nameVal[1]; } } return unescape(params[name]); } var flashvars = { nodeId: getParam(“nodeId”), harta: “harta-blogosferei-la-feminin”, splash: “Incarc …\nHarta blogosferei la feminin”, aboutURL: “http://www.len.ro/work/articles/blogosfera-v2.0/blogosfera-v2-0-algoritm"}; var params = { wmode: “opaque”}; var attributes = {}; swfobject.embedSWF(“http://www.len.ro/hidden/hartaBlogosferei/hartaBlogosferei.swf", “hartaBlogosferei”, “590”, “590”, “9....

November 28, 2008 · len

openoffice.org-base on intrepid

I’m using openoffice base in order to extract various data from a postgresql database to a oocalc file to make charts. This can vary from work related to blogosferic charts. I am using the sdbc postgresql driver and not the jdbc alternative. Since by default ubuntu intrepid ibex does not install the “base” package I tried to do a simple apt-get install openoffice.org-base to my horror this tries to bring a lot of gcj dependencies even if I had already installed a sun sdk....

November 17, 2008 · len

Toate drumurile duc la zoso

Updated 2008-11-14: vrei sa stii cate drumuri duc la tine conform datelor mele? Da-mi un mail si intreba-ma. La webstock Andrei Rosca ma intreba ce cred despre numarul de pasi in care poti ajunge de la un blog la altul folosind harta blogosferei. I-am raspuns atunci ca din ce am vazut blogosfera e foarte conectata si daca exista insulite (componente conexe) acestea sunt mici, nesemnificative relativ la marea masa a blogurilor....

November 11, 2008 · len