Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 14 total
Thread Database System Utility unable to connect to DB Server
Thu, May 3 2012 4:37 AMPermanent Link

Mathias Burbach

Hello Folks!

I have inherited a Delphi 5 project, that I need to move forward to Delphi XE2. I purchased DBISAM VCL Standard with Source Code and installed it into a fresh virtual machine with Delphi XE2. I then copied over the dbsrvr.ini from teh old Delphi 5 install (it includes a different port & encryption password), changed the settings of Database System Utility to try to connect on the different port. But when I now try to connect to the "remote server" on 127.0.0.1 via "Remote (Client/Server)" the label says "Remote (Client/Server) - Not available" and any attempt to choose the radio box "Remote (Client/Server)" will fail.

What do I need to do to get Database System Utility to connect remotely to the re-configured dbsrvr.exe?

Thanks for a short answer in advance.

Salut,
 Mathias



Attachments: Remote.PNG
Thu, May 3 2012 4:47 AMPermanent Link

Mathias Burbach

Mathias Burbach wrote:

Hello Folks!

I have inherited a Delphi 5 project, that I need to move forward to Delphi XE2. I purchased DBISAM VCL Standard with Source Code and installed it into a fresh virtual machine with Delphi XE2. I then copied over the dbsrvr.ini from teh old Delphi 5 install (it includes a different port & encryption password), changed the settings of Database System Utility to try to connect on the different port. But when I now try to connect to the "remote server" on 127.0.0.1 via "Remote (Client/Server)" the label says "Remote (Client/Server) - Not available" and any attempt to choose the radio box "Remote (Client/Server)" will fail. The login dialogue does not show up in order to connect to the "remote server".

What do I need to do to get Database System Utility to connect remotely to the re-configured dbsrvr.exe?

Thanks for a short answer in advance.

Salut,
 Mathias
Thu, May 3 2012 8:49 AMPermanent Link

Raul

Team Elevate Team Elevate

Mathias,

You need to go to the settings (File->Options->Remote tab) and enter the
IP address for the server first (or use 127.0.0.1 if runnning on local
machine)

Raul

On 5/3/2012 4:37 AM, Mathias Burbach wrote:
> Hello Folks!
>
> I have inherited a Delphi 5 project, that I need to move forward to Delphi XE2. I purchased DBISAM VCL Standard with Source Code and installed it into a fresh virtual machine with Delphi XE2. I then copied over the dbsrvr.ini from teh old Delphi 5 install (it includes a different port&  encryption password), changed the settings of Database System Utility to try to connect on the different port. But when I now try to connect to the "remote server" on 127.0.0.1 via "Remote (Client/Server)" the label says "Remote (Client/Server) - Not available" and any attempt to choose the radio box "Remote (Client/Server)" will fail.
>
> What do I need to do to get Database System Utility to connect remotely to the re-configured dbsrvr.exe?
>
> Thanks for a short answer in advance.
>
> Salut,
>    Mathias
>
Thu, May 3 2012 11:35 AMPermanent Link

Mathias Burbach

Hello Raul,

thanks for your reply.

Raul wrote:
>Mathias,
>You need to go to the settings (File->Options->Remote tab) and enter the
>IP address for the server first (or use 127.0.0.1 if runnning on local
>machine)
That has been entered already (see attached screenshot).

Other settings that have been activated in dbsrvr.ini are:
* Server Description=XXX Database Server
* Server Address=127.0.0.1
* Server Port=12015
* Server Thread Cache Size=20
* Administration Address=127.0.0.1
* Administration Port=12016
* Administration Thread Cache Size=4
* Configuration Password=XXXXXXXX
* Encrypted Only=1
* Encryption Password=XXXXXXX
* No User Interface=0
* Append To Log=0
* Large File Support=0

There must be another reason why the Database System Utility doesn't want to connect "remotely".

Salut,
 Mathias



Attachments: DSU Remote Settings.PNG
Thu, May 3 2012 3:32 PMPermanent Link

Raul

Team Elevate Team Elevate


Can you clarify the "remote" part - your DBSRVR is set to listen on the
local loopback address (127.0.0.1) hence only way to connect to it is
from the same machine (you would not be able to connect remotely).

"Not available" usually indicates that dbsys could not connect to the
server over IP.

Are you using the dbsrvr that shipped with the DBISAM or is it the one
from D5 install? If so then any chance it's been customized (like custom
engine signature or such).

If it's the default dbsrvr as shipped by ElevateSoft then i would verify
that the dbsrvr is actually online and listening on local loopback IP
and port 12015 and double-check all your password settings

