News : The level of daily SPAM has reached insane proportions, all registrations are now manual. I ask you to send me an e-mail (john (at) murga (dot) org), to confirm that you want me to create an account for you.


Post Reply  Post Thread 
Pages (2): « First [1] 2 Next > Last »
murgaua - distro compatibility
Author Message
TerryW
Junior Member
**


Posts: 11
Group: Registered
Joined: Dec 2007
Status: Offline
Reputation: 0
Post: #1
murgaua - distro compatibility

Hi there,
I started looking at murgaLua around December with a view to learning to program in a windows type environment. I'd had little experience of programming in the past other than in Basic on a BBC B years ago and on my Psion Revo. I set about making a little banking program using a simple database to record transactions both debit and credit and which would display a month at a time in a window on my PC.
This went very well and after 'stealing' bits of code from various places - mostly John Murga's sqlTool.lua prog and bits from Mikshaw's progs, I had a working program which did just what I wanted. Brilliant!!
I did this using Puppy Linux 3.01 - a super little distro - on a laptop, and was very happy. So, I wondered about backing up my efforts on my main computer which uses Ubuntu 6.06 LTS.
I copied the murgaLua run-time to /usr/bin, as on my laptop, and the Bank.lua prog and the database.db file into my home directory. I checked the permissions on all the files and tried to run Bank.lua. It crashed!
I transfered sqlTool.lua and ran that and it told me my database.db file was an "unsupported file format".
I re-ran Bank.lua in Ubuntu 6.06 and made a new database file - test.db - and of course this was OK. Strangely, when I transfered test.db to my original Puppy Linux, it also worked fine!
This got me to thinking, how would it be with other distros, so, I dug out an old laptop which had several recent distros on it and did exactly the same for each one.
The result was that Ubuntu 7.04, Ubuntu 7.10, Suse 10.3, PCLinuxOS 2007, Mepis 7, and Mandriva 2008 all worked perfectly, my original database.db file opening happily on each one.
The two distros that failed were Debian Etch and Slackware 12. Both these wouldn't run the basic murgaLua, coming up with the same error :- "error while loading shared libraries:libsqlite3.so.0:cannot open shared object file:no such file or directory".
I imagine that I must have done something wrong, but what?
I haven't tried it with Microsoft Windows, about the only thing I use that for is to run Repton 1/2/3 and Xor games. I guess that dates me.

Anyone have any ideas?
Terry

01-28-2008 12:26 AM
Find all posts by this user Quote this message in a reply
jpjacobs
Member
***


Posts: 113
Group: Registered
Joined: Jul 2007
Status: Offline
Reputation: 0
Post: #2
RE: murgaua - distro compatibility

TerryW Wrote:
The two distros that failed were Debian Etch and Slackware 12. Both these wouldn't run the basic murgaLua, coming up with the same error :- "error while loading shared libraries:libsqlite3.so.0:cannot open shared object file:no such file or directory".


The linux binaries aren't linked statically against libsqlite3. This means they need the library to be installed to work.
So i guess if you install libsqlite3 it should work anyway.

The reason you have troubles with the existing database is an issue between 2 versions of sqlite i guess (2 and 3). There may be a conversion utility around to convert version 2 db's to version 3 db's.

Greetz,

Jan-Pieter

01-28-2008 12:32 AM
Find all posts by this user Quote this message in a reply
TerryW
Junior Member
**


Posts: 11
Group: Registered
Joined: Dec 2007
Status: Offline
Reputation: 0
Post: #3
RE: murgaua - distro compatibility

That should of course be murgaLua - distro compatibility. Must have hit ctrl instead of shift.

01-28-2008 12:39 AM
Find all posts by this user Quote this message in a reply
TerryW
Junior Member
**


Posts: 11
Group: Registered
Joined: Dec 2007
Status: Offline
Reputation: 0
Post: #4
RE: murgaua - distro compatibility

Wow! Thanks for the quick reply Jan Pieter. I sort of assumed that everything needed would be in the run-time file. I'm afraid I'm not well up on Linux and how it works, I just like to use it. I'll look at Ubuntu 6.06 and see if I can find out which version is installed there.

Great! Thanks again
Terry

01-28-2008 12:47 AM
Find all posts by this user Quote this message in a reply
mikshaw
Senior Member
****


