Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


Closed Thread
  Search this Thread
Old 03-02-2006, 03:15 PM   #1
Senior Member
Registered: May 2004
Location: Albuquerque, NM USA
Distribution: Debian-Lenny/Sid 32/64 Desktop: Generic AMD64-EVGA 680i Laptop: Generic Intel SIS-AC97
Posts: 4,250

Rep: Reputation: 62
Converting MS Access to Linux (Part One)

A recent question here on LQ reminded me that a real frustration for many people who would like to convert from Windows to Linux is the lack of a satisfactory replacement for MS Access. I can't provide that replacement, but, if a person is willing to work a little bit, I think I can demonstrate how to get a reasonable facsimile. My goal is to explain step-by-step to people who are not professional DBAs how to convert a simple MS Access database to run in linux using POSTGRESQL and ReKall.

There is no magic bullet that I have seen, and I think this process will prove satisfactory to people willing to follow it through. I am actually documenting the process as I do it myself with my MP3 collection, currently managed in an MS Access database. I really think the hardest step for Access users is getting a database application working on Linux. That part is covered here. Part 2 will cover setting up ReKall and getting the data moved to a ReKall database. Feel free to move ahead on your own if I'm too slow. My distro is Debian, sorry about yours if it's not. The guide is somewhat Debian specific, but I don't think that should slow you down too much.

I will eventually move the completed document to an HTML file to facilitate screen prints. I don't think I could post that here anyway, and I am most interested, at this point, in getting feedback about needed clarifications (as well as commentary regarding the need for such a document).


You need root access, to do some of the setup, but the end user will not need any additional priviledges. In following the setup instructions, pay attention to the #'s and $'s preceding the commands.

This HOWTO is not about teaching you to efficiently use or maintain either ReKall or POSTGRESQL, just to get them up and functional enough to get data from an MS Access database. Once that's accomplished we (you) will evaluate how much more, and specifically what, you need to learn. I chose POSTGRESQL because its SQL language is very similar to Oracle's, as is AccessSQL. This should simplify some SQL specific issues as we go along. ReKall is a KDE application, so you'll need large portions of it installed even if (like me) you use Gnome.

Get the software.
Installation packages for both ReKall and POSTGRESQL are available from the Debian repos. (At least 'testing' has them. That's where I got mine.)

# apt-get install rekall
# apt-get install postgresql

Getting Postgresql Working
The default Debian installation of POSTGRESQL does not set up links to libraries so the 'initdb' command (coming up shortly) needs to be run using the complete path. Once you have it installed there will be a POSTGRESQL server running and a POSTGRESQL user named 'postgres' on your system. By Debian's default installation, POSTGRESQL will always be running from now on. It will come up automatically when you boot. For purposes of this project, we are going to assume you'll leave it that way.

You need to establish yourself as another POSTGRESQL user with the authority to create new databases, and you need to define a place where the data will be stored. The POSTGRESQL documentation recommends setting up the data storage area in /usr/local/pgsql/data. That way if you have several users they will all have access to that area.

Our example will assume only one user, joenormal, who wants the data in his home directory. (Understand that he already exists as a Linux user, and he will be added as a POSTGRESQL user.) Setting it up this way means that you would have to run 'initdb' once for each user who plans to develop and maintain databases. All right. Ready. Log in as root.

debian:~# su postgres

postgres@debian:/root$ createuser joenormal
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n

postgres@debian:/root$ exit

debian:~# exit

joenormal@debian:~$ psql
Welcome to psql 7.4.9, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

joenormal=> \q


There are a few indentations and carriage returns in there that you won't see on the screen ... artistic license. What we have done is is define 'joenormal' as a POSTGRESQL user, and tested to make sure he was recognized as such. So far, so good. Now we'll make a place to store the data.

joenormal@debian:~$ mkdir ./pgsql/

joenormal@debian:~$ mkdir ./pgsql/data

joenormal@debian:~$ su -

debian:~# chown postgres /home/joenormal/pgsql/data/

debian:~# su postgres

postgres@debian:/root$ /usr/lib/postgresql/7.4/bin/initdb -D /home/joenormal/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale ...
. (whole buncha other stuff here)
creating information schema... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

/usr/lib/postgresql/7.4/bin/postmaster -D /home/joenormal/pgsql/data
/usr/lib/postgresql/7.4/bin/pg_ctl -D /home/joenormal/pgsql/data -l logfile start

postgres@debian:/root$ exit



That's it. We are now ready for ReKall. Don't bother trying to use the start-up commands at the end since POSTGRESQL is already running.
Old 03-03-2006, 10:43 AM   #2
LQ Guru
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 9,000
Blog Entries: 4

Rep: Reputation: 3144Reputation: 3144Reputation: 3144Reputation: 3144Reputation: 3144Reputation: 3144Reputation: 3144Reputation: 3144Reputation: 3144Reputation: 3144Reputation: 3144
Excellent post. Shouldn't this be a HOWTO? I hope that once the posting is completely finished this way, it will be copied to the other section.

One slight comment: for many databases it's a good idea to designate one user who "builds databases" and has the authority to construct and modify them; versus those who simply may "use" them. On my systems, the user-id that I use on a daily basis is non-privileged, and a separate non-root user is designated for system maintenance.
Old 03-04-2006, 12:16 AM   #3
Senior Member
Registered: May 2004
Location: Albuquerque, NM USA
Distribution: Debian-Lenny/Sid 32/64 Desktop: Generic AMD64-EVGA 680i Laptop: Generic Intel SIS-AC97
Posts: 4,250

Original Poster
Rep: Reputation: 62
Here is Part Two.
Old 03-04-2006, 01:10 PM   #4
Senior Member
Registered: Apr 2001
Location: Perry, Iowa
Distribution: Mepis , Debian
Posts: 2,692

Rep: Reputation: 45
nice, please submit as a tutorial( see link above) thanks

Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
I need all of your help converting from MS to Linux! h0mersimps0n Linux - Software 26 01-09-2005 07:10 AM
How can I find if a certain part of Linux is installed? Conpen2000 Linux - Newbie 2 01-07-2004 04:55 PM
3rd part software for Linux 8 sarika_ni Linux - General 1 10-01-2003 08:12 AM
the worst part of linux :( bit7 Linux - Software 23 06-13-2003 04:50 PM
how was the first ever part of linux programmed? slakker Linux - General 1 05-01-2003 01:12 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:08 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration