Converting a database to run on Linux

For questions and postings not covered by the other forums
Rich Cassell
Posts: 77
Joined: Mon Aug 24, 2009 11:22 pm
Location: Nottinghamshire, UK

Re: Converting a database to run on Linux

Postby Rich Cassell » Tue Oct 19, 2010 2:35 am

Hi all,

After a day-long hiatus from this i have now moved back onto it but have now hit issues with starting up the database.

The JadeConvertDb application appears to have re-arranged the folder structure of the database, but the files remain the same type as before (exe, bin, dat etc). I run the application in a Windows environment (i am wanting to convert to Linux) was this correct?

Basically, i am wanting to start up the jadrap.exe and jadapp.exe but nothing is working. I am obviously missing something obvious.

If anybody knows how to run these within Linux then that'd be very helpful. Or, if i have run the convert application incorrectly then it'd be useful to know where i went wrong!

Thanks for all the help so far.

Rich

User avatar
BeeJay
Posts: 312
Joined: Tue Jun 30, 2009 2:42 pm
Location: Christchurch, NZ

Re: Converting a database to run on Linux

Postby BeeJay » Tue Oct 19, 2010 2:49 pm

The JadeConvertDb application needs to be run using your "empty" Linux server installation of Jade. It will then connect to the DbServer (jadrap/jadserv) running on your Windows box, using the supplied connection details, and will write the converted data out into your target "empty" Jade Database on the Linux server.

ie: Yes, you've probably run the JadeConvertDb application incorrectly based on your description of it changing the directory structures on your Windows machine as you shouldn't be running the JadeConvertDb application on your Windows machine.

Note: Your proposed version of Linux is not one of the two officially supported versions of Linux, so you'll need to make sure you have all the appropriate levels of the relevant software installed etc.

Cheers,
BeeJay.

Rich Cassell
Posts: 77
Joined: Mon Aug 24, 2009 11:22 pm
Location: Nottinghamshire, UK

Re: Converting a database to run on Linux

Postby Rich Cassell » Tue Oct 19, 2010 8:23 pm

Hi BeeJay,

Thanks for confirming that - i had a feeling i had run it incorrectly.

Ok, i will try again using the Linux machine. So, just to confirm, i leave the database on Windows, set up an empty system on Linux and then connect to the database with the script... How would i reference the database using the databasePath parameter? (if that is indeed what i need to do).

Sorry about all of the questions - this is all new ground for me.

Yeah i realised early on that the only supported Linux OS's were Red Hat and SUSE. I was told to give the RHEL installation a go for Fedora but i will see how much success i have. Hopefully I'll be able to get it working without too many hurdles!

Thanks for all the help so far! It's very appreciated.

Rich

User avatar
BeeJay
Posts: 312
Joined: Tue Jun 30, 2009 2:42 pm
Location: Christchurch, NZ

Re: Converting a database to run on Linux

Postby BeeJay » Wed Oct 20, 2010 8:28 am

1. The path= parameter is the path to your Windows database as seen by the DbServer process on the Windows machine. For example, if your jadrap shortcut has path=d:\Jade\system then your execution of the JadeConvertDb application on your Linux maching will have path=d:\Jade\system even though that directory is not valid on your Linux machine. The JadeConvertDb application will know how to connect to the jadrap by way of the following setting in the [JadeClient] section of your ini file:

[JadeClient]
ServerNodeSpecifications=TcpIp,<WindowsMachineNameOrIPAddress>,<TcpIpPortNumber>

eg: If your windows machine was 192.168.1.2 and the port number was 51234 then your settings would be:

[JadeClient]
ServerNodeSpecifications=TcpIp,192.168.1.2, 51234


2. The defaultPath parameter controls which directory on your Linux machine is used to write the converted files into.

Note: I've never actually converted to a Linux machine, only used the JadeConvertDb application to convert from Ansi to Unicode, so I can't really help you much with what to do on the Linux side of things.

Cheers,
BeeJay.

allistar
Posts: 156
Joined: Fri Aug 14, 2009 11:02 am
Location: Mount Maunganui, Tauranga

Re: Converting a database to run on Linux

Postby allistar » Wed Oct 20, 2010 11:24 am

So long as the package requirements are met, then most any Linux distribution should work. I have installed previous versions of Jade on Gentoo Linux before and it worked fine. The only thing different is you need to break open the rpms and run the installer manually. The most arduous part of getting a large Jade system running on Linux is porting external libraries and external applications that use the JOMAPI that need be run on the Linux server.

User avatar
Dino
Posts: 49
Joined: Wed Jun 24, 2009 6:55 am
Location: London
Contact:

Re: Converting a database to run on Linux

Postby Dino » Wed Oct 20, 2010 1:02 pm

This is to advise that support for all distributions of Linux is currently under review for JADE 7. If you're considering a move to JADE on Linux, or if you have any questions about this review, please get in touch with us at jadesupport@jadeworld.com.

Dean.

User avatar
Dino
Posts: 49
Joined: Wed Jun 24, 2009 6:55 am
Location: London
Contact:

Re: Converting a database to run on Linux

Postby Dino » Tue Dec 21, 2010 11:55 am

Further to my previous post, this is to confirm that support for Linux will end with JADE 6.3 (supported until April 2014).

JADE 7.0 (due for release in August 2011) will support Windows only.

If you have any questions about this, please get in touch with us at jadesupport@jadeworld.com.

Dean.

@CooperDino

murray
Posts: 144
Joined: Fri Aug 14, 2009 6:58 pm
Location: New Plymouth, New Zealand

Re: Converting a database to run on Linux

Postby murray » Tue Dec 21, 2010 12:16 pm

Further to my previous post, this is to confirm that support for Linux will end with JADE 6.3 (supported until April 2014).

JADE 7.0 (due for release in August 2011) will support Windows only.

Dean.
You should probably update the Jade 6 website page then...
quote: "For Windows and Linux, JADE makes computer systems easier to program"
Murray (N.Z.)

User avatar
Dino
Posts: 49
Joined: Wed Jun 24, 2009 6:55 am
Location: London
Contact:

Re: Converting a database to run on Linux

Postby Dino » Tue Dec 21, 2010 12:22 pm

You're quite right, Murray. The web site will be updated ahead of the JADE 7 release.

We just wanted to put this post up now to announce the decision given that we said we were reviewing it.

Dean.

@CooperDino


Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 13 guests