Posts: 522
Group: Registered
Joined: Apr 2007
Status: Offline
Reputation: 5
Post: #5
RE: murgaua - distro compatibility

Yeah, use of dynamic libraries is common. This often allows for easier library upgrades/patches, and reduces the size of your system and the need to include that code in applications. Unlike Windows, which has a fairly uniform collection of dynamic libraries, Linux distributions vary in what libraries are installed by default, so you will sometimes find that installing them yourself will be necessary.

01-28-2008 01:57 AM
Find all posts by this user Quote this message in a reply
TerryW
Junior Member
**


Posts: 11
Group: Registered
Joined: Dec 2007
Status: Offline
Reputation: 0
Post: #6
RE: murgaua - distro compatibility

Ubuntu 6.06 has libsqlite3 version 3.2.8
Ubuntu 7.04 has libsqlite3 version 3.3.13

Debian Etch had no libsqlite3 installed nor libstdc++5 installed. Installed both and murgaLua and my prog now work.
Slackware is taking a little longer!

Thanks to jpjacobs

01-28-2008 02:06 AM
Find all posts by this user Quote this message in a reply
TerryW
Junior Member
**


Posts: 11
Group: Registered
Joined: Dec 2007
Status: Offline
Reputation: 0
Post: #7
RE: murgaua - distro compatibility

Just for completeness, have downloaded slapt-get added extras to config file and downloaded sqlite3. Both murgaLua and my app now work fine. So that's 100%.

Thanks also to mikshaw not least for his Reference Tool.

One way or another I've learned quite a lot.

Terry

01-29-2008 02:01 AM
Find all posts by this user Quote this message in a reply
JohnMurga
Administrator
*******


Posts: 381
Group: Administrators
Joined: Apr 2007
Status: Offline
Reputation: 2
Post: #8
RE: murgaua - distro compatibility

Hi,

I know this may be a bit late ... But could you try this binary on your other Linux platforms ?

It is a little more than just a static build, and I hope it'll work on any libc6+ system with X.

Do "save as" !

http://www.murga-projects.com/murgaLua/murgaLua

You'll have to do "chmod +x murgaLua" after downloading it.

Cheers
JohnM

This post was last modified: 02-03-2008 08:04 AM by JohnMurga.

02-03-2008 08:03 AM
Visit this user's website Find all posts by this user Quote this message in a reply
TerryW
Junior Member
**


Posts: 11
Group: Registered
Joined: Dec 2007
Status: Offline
Reputation: 0
Post: #9
RE: murgaua - distro compatibility

Sorry John, I've only just seen your post.

I've just replaced the murgaLua run-time in /usr/bin on Ubuntu 6.06 - the only distro that didn't eventually work, and I can run my prog fine.
Just to cross check, I replaced /usr/bin/murgaLua with the previous version and ran your sqlTool.lua and it gave the error just as in my first post.
Replacing /usr/bin/murgaLua again with your new static build, resulted in sqlTool.lua being happy with my database file.

Thanks very much for taking the trouble to compile a statically linked version. You've made a pensioner very happy! I will try it with Debian Etch and Slackware 12 but first I'll have to remove the bits I added to make them work.

Cheers
Terry

02-05-2008 10:56 PM
Find all posts by this user Quote this message in a reply
JohnMurga
Administrator
*******


Posts: 381
Group: Administrators
Joined: Apr 2007
Status: Offline
Reputation: 2
Post: #10
RE: murgaua - distro compatibility

TerryW Wrote:
Thanks very much for taking the trouble to compile a statically linked version. You've made a pensioner very happy! I will try it with Debian Etch and Slackware 12 but first I'll have to remove the bits I added to make them work.


Thanks for trying it out ! :-)

The static version I compiled does not have Xft (ie. you'll have jagged edges in your fonts and stuff), in the next full build I'll be bundling the static Xft version with all other versions being in a separate archive (I'll still be building them at the same time).

I tried to create a version that worked on everything, and strangely enough had most problems with a few Ubuntu based systems I got to play with.... (with things like libstdc++, etc)...

This is so that you have a base you can use for compilation that works on the largest number of platforms.

Either way this static version works on everything I tried it on including Mepis 64Bit (which comes with a 32bit libc).

Cheers
JohnM

02-05-2008 11:27 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Pages (2): « First [1] 2 Next > Last »
Post Reply  Post Thread 

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump: