Databases


UnixODBC on Ubuntu 12.04 broken and unable to connect error 3

Recently I upgrade to Ubuntu 12.04. We had UnixODBC running fine in 10.04, but something changed because the odbc drivers couldn’t be found.  I got an error while running isql: isql -v gregtest [01000][unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/odbc/libmyodbc.so’ : file not found We also couldn’t run our Acucobol apps anymore […]


UnixODBC example setup and configuration on Ubuntu Lucid with Mysql and PostgreSQL using the command line only 10

Below is a very quick example of what I did to configure a system DSN connection to a Mysql and PostgreSQL database using UnixODBC drivers on Ubuntu Lucid server from command line only.   # Do the obvious, install mysql an postgresql first. :) # install unixodbc apt-get install unixodbc […]


Compile Apache 2 with PHP 4 and MySQL 5 (while MySQL 4 is also installed) 1

Download and unpack Apache and PHP. MySQL 5 is install already. (as per another blog: http://www.1stbyte.com/2006/04/02/mysql-5-upgrade-compiled/ Make sure you have the proper dev packages. In my case I had to install ‘libflex’ and ‘libgdbm-dev’ using apt-get install to install PHP. (I have Debian Unstable) ./configure –prefix=/var/httpd –enable-so –enable-proxy –enable-proxy-ftp –enable-proxy-http […]


Mysql 5 upgrade – compiled 1

I just upgraded my MySQL server from 5.0.7 to 5.0.10. I wanted to make a few notes about what I did to set it up. 1. I compiled MySQL 5.0.10-beta. ./configure –prefix=/var/mysql5010 –with-unix-socket-path=/tmp/mysql5.sock –with-mysqld-ldflags=-all-static –enable-assembler –with-low-memory –with-named-curses-libs=/lib/libncurses.so.5 –with-mysqld-user=mysql 2. Did a make && make install 3. Stop mysql507 (on my […]