(Wow, 1 year to the day from last post. How funny. Been too busy this last year to write up anything!) These tips are only based on issues I’ve run into on my development server. Â Currently we have a MySQL 5.5.x Ubuntu standard package running in production on Ubuntu 12.04. […]
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 […]
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 […]
Download and unpack Apache and PHP. MySQL 5 is install already. (as per another blog: https://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 […]
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 […]
Zope 2.7.6 – Mysql 5.0.7. I have always thought that output parameters from stored procedures were not useable in Zope‘s ZSQL methods, but a few minutes ago is suddenly occured to me that I could do it by using the “sql_delimiter” function in Zope. To be quick, put something like […]
Quick, before I forget!! Tired of “can’t return a result set in the given context” errors when calling stored procedures in Mysql 5? The ultra fast how-to on returning records from a multi-column multi-record stored procedure in Mysql 5 using Zope/Python! In the ZMySQLDA, edit the db.py file and add […]
