Building modharbour with ADS on Linux

[reinaldocrespo]

Hello ModHarbourers;

Wishing to experiment more with ModHarabour, I have setup an old computer with Fedora server + Apache + PHP 8.2. Apache and PHP are working fine.

I have <git> cloned mod_harbour from GitHub.com/fivetechsoft/mod_harbour.git and Harbour from GitHub.com/vszakats/harbour-core.git. (1)-- Or should I git clone from somewhere else?

I hear some chatter about "Mercury". (2)-- Is this a mod_harbour replacement or something I should be aware of?

(3) -- And; before I build modharbour from its sources I want to make sure support for ADS is included and I need help with that. Will I need to download ADS .so from somewhere or are also built from source? How?

(4) -- Should I desist on building Modharbour for Fedora Linux and build a Windows Server instead?

Thank you.

Reinaldo.

[Otto]

Hello Reinaldo,
These are good news.
I think most people here are Windows programmers, and it would benefit the community more if you build your server on Windows.
But maybe I'm wrong.
Best regards,
Otto

[Antonio Linares]

Dear Reinaldo,

You should git clone Harbour from https://github.com/harbour/core

If you need ADS support, then you have to build Harbour with ADS support. I will provide you detailed instructions about this in a next post.

Linux version is much faster than the Windows version, anyhow I encorage you to test it for yourself and compare response times.

Also, there is a mod_harbour 3.0 version in the repo that has been reported to be the fastest version. Again, you should test it for yourself and
compare your results.

Charly (Carles Aubia) may provide you the right information about "Mercury". It is an addon for mod_harbour.

[Antonio Linares]

This way you build Harbour using ADS:

SET HB_WITH_ADS=your_path_to_ADS_include

[reinaldocrespo]

Thank you Otto and thank you Antonio;

I decided I will setup a Windows server as well as the Linux server both running Apache.

I'm always busy with many things but expect to spend some time testing Mod_harbour and PHP accessing ADS tables.

I'm fully aware we are on our own when it comes to ADS but it works soooooo well... Damn frkng SAP.

R.

[giuliano]

Hi Reinaldo,
here my experience using mod_harbour + ADS on Linux

I have been using mod harbour + ADS in a Linux machine for 2 years .
It's faster, stable and easy to maintain/config .
I use also Postgres driver to connect on particular Database . It's fast and stable.
If you want some help don't esitate to contact me here in the forum or via mail .
I think the only limitation now is ADS support . I use ADS 11 release .
I agree with you . ADS works well well well ... Mod_Harbour too .

Thanks to Antonio and all the modharbour team.

Giuliano

[Lailton]

Hi Giuliano,

Do you still using ADS with Linux?
I would like to try it on Linux Debian, do you think that is it compatible?
Are there an email or skype to contact you ( if possible )?

Thank you

Hi Reinaldo,
here my experience using mod_harbour + ADS on Linux

I have been using mod harbour + ADS in a Linux machine for 2 years .
It's faster, stable and easy to maintain/config .
I use also Postgres driver to connect on particular Database . It's fast and stable.
If you want some help don't esitate to contact me here in the forum or via mail .
I think the only limitation now is ADS support . I use ADS 11 release .
I agree with you . ADS works well well well ... Mod_Harbour too .

Thanks to Antonio and all the modharbour team.

Giuliano

[giuliano]

Hi Lailton ,
i'm using ADS client on Linux machine ( Ubuntu distrib. ) .
My apps connect to ADS SERVER 11 release install on Windows Server-
I use it with Harbour applications and MOD_HARBOUR web site .
Both applications are faster, stable and easy to maintain/config .
I think all of this is compatible with Debian distrib.

Bye

[Lailton]

Nice!

Can you tell me where can I download lib necessary to build?

can you share an example doing the connection and an while?

thank you

Hi Lailton ,
i'm using ADS client on Linux machine ( Ubuntu distrib. ) .
My apps connect to ADS SERVER 11 release install on Windows Server-
I use it with Harbour applications and MOD_HARBOUR web site .
Both applications are faster, stable and easy to maintain/config .
I think all of this is compatible with Debian distrib.

Bye

[giuliano]

Hi Laiton,
you need for Harbour application or Mod_Harbour application ?

Bye

[Lailton]

I need it for harbour

[giuliano]

Hi Laiton , Sorry for the delay .
I was away for a week.

These are my step to use ADS client with Harbour in Linux OS:

1) Download from GitHub current release of Harbour and clone it in a new folder of your filesystem

git clone https://github.com/harbour/core harbour

2) Install ADS driver

apt-get install perl (if perl not present)

Download ADS driver from advantage website – (no longer available …???)
I use ADS 11 server release – I’ve download ADS driver for Linux many years ago.
Copy driver (tar file or folder already decompressed) into Linux machine and install it with default values (only select correct language). Move in Aceapi (ADS) folder and try:
chmod +x setup.pl
./setup.pl

3) Config. and Make Harbour

Install GCC (if not present): apt-get install gcc
Install MAKE (if not present): apt-get install make
Install libcurl-devel: apt-get install libcurl4-openssl-dev
Install openssl: apt-get install libssl-dev

Move in Harbour folder and digit:

export HB_WITH_PCRE=local
export HB_USER_CFLAGS="-fPIC"
export HB_WITH_CURL=/usr/include
export HB_WITH_OPENSSL=yes
export HB_BUILD_CONTRIBS=

make
make install

Now you’re ready to build a simple prg to connect ADS SERVER

Bye

[Lailton]

No problem Giuliano, Thanks for the reply.

I was looking for the download ADS but like you said the download is no longer available.

[giuliano]

Hi Laiton,
what version of ADS are you using ?

Bye

[Lailton]

It is the version "Advantage 11.10"