Raul

On 5/3/2012 11:35 AM, Mathias Burbach wrote:
> Hello Raul,
>
> thanks for your reply.
>
> Raul wrote:
>> Mathias,
>> You need to go to the settings (File->Options->Remote tab) and enter the
>> IP address for the server first (or use 127.0.0.1 if runnning on local
>> machine)
> That has been entered already (see attached screenshot).
>
> Other settings that have been activated in dbsrvr.ini are:
> * Server Description=XXX Database Server
> * Server Address=127.0.0.1
> * Server Port=12015
> * Server Thread Cache Size=20
> * Administration Address=127.0.0.1
> * Administration Port=12016
> * Administration Thread Cache Size=4
> * Configuration Password=XXXXXXXX
> * Encrypted Only=1
> * Encryption Password=XXXXXXX
> * No User Interface=0
> * Append To Log=0
> * Large File Support=0
>
> There must be another reason why the Database System Utility doesn't want to connect "remotely".
>
> Salut,
>    Mathias
>
Fri, May 4 2012 12:07 AMPermanent Link

Mathias Burbach

Hello Raul,

Thanks for your reply.

Raul wrote:
>Can you clarify the "remote" part - your DBSRVR is set to listen on the
>local loopback address (127.0.0.1) hence only way to connect to it is
>from the same machine (you would not be able to connect remotely).
Yes, I try to connect via 127.0.0.1 (see also attached screenshot of the Database System Utility settings).

>Are you using the dbsrvr that shipped with the DBISAM or is it the one
>from D5 install? If so then any chance it's been customized (like custom
>engine signature or such).
I have installed the latest version of DBISAM into a new virtual machine. I just copied the DBSRVR.ini from the virtual machine running Delphi 5, so that my new development environment is as close as possible to how it was with Delphi 5.

>If it's the default dbsrvr as shipped by ElevateSoft then i would verify
>that the dbsrvr is actually online and listening on local loopback IP
>and port 12015 and double-check all your password settings
Yes, it is. If I rename the DBSRVR.ini and run the server with the default settings (e.g. port 12005 and no forced encryption) I can connect successfully from Database System Utility. Something in the settings of DBSRVR.ini must cause that the Database System Utility doesn't find the "remote server" on the amended port any more and doesn't even show a login dialogue.

I am looking forward to any other suggestions you or the DBISAM user community might have.

Salut,
 Mathias
Fri, May 4 2012 12:17 AMPermanent Link

Mathias Burbach

I have removed the requirement to encrypt the communication (e.g. Encrypted Only=1 is now Encrypted Only=0) and the login dialogue appears. But I still cannot connect. If I try to connect with the Server Administration Utility I get the following error message:
"Error retrieving server information - DBISAM Engine Error # 11276 The connection to the database server at '127.0.0.1' has been lost"

Salut,
 Mathias
Fri, May 4 2012 5:36 AMPermanent Link

Mathias Burbach

Next attempt:
I have commented out all settings and started re-enabling them.

With all settings disabled I could connect.
I then enabled
* Server Description=XXXX Database Server
* Server Port=12015
* Administration Port=12016
* Administration Address=127.0.0.1
and still I could connect.

As soon as I enabled
* Encrypted Only=0
* Encryption Password=XXXYYYZZZ
the connection error occurred again:
"Error retrieving server information - DBISAM Engine Error # 11276 The connection to the database server at '127.0.0.1' has been lost"

There seems to be no way to add an encryption password to dbsys or srvadmin and even if the use of the encryption password is optional (e.g. Encrypted Only=0) the server seems to require it. Can I use the dbsys as provided in the install with a server, for which the transport encryption has been enabled?

Thanks for a short answer in advance.

Salut,
 Mathias
Fri, May 4 2012 6:27 AMPermanent Link

Mathias Burbach

Hello Folks!

The case is solved. My predecessor compiled a customised version of dbsys with the encryption password in the FormCreate event. I tried to do the same but it failed due to missing PAS files such as dbisamut.pas & dbisamct.pas. I only have a "DBISAM VCL Standard with Source Code" license. I take it this means I can't compile the server or the utility tools either.

Is there an upgrade path for my version to get to "DBISAM VCL Client-Server with Source Code"?

Salut,
 Mathias
Fri, May 4 2012 6:57 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mathias

>Is there an upgrade path for my version to get to "DBISAM VCL Client-Server with Source Code"?

email sales@elevatesoft.com for the answer to that.

Roy Lambert [Team Elevate]

Page 1 of 2Next Page »
Jump to Page:  1 2
Image