Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

adsserver.ini parameters

18 posts in Linux Last posting was on 2008-05-27 15:28:00.0Z
Dmitry Merkotan Posted on 2008-05-12 16:31:41.0Z
Date: Mon, 12 May 2008 19:31:41 +0300
Subject: adsserver.ini parameters
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r
MIME-Version: 1.0
Newsgroups: Advantage.Linux
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.ua1uu3uld1ppkq@fast.wgsoftpro.com>
User-Agent: Opera Mail/9.27 (Linux)
NNTP-Posting-Host: 89.162.137.146
X-Trace: 12 May 2008 10:25:55 -0700, 89.162.137.146
Lines: 34
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.162.137.146
Xref: solutions.advantagedatabase.com Advantage.Linux:1125
Article PK: 1130855

Hello!
We want to try Server Aliases on our ADS 8.10.0.2 on Linux.
We put the adsserver.ini file (all lower case letters) into the directory,
where ADS logs reside.
Now we have some questons:

1) what should we write in this file in case of Linux, because advantage
help gives Windows only examples. So is this notation right?:
[ServerAliases]
mydd = /mydir/dir1/dir2

2) is the need to restart ADS server on Linux or it re-reads this file
automatically?

3) what port should be assigned in ads.conf and open in firewall: IP_PORT
or INTERNET_PORT?
And are there any differences in working on local network or internet?
Which of these port is in use over localnet and internet?

Thanks!

--
Dmitry Merkotan
SoftPro system administrator
Ukraine


Jed Thomet Posted on 2008-05-13 14:54:52.0Z
Date: Tue, 13 May 2008 14:54:52 +0000 (UTC)
Message-ID: <6bf7df521074a8ca82ee245721af@devzone.advantagedatabase.com>
From: Jed Thomet <jedt_no_unrequested_emails_please@ianywhere.com>
Subject: Re: adsserver.ini parameters
Newsgroups: Advantage.Linux
References: <op.ua1uu3uld1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.106
X-Trace: 13 May 2008 08:49:04 -0700, 10.24.38.106
Lines: 63
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.106
Xref: solutions.advantagedatabase.com Advantage.Linux:1126
Article PK: 1130857

Hello Dmitry,

Here are some responses to help get you started:

> 1) what should we write in this file in case of Linux, because
> advantage
> help gives Windows only examples. So is this notation right?:
> [ServerAliases]
> mydd = /mydir/dir1/dir2

Absolutely correct. The paths would read as a filesystem path exactly as
the path would look if you were connected to the linux server.

> 2) is the need to restart ADS server on Linux or it re-reads this file
> automatically?

The server should automatically attempt to re-read the file periodically
(every 10 or 15 seconds, I believe), so no server restart should be necessary.

> 3) what port should be assigned in ads.conf and open in firewall:
> IP_PORT
> or INTERNET_PORT?
> And are there any differences in working on local network or internet?
> Which of these port is in use over localnet and internet?

If you are using Advantage via a Local Area Network, you should only need
to configure the IP_PORT value (and no firewall modifications need to be
made). If you want to give remote clients access to your server via the
Advantage Internet Server, you would configure the INTERNET_PORT value (make
sure you use different ports for the IP_PORT and INTERNET_PORT), and open
that port on your firewall. (In this case, your clients need to be configured
to make an Advantage Internet Server connection, and the client needs to
be configured with the IP address and Port number of the server, as we cannot
use "normal" server discovery for Internet connections.)

I hope this answers your questions.

Jed Thomet
Advantage R&D

> Hello!
> We want to try Server Aliases on our ADS 8.10.0.2 on Linux.
> We put the adsserver.ini file (all lower case letters) into the
> directory,
> where ADS logs reside.
> Now we have some questons:
> 1) what should we write in this file in case of Linux, because
> advantage
> help gives Windows only examples. So is this notation right?:
> [ServerAliases]
> mydd = /mydir/dir1/dir2
> 2) is the need to restart ADS server on Linux or it re-reads this file
> automatically?
>
> 3) what port should be assigned in ads.conf and open in firewall:
> IP_PORT
> or INTERNET_PORT?
> And are there any differences in working on local network or internet?
> Which of these port is in use over localnet and internet?
> Thanks!
>


Dmitry Merkotan Posted on 2008-05-14 13:40:15.0Z
Date: Wed, 14 May 2008 16:40:15 +0300
Subject: Re: adsserver.ini parameters
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r
MIME-Version: 1.0
Newsgroups: Advantage.Linux
References: <op.ua1uu3uld1ppkq@fast.wgsoftpro.com> <6bf7df521074a8ca82ee245721af@devzone.advantagedatabase.com>
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.ua5b9dbvd1ppkq@fast.wgsoftpro.com>
User-Agent: Opera Mail/9.27 (Linux)
NNTP-Posting-Host: 89.162.137.146
X-Trace: 14 May 2008 07:34:28 -0700, 89.162.137.146
Lines: 46
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.162.137.146
Xref: solutions.advantagedatabase.com Advantage.Linux:1127
Article PK: 1130859

On Tue, 13 May 2008 17:54:52 +0300, Jed Thomet

<jedt_no_unrequested_emails_please@ianywhere.com> wrote:

> Hello Dmitry,
>
> Here are some responses to help get you started:
>
>> 1) what should we write in this file in case of Linux, because
>> advantage
>> help gives Windows only examples. So is this notation right?:
>> [ServerAliases]
>> mydd = /mydir/dir1/dir2
>
> Absolutely correct. The paths would read as a filesystem path exactly
> as the path would look if you were connected to the linux server.
>

Hello!
But we still have an error 5004 upon trying to connect to data dictionary
from Windows client to Linux ADS server.
I've even restarted ADS to reread file adserver.ini.
There is some information in ADS help regarding this error message. It is
about Linux rights checking.
But when we try to connect not using this alias it works! It means that
this is not a user rights problem.
So, when using connection path like this:
\\server.localnet:7000\mydir\dir1\dir2\nameoftable.add
it works, but, when using connection path like this:
\\server.localnet:7000\mydd\nameoftable.add
it doesn't :(


--
Dmitry Merkotan
SoftPro system administrator
Ukraine


Jed Thomet Posted on 2008-05-14 16:33:34.0Z
Date: Wed, 14 May 2008 16:33:34 +0000 (UTC)
Message-ID: <6bf7df52107c28ca83c518b8db3b@devzone.advantagedatabase.com>
From: Jed Thomet <jedt_no_unrequested_emails_please@ianywhere.com>
Subject: Re: adsserver.ini parameters
Newsgroups: Advantage.Linux
References: <op.ua5b9dbvd1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.106
X-Trace: 14 May 2008 10:27:46 -0700, 10.24.38.106
Lines: 46
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.106
Xref: solutions.advantagedatabase.com Advantage.Linux:1128
Article PK: 1130863

Hello Dmitry,

Make sure that you disable rights-checking in your application. When using
a server-side alias, Rights Checking must always be disabled.

Also, just to make sure the server can open the adsserver.ini, double-check
the file owner/permissions on the adsserver.ini (and on the directory containing
the adsserver.ini as well).

Jed Thomet
Advantage R&D

> On Tue, 13 May 2008 17:54:52 +0300, Jed Thomet
> <jedt_no_unrequested_emails_please@ianywhere.com> wrote:
>
>> Hello Dmitry,
>>
>> Here are some responses to help get you started:
>>
>>> 1) what should we write in this file in case of Linux, because
>>> advantage
>>> help gives Windows only examples. So is this notation right?:
>>> [ServerAliases]
>>> mydd = /mydir/dir1/dir2
>> Absolutely correct. The paths would read as a filesystem path
>> exactly as the path would look if you were connected to the linux
>> server.
>>
> Hello!
> But we still have an error 5004 upon trying to connect to data
> dictionary
> from Windows client to Linux ADS server.
> I've even restarted ADS to reread file adserver.ini.
> There is some information in ADS help regarding this error message. It
> is
> about Linux rights checking.
> But when we try to connect not using this alias it works! It means
> that
> this is not a user rights problem.
> So, when using connection path like this:
> \\server.localnet:7000\mydir\dir1\dir2\nameoftable.add
> it works, but, when using connection path like this:
> \\server.localnet:7000\mydd\nameoftable.add
> it doesn't :(


Dmitry Merkotan Posted on 2008-05-15 07:45:21.0Z
Date: Thu, 15 May 2008 10:45:21 +0300
Subject: Re: adsserver.ini parameters
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r
MIME-Version: 1.0
Newsgroups: Advantage.Linux
References: <op.ua5b9dbvd1ppkq@fast.wgsoftpro.com> <6bf7df52107c28ca83c518b8db3b@devzone.advantagedatabase.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.ua6qhvkpd1ppkq@fast.wgsoftpro.com>
User-Agent: Opera Mail/9.27 (Linux)
NNTP-Posting-Host: 89.162.137.146
X-Trace: 15 May 2008 01:39:35 -0700, 89.162.137.146
Lines: 39
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.162.137.146
Xref: solutions.advantagedatabase.com Advantage.Linux:1129
Article PK: 1130864

On Wed, 14 May 2008 19:33:34 +0300, Jed Thomet

<jedt_no_unrequested_emails_please@ianywhere.com> wrote:

> Hello Dmitry,
>
> Make sure that you disable rights-checking in your application. When
> using a server-side alias, Rights Checking must always be disabled.
> Also, just to make sure the server can open the adsserver.ini,
> double-check the file owner/permissions on the adsserver.ini (and on the
> directory containing the adsserver.ini as well).
>

Hello Jed!

I try to connect to my data dictionary through ARC32.
In the data dictionary properties/security tab "Check user rights" is
unchecked.
And in connection properties "Security Mode" is set to ignorerights.
Is that enough for this?

In my case all ADS stuff (server itself, configs, logfiles) is located in
one directory: /advantage.
So it is easy to control user rights for this.
User and group "advantage" are owners of all files and directories within
/advantage.
And adsserver.ini file rights are set to 644.

Jed, have you tested server-side alias feature on Linux?
Can you post here your working example of adsserver.ini and the path to
your database files on Linux?
Also what database properties should be set and what is your connection
string?

Thanks.

--
Dmitry Merkotan
SoftPro system administrator
Ukraine


Jed Thomet Posted on 2008-05-15 15:29:22.0Z
Date: Thu, 15 May 2008 15:29:22 +0000 (UTC)
Message-ID: <6bf7df521083b8ca84854b1cc1b7@devzone.advantagedatabase.com>
From: Jed Thomet <jedt_no_unrequested_emails_please@ianywhere.com>
Subject: Re: adsserver.ini parameters
Newsgroups: Advantage.Linux
References: <op.ua6qhvkpd1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.106
X-Trace: 15 May 2008 09:23:34 -0700, 10.24.38.106
Lines: 72
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.106
Xref: solutions.advantagedatabase.com Advantage.Linux:1131
Article PK: 1130865

Hello Dmitry,

Yes, I have tested server-side aliases on Linux. (Our test suite has several
tests for Server-Side aliases that are run against an Advantage server on
Linux -- so the feature has been tested.) Here is the contents of one of
our adsserver.ini files from a Linux server:

[ServerAliases]
pupunc=/test_drive/w28p1
notshareddrive=/test_drive/aliastest/

In this case, the client would connect using any of these paths:
\\ys\pupunc\
\\ys:6262\pupunc\
\\ys\notshareddrive\
\\ys:6262\notshareddrive\
(Here, the server's name is "YS", and the configured IP_PORT for Advantage
is 6262.)

I looked back at the setup that you posted and your connectoin paths. I
don't see any obvious differences. So, let's take a step back from the problem
and try something slightly simpler. Do you have any free tables (tables
that are not bound to the data dictionary you are attempting to connect to)
in the same directory? (If not, please create a free table in this directory
for testing.) Once you have a free table in that directory, see if you can
make a (free table) connection to \\server.localnet:7000\mydd\ and see if
you can open your free table through this connection. (Again, make sure
the security setting in your connection in ARC has the SecurityMode set to
"IgnoreRights".) Let me know if this works. If it does not, post what error(s)
you receive. (And, if you receive any errors, look in your error log to
see if there is any additional information logged there.)

Jed Thomet
Advantage R&D

> On Wed, 14 May 2008 19:33:34 +0300, Jed Thomet
> <jedt_no_unrequested_emails_please@ianywhere.com> wrote:
>
>> Hello Dmitry,
>>
>> Make sure that you disable rights-checking in your application. When
>> using a server-side alias, Rights Checking must always be disabled.
>> Also, just to make sure the server can open the adsserver.ini,
>> double-check the file owner/permissions on the adsserver.ini (and on
>> the directory containing the adsserver.ini as well).
>>
> Hello Jed!
>
> I try to connect to my data dictionary through ARC32.
> In the data dictionary properties/security tab "Check user rights" is
> unchecked.
> And in connection properties "Security Mode" is set to ignorerights.
> Is that enough for this?
> In my case all ADS stuff (server itself, configs, logfiles) is located
> in
> one directory: /advantage.
> So it is easy to control user rights for this.
> User and group "advantage" are owners of all files and directories
> within
> /advantage.
> And adsserver.ini file rights are set to 644.
> Jed, have you tested server-side alias feature on Linux?
> Can you post here your working example of adsserver.ini and the path
> to
> your database files on Linux?
> Also what database properties should be set and what is your
> connection
> string?
> Thanks.
>


Dmitry Merkotan Posted on 2008-05-16 15:38:32.0Z
Date: Fri, 16 May 2008 18:38:32 +0300
Subject: Re: adsserver.ini parameters
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r
MIME-Version: 1.0
Newsgroups: Advantage.Linux
References: <op.ua6qhvkpd1ppkq@fast.wgsoftpro.com> <6bf7df521083b8ca84854b1cc1b7@devzone.advantagedatabase.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.ua862insd1ppkq@fast.wgsoftpro.com>
User-Agent: Opera Mail/9.27 (Linux)
NNTP-Posting-Host: 89.162.137.146
X-Trace: 16 May 2008 09:32:45 -0700, 89.162.137.146
Lines: 35
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.162.137.146
Xref: solutions.advantagedatabase.com Advantage.Linux:1132
Article PK: 1130874

On Thu, 15 May 2008 18:29:22 +0300, Jed Thomet

<jedt_no_unrequested_emails_please@ianywhere.com> wrote:

> Hello Dmitry,
>
> I looked back at the setup that you posted and your connectoin paths. I
> don't see any obvious differences. So, let's take a step back from the
> problem and try something slightly simpler. Do you have any free tables
> (tables that are not bound to the data dictionary you are attempting to
> connect to) in the same directory? (If not, please create a free table
> in this directory for testing.) Once you have a free table in that
> directory, see if you can make a (free table) connection to
> \\server.localnet:7000\mydd\ and see if you can open your free table
> through this connection. (Again, make sure the security setting in your
> connection in ARC has the SecurityMode set to "IgnoreRights".) Let me
> know if this works. If it does not, post what error(s) you receive.
> (And, if you receive any errors, look in your error log to see if there
> is any additional information logged there.)
>

Hello Jed!
I've put a table mytable.dbf in my testing directory and try to open it
(ctrl-O) in ARC32.
I've got en error 7041 - file not found in ARC32 and the same in logfile
ads_err.adt:
7041 /mydd/mytable.dbf

If I use full directory path name to my table - it works fine.
I think ADS server ignores adsserver.ini file and tries to open
/mydd/mytable.dbf in my Linux directory structure.

--
Dmitry Merkotan
SoftPro system administrator
Ukraine


Jed Thomet Posted on 2008-05-19 19:31:08.0Z
Date: Mon, 19 May 2008 19:31:08 +0000 (UTC)
Message-ID: <6bf7df52109738ca87cbbae0f08d@devzone.advantagedatabase.com>
From: Jed Thomet <jedt_no_unrequested_emails_please@ianywhere.com>
Subject: Re: adsserver.ini parameters
Newsgroups: Advantage.Linux
References: <op.ua862insd1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.106
X-Trace: 19 May 2008 13:25:18 -0700, 10.24.38.106
Lines: 50
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.106
Xref: solutions.advantagedatabase.com Advantage.Linux:1135
Article PK: 1130879

Hello Dmitry,

It looks like you are correct: The server is not using the alias configured
in the adsserver.ini file. If the server were using the alias you'd configured,
the 7041 error would be logged using the full path to the table (/mydir/dir1/dir2/mytable.db).


At this point, from everything you've posted, I would expect it to be working...
Do you have any 7032 ("Error in Advantage configuration parameter/value/data")
errors in your error log after restarting the server or modifying the adsserver.ini
file? Also, one other thing you may try would be to upgrade the server
to 8.10.0.26 (the latest service update). It is possible that a related
bugfix may have addressed the symptoms you are seeing.

Jed Thomet
Advantage R&D

> On Thu, 15 May 2008 18:29:22 +0300, Jed Thomet
> <jedt_no_unrequested_emails_please@ianywhere.com> wrote:
>
>> Hello Dmitry,
>>
>> I looked back at the setup that you posted and your connectoin paths.
>> I don't see any obvious differences. So, let's take a step back
>> from the problem and try something slightly simpler. Do you have
>> any free tables (tables that are not bound to the data dictionary
>> you are attempting to connect to) in the same directory? (If not,
>> please create a free table in this directory for testing.) Once you
>> have a free table in that directory, see if you can make a (free
>> table) connection to \\server.localnet:7000\mydd\ and see if you can
>> open your free table through this connection. (Again, make sure the
>> security setting in your connection in ARC has the SecurityMode set
>> to "IgnoreRights".) Let me know if this works. If it does not,
>> post what error(s) you receive. (And, if you receive any errors,
>> look in your error log to see if there is any additional information
>> logged there.)
>>
> Hello Jed!
> I've put a table mytable.dbf in my testing directory and try to open
> it
> (ctrl-O) in ARC32.
> I've got en error 7041 - file not found in ARC32 and the same in
> logfile
> ads_err.adt:
> 7041 /mydd/mytable.dbf
> If I use full directory path name to my table - it works fine.
> I think ADS server ignores adsserver.ini file and tries to open
> /mydd/mytable.dbf in my Linux directory structure.


Dmitry Merkotan Posted on 2008-05-20 14:46:29.0Z
Date: Tue, 20 May 2008 17:46:29 +0300
Subject: Re: adsserver.ini parameters
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r
MIME-Version: 1.0
Newsgroups: Advantage.Linux
References: <op.ua862insd1ppkq@fast.wgsoftpro.com> <6bf7df52109738ca87cbbae0f08d@devzone.advantagedatabase.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.ubgjbrm5d1ppkq@fast.wgsoftpro.com>
User-Agent: Opera Mail/9.27 (Linux)
NNTP-Posting-Host: 89.162.137.146
X-Trace: 20 May 2008 08:40:41 -0700, 89.162.137.146
Lines: 26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.162.137.146
Xref: solutions.advantagedatabase.com Advantage.Linux:1136
Article PK: 1130882

On Mon, 19 May 2008 22:31:08 +0300, Jed Thomet

<jedt_no_unrequested_emails_please@ianywhere.com> wrote:

> Hello Dmitry,
>
> Do you have any 7032 ("Error in Advantage configuration
> parameter/value/data") errors in your error log after restarting the
> server or modifying the adsserver.ini file? Also, one other thing you
> may try would be to upgrade the server to 8.10.0.26 (the latest service
> update). It is possible that a related bugfix may have addressed the
> symptoms you are seeing.

Hello Jed!
There are no any errors in error logs, even if I write incorrect path in
adsserver.ini.
Now I take another machine, another Linux (Fedora Core 8), the newest ADS
9.0.0.1, but have the same problem :(
What's wrong with me?
I've tested all possible variants of directory names, user rights to them,
alias names, ADS ports,
ADS installation dirs, ...

--
Dmitry Merkotan
SoftPro system administrator
Ukraine


Jed Thomet Posted on 2008-05-20 16:50:21.0Z
Date: Tue, 20 May 2008 16:50:21 +0000 (UTC)
Message-ID: <6bf7df52109fd8ca887e6f62b5c0@devzone.advantagedatabase.com>
From: Jed Thomet <jedt_no_unrequested_emails_please@ianywhere.com>
Subject: Re: adsserver.ini parameters
Newsgroups: Advantage.Linux
References: <op.ubgjbrm5d1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.106
X-Trace: 20 May 2008 10:44:31 -0700, 10.24.38.106
Lines: 52
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.106
Xref: solutions.advantagedatabase.com Advantage.Linux:1137
Article PK: 1130887

Hello Dmitry,

I suspect that the server is not reading the adsserver.ini correctly (or
that it's trying to read the file in a directory different from where it
exists). Here are a few general things to verify: Try making a management
connection to your server in ARC ("Tools" -> "Remote Server Info"). Click
on the "Configuration Parameters" tab, then the "Not Affecting Memory" tab.
Make sure that the adsserver.ini file exists in the path indicated by the
"Error Log and Assert Log Path". And, as before, double-check the owner/permissions
on this directory and the file. And, double check that the filename is all
lowercase.

Second, I'd like to see if we can get the server to log an error when reading/parsing
the adsserver.ini file. (Your attempt at putting an incorrect path in there
was a good idea. Unfortunately, we don't validate the path when reading
the file, so this wouldn't make the server log an error.) Here are two possible
alias entries that should generate an error: "alias" and "alias=". These
alias entries don't match the format we expect, so they should log an error.
(Also, any alias where either the alias name or the path is more than 260
characters should generate an error.) If we can get the server to log an
error, then we know that the adsserver.ini is in the correct location, and
that the server is attempting to read it.

Jed Thomet
Advantage R&D

> On Mon, 19 May 2008 22:31:08 +0300, Jed Thomet
> <jedt_no_unrequested_emails_please@ianywhere.com> wrote:
>
>> Hello Dmitry,
>>
>> Do you have any 7032 ("Error in Advantage configuration
>> parameter/value/data") errors in your error log after restarting the
>> server or modifying the adsserver.ini file? Also, one other thing
>> you may try would be to upgrade the server to 8.10.0.26 (the latest
>> service update). It is possible that a related bugfix may have
>> addressed the symptoms you are seeing.
>>
> Hello Jed!
> There are no any errors in error logs, even if I write incorrect path
> in
> adsserver.ini.
> Now I take another machine, another Linux (Fedora Core 8), the newest
> ADS
> 9.0.0.1, but have the same problem :(
> What's wrong with me?
> I've tested all possible variants of directory names, user rights to
> them,
> alias names, ADS ports,
> ADS installation dirs, ...


Joachim Duerr (ADS) Posted on 2008-05-21 12:45:36.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: adsserver.ini parameters
Newsgroups: Advantage.Linux
References: <op.ubgjbrm5d1ppkq@fast.wgsoftpro.com> <6bf7df52109fd8ca887e6f62b5c0@devzone.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.9
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <48340b60@solutions.advantagedatabase.com>
Date: 21 May 2008 05:45:36 -0700
X-Trace: 21 May 2008 05:45:36 -0700, 130.214.79.11
Lines: 25
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Linux:1138
Article PK: 1130890

Jed Thomet wrote in
<6bf7df52109fd8ca887e6f62b5c0@devzone.advantagedatabase.com>:

> I suspect that the server is not reading the adsserver.ini correctly
> (or that it's trying to read the file in a directory different from
> where it exists). Here are a few general things to verify: Try
> making a management connection to your server in ARC ("Tools" ->
> "Remote Server Info"). Click on the "Configuration Parameters" tab,
> then the "Not Affecting Memory" tab. Make sure that the
> adsserver.ini file exists in the path indicated by the "Error Log and
> Assert Log Path". And, as before, double-check the owner/permissions
> on this directory and the file. And, double check that the filename
> is all lowercase.

Jed,
one thing that came into my mind: Could it be that the section and
alias information stored in the adsserver.ini file is case sensitive?
I've never tested that with linux, but I've seen in the initial post
that Dmitry uses [ServerAliases] sectionname.

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com


Dmitry Merkotan Posted on 2008-05-23 12:56:11.0Z
Date: Fri, 23 May 2008 15:56:11 +0300
Subject: Re: adsserver.ini parameters
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r
MIME-Version: 1.0
Newsgroups: Advantage.Linux
References: <op.ubgjbrm5d1ppkq@fast.wgsoftpro.com> <6bf7df52109fd8ca887e6f62b5c0@devzone.advantagedatabase.com>
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.ublx7xasd1ppkq@fast.wgsoftpro.com>
User-Agent: Opera Mail/9.27 (Linux)
NNTP-Posting-Host: 89.162.137.146
X-Trace: 23 May 2008 06:50:25 -0700, 89.162.137.146
Lines: 113
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.162.137.146
Xref: solutions.advantagedatabase.com Advantage.Linux:1139
Article PK: 1130892

On Tue, 20 May 2008 19:50:21 +0300, Jed Thomet
<jedt_no_unrequested_emails_please@ianywhere.com> wrote:

Hello Jed!

> I suspect that the server is not reading the adsserver.ini correctly (or
> that it's trying to read the file in a directory different from where it
> exists). Here are a few general things to verify: Try making a
> management connection to your server in ARC ("Tools" -> "Remote Server
> Info"). Click on the "Configuration Parameters" tab, then the "Not
> Affecting Memory" tab. Make sure that the adsserver.ini file exists in
> the path indicated by the "Error Log and Assert Log Path". And, as
> before, double-check the owner/permissions on this directory and the
> file. And, double check that the filename is all lowercase.

Yes, I've checked that many times. All paths and rights are fine.

> Second, I'd like to see if we can get the server to log an error when
> reading/parsing the adsserver.ini file. (Your attempt at putting an
> incorrect path in there was a good idea. Unfortunately, we don't
> validate the path when reading the file, so this wouldn't make the
> server log an error.) Here are two possible alias entries that should
> generate an error: "alias" and "alias=". These alias entries don't
> match the format we expect, so they should log an error. (Also, any
> alias where either the alias name or the path is more than 260
> characters should generate an error.) If we can get the server to log
> an error, then we know that the adsserver.ini is in the correct
> location, and that the server is attempting to read it.

Now adsserver.ini file works on my machine with new Linux, both ADS 8.1
and 9.0 versions!
I don't know why it began to work.
All configs and user rights are the same as were.
Then I've taken a paper and a pen and began to test ADS for some
parameters and write down the results.
I've tested it upon different tcp/ip ports, does it reread ini file, who
is the owner of ini file, who is the owner of database, long file and
directory names of database files and alias name, if there are any "." and
"_" symbols in directory and file names, if ADS is installed in default
location or in /advantage...
It passed all tests!
I've only found one difference from Windows version of ADS: ADS for
Windows correctly understands an alias when there are spaces around the
"=", but ADS for Linux does not!
For example, ADS for Linux can't understand such an alias:
mydb = /mybase/common
So there must be no spaces near the equal sign for Linux ADS.


But ADS on my old Linux still does not work.
I've tried to update it to the newest 8.1 version, but that version
already want "glibc 2.3.2 or greater and kernel version 2.4 or greater".
So I still have 8.10.0.2 now.
As you suggested I tried to make a long alias name (270 chars) and there
are no any errors in logs (on new Linux machine there were errors 7032).
So it really looks like my ADS doesn't read adsserver.ini.


Joachim, now my new test Linux machine works fine with [ServerAliases]
statement in ini file. So it is not a cause.
But my old machine doesn't work neither such way nor another.

--
Dmitry Merkotan
SoftPro system administrator
Ukraine


Jed Thomet Posted on 2008-05-23 17:05:09.0Z
Date: Fri, 23 May 2008 17:05:09 +0000 (UTC)
Message-ID: <6bf7df5210b408ca8adbffe2d4dc@devzone.advantagedatabase.com>
From: Jed Thomet <jedt_no_unrequested_emails_please@ianywhere.com>
Subject: Re: adsserver.ini parameters
Newsgroups: Advantage.Linux
References: <op.ublx7xasd1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.106
X-Trace: 23 May 2008 10:59:19 -0700, 10.24.38.106
Lines: 111
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.106
Xref: solutions.advantagedatabase.com Advantage.Linux:1140
Article PK: 1130893

Hello Dmitry,

I'm glad to hear you've got it working on one box.

> I've only found one difference from Windows version of ADS: ADS for
> Windows correctly understands an alias when there are spaces around
> the
> "=", but ADS for Linux does not!
> For example, ADS for Linux can't understand such an alias:
> mydb = /mybase/common

That is a bug. We currently interpret both the alias and the path literally.
So, if you pass in a path of "\\server.localnet:7000\mydb \" (note the space
following "mydb"), ADS will look for a directory named " /mybase/common"
(note the preceding space). Of course, due to the preceding space, that's
not a valid filesystem path. I will look at getting that fixed.

> But ADS on my old Linux still does not work.
> I've tried to update it to the newest 8.1 version, but that version
> already want "glibc 2.3.2 or greater and kernel version 2.4 or
> greater".

The latest 8.1 version only requires glibc 2.1.2-11 or greater and kernel
version 2.2 or greater. (It's ADS 9.0 that requires the 2.4 kernel.) So,
you should still be able to upgrade to ADS 8.10.0.26.

> As you suggested I tried to make a long alias name (270 chars) and
> there
> are no any errors in logs (on new Linux machine there were errors
> 7032).
> So it really looks like my ADS doesn't read adsserver.ini.

If ADS isn't logging errors when reading the invalid paths, then ADS must
be looking for the file in a different location than it exists in. Just
to verify that I wasn't forgetting about anything, I fired up ADS 8.10.0.2
on one of our older Linux boxes. Everything works without a hitch... I
am pretty sure that this has to be something specific to the configuration
of the older Linux box you're working with now. How old is this box? What
version/distribution of Linux is it running? Also, what version is the kernel?

Jed Thomet
Advantage R&D

> On Tue, 20 May 2008 19:50:21 +0300, Jed Thomet
> <jedt_no_unrequested_emails_please@ianywhere.com> wrote:
>
> Hello Jed!
>
>> I suspect that the server is not reading the adsserver.ini correctly
>> (or that it's trying to read the file in a directory different from
>> where it exists). Here are a few general things to verify: Try
>> making a management connection to your server in ARC ("Tools" ->
>> "Remote Server Info"). Click on the "Configuration Parameters" tab,
>> then the "Not Affecting Memory" tab. Make sure that the
>> adsserver.ini file exists in the path indicated by the "Error Log
>> and Assert Log Path". And, as before, double-check the
>> owner/permissions on this directory and the file. And, double check
>> that the filename is all lowercase.
>>
> Yes, I've checked that many times. All paths and rights are fine.
>
>> Second, I'd like to see if we can get the server to log an error when
>> reading/parsing the adsserver.ini file. (Your attempt at putting an
>> incorrect path in there was a good idea. Unfortunately, we don't
>> validate the path when reading the file, so this wouldn't make the
>> server log an error.) Here are two possible alias entries that
>> should generate an error: "alias" and "alias=". These alias entries
>> don't match the format we expect, so they should log an error.
>> (Also, any alias where either the alias name or the path is more
>> than 260 characters should generate an error.) If we can get the
>> server to log an error, then we know that the adsserver.ini is in
>> the correct location, and that the server is attempting to read it.
>>
> Now adsserver.ini file works on my machine with new Linux, both ADS
> 8.1
> and 9.0 versions!
> I don't know why it began to work.
> All configs and user rights are the same as were.
> Then I've taken a paper and a pen and began to test ADS for some
> parameters and write down the results.
> I've tested it upon different tcp/ip ports, does it reread ini file,
> who
> is the owner of ini file, who is the owner of database, long file and
> directory names of database files and alias name, if there are any "."
> and
> "_" symbols in directory and file names, if ADS is installed in
> default
> location or in /advantage...
> It passed all tests!
> I've only found one difference from Windows version of ADS: ADS for
> Windows correctly understands an alias when there are spaces around
> the
> "=", but ADS for Linux does not!
> For example, ADS for Linux can't understand such an alias:
> mydb = /mybase/common
> So there must be no spaces near the equal sign for Linux ADS.
> But ADS on my old Linux still does not work.
> I've tried to update it to the newest 8.1 version, but that version
> already want "glibc 2.3.2 or greater and kernel version 2.4 or
> greater".
> So I still have 8.10.0.2 now.
> As you suggested I tried to make a long alias name (270 chars) and
> there
> are no any errors in logs (on new Linux machine there were errors
> 7032).
> So it really looks like my ADS doesn't read adsserver.ini.
> Joachim, now my new test Linux machine works fine with [ServerAliases]
> statement in ini file. So it is not a cause.
> But my old machine doesn't work neither such way nor another.


Dmitry Merkotan Posted on 2008-05-24 12:12:28.0Z
Date: Sat, 24 May 2008 15:12:28 +0300
Subject: Re: adsserver.ini parameters
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r
MIME-Version: 1.0
Newsgroups: Advantage.Linux
References: <op.ublx7xasd1ppkq@fast.wgsoftpro.com> <6bf7df5210b408ca8adbffe2d4dc@devzone.advantagedatabase.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.ubnqu2pfd1ppkq@fast.wgsoftpro.com>
User-Agent: Opera Mail/9.27 (Linux)
NNTP-Posting-Host: 89.162.137.146
X-Trace: 24 May 2008 06:06:39 -0700, 89.162.137.146
Lines: 28
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.162.137.146
Xref: solutions.advantagedatabase.com Advantage.Linux:1141
Article PK: 1130898

On Fri, 23 May 2008 20:05:09 +0300, Jed Thomet
<jedt_no_unrequested_emails_please@ianywhere.com> wrote:

Hello Jed!

> The latest 8.1 version only requires glibc 2.1.2-11 or greater and
> kernel version 2.2 or greater. (It's ADS 9.0 that requires the 2.4
> kernel.) So, you should still be able to upgrade to ADS 8.10.0.26.
>

I've done with ADS upgrading on that machine and now it is 8.10.0.26.

> How old is this box? What version/distribution of Linux is it running?
> Also, what version is the kernel?

It's an old Linux Red Hat 7.0, kernel 2.2.20.
But not a pure old system because of many fixes and updates were installed
since the beginning.

Anyway now after ADS version upgrading it works!!!
I've noticed only one bug - it still doesn't reread adsserver.ini file
upon working.
Only ADS restart helps.

--
Dmitry Merkotan
SoftPro system administrator
Ukraine


Jed Thomet Posted on 2008-05-27 15:28:00.0Z
Date: Tue, 27 May 2008 15:28:00 +0000 (UTC)
Message-ID: <6bf7df5210d1a8ca8df317377a4c@devzone.advantagedatabase.com>
From: Jed Thomet <jedt_no_unrequested_emails_please@ianywhere.com>
Subject: Re: adsserver.ini parameters
Newsgroups: Advantage.Linux
References: <op.ubnqu2pfd1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.106
X-Trace: 27 May 2008 09:22:12 -0700, 10.24.38.106
Lines: 35
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.106
Xref: solutions.advantagedatabase.com Advantage.Linux:1142
Article PK: 1130902

Hello Dmitry,

It is good to hear that you have everything working now. I will look into
the server not re-reading the adsserver.ini file without restarting ADS.
(As long as the file exists before ADS is loaded, the server should automatically
reload the file any time the file is modified.)


Jed Thomet
Advantage R&D

> On Fri, 23 May 2008 20:05:09 +0300, Jed Thomet
> <jedt_no_unrequested_emails_please@ianywhere.com> wrote:
>
> Hello Jed!
>
>> The latest 8.1 version only requires glibc 2.1.2-11 or greater and
>> kernel version 2.2 or greater. (It's ADS 9.0 that requires the 2.4
>> kernel.) So, you should still be able to upgrade to ADS 8.10.0.26.
>>
> I've done with ADS upgrading on that machine and now it is 8.10.0.26.
>
>> How old is this box? What version/distribution of Linux is it
>> running? Also, what version is the kernel?
>>
> It's an old Linux Red Hat 7.0, kernel 2.2.20.
> But not a pure old system because of many fixes and updates were
> installed
> since the beginning.
> Anyway now after ADS version upgrading it works!!!
> I've noticed only one bug - it still doesn't reread adsserver.ini file
> upon working.
> Only ADS restart helps.


Peter Rosario Posted on 2008-05-15 13:51:52.0Z
From: Peter Rosario <prosario@aibonline.org>
Subject: Re: adsserver.ini parameters
Date: Thu, 15 May 2008 08:51:52 -0500
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2008.05.15.13.51.51.407640@aibonline.org>
Newsgroups: Advantage.Linux
References: <op.ua5b9dbvd1ppkq@fast.wgsoftpro.com> <6bf7df52107c28ca83c518b8db3b@devzone.advantagedatabase.com> <op.ua6qhvkpd1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 64.6.140.2
X-Trace: 15 May 2008 07:45:59 -0700, 64.6.140.2
Lines: 20
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.6.140.2
Xref: solutions.advantagedatabase.com Advantage.Linux:1130
Article PK: 1130866

Dmitry:

Server-side aliases work great for me.

> Can you post here your working example of adsserver.ini and the path to
> your database files on Linux?

Here is the contents of my /var/log/advantage/adsserver.ini:

[ServerAliases]
FdLbl=/srv/ads/FdLbl

> Also what database properties should be set and what is your connection
> string?

Here is my ARC connection string:

//192.168.85.12:6262/FdLbl/FdLbl.add

Pete


Dmitry Merkotan Posted on 2008-05-16 15:40:55.0Z
Date: Fri, 16 May 2008 18:40:55 +0300
Subject: Re: adsserver.ini parameters
From: "Dmitry Merkotan" <comrad@wgsoftpro.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=koi8-r
MIME-Version: 1.0
Newsgroups: Advantage.Linux
References: <op.ua5b9dbvd1ppkq@fast.wgsoftpro.com> <6bf7df52107c28ca83c518b8db3b@devzone.advantagedatabase.com> <op.ua6qhvkpd1ppkq@fast.wgsoftpro.com> <pan.2008.05.15.13.51.51.407640@aibonline.org>
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.ua866h0hd1ppkq@fast.wgsoftpro.com>
User-Agent: Opera Mail/9.27 (Linux)
NNTP-Posting-Host: 89.162.137.146
X-Trace: 16 May 2008 09:35:07 -0700, 89.162.137.146
Lines: 36
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.162.137.146
Xref: solutions.advantagedatabase.com Advantage.Linux:1133
Article PK: 1130875

On Thu, 15 May 2008 16:51:52 +0300, Peter Rosario <prosario@aibonline.org>

wrote:

> Dmitry:
>
> Server-side aliases work great for me.
>
>> Can you post here your working example of adsserver.ini and the path to
>> your database files on Linux?
>
> Here is the contents of my /var/log/advantage/adsserver.ini:
>
> [ServerAliases]
> FdLbl=/srv/ads/FdLbl
>
>> Also what database properties should be set and what is your connection
>> string?
>
> Here is my ARC connection string:
>
> //192.168.85.12:6262/FdLbl/FdLbl.add
>

Hello Peter!
I see you use slashes instead of backslashes in your connection string.
And it works so?

--
Dmitry Merkotan
SoftPro system administrator
Ukraine


Peter Rosario Posted on 2008-05-19 13:48:46.0Z
From: Peter Rosario <prosario@aibonline.org>
Subject: Re: adsserver.ini parameters
Date: Mon, 19 May 2008 08:48:46 -0500
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2008.05.19.13.48.39.354719@aibonline.org>
Newsgroups: Advantage.Linux
References: <op.ua5b9dbvd1ppkq@fast.wgsoftpro.com> <6bf7df52107c28ca83c518b8db3b@devzone.advantagedatabase.com> <op.ua6qhvkpd1ppkq@fast.wgsoftpro.com> <pan.2008.05.15.13.51.51.407640@aibonline.org> <op.ua866h0hd1ppkq@fast.wgsoftpro.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 64.6.140.2
X-Trace: 19 May 2008 07:42:57 -0700, 64.6.140.2
Lines: 32
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.6.140.2
Xref: solutions.advantagedatabase.com Advantage.Linux:1134
Article PK: 1130878


On Fri, 16 May 2008 18:40:55 +0300, Dmitry Merkotan wrote:

> On Thu, 15 May 2008 16:51:52 +0300, Peter Rosario <prosario@aibonline.org>
> wrote:
>
>> Dmitry:
>>
>> Server-side aliases work great for me.
>>
>>> Can you post here your working example of adsserver.ini and the path to
>>> your database files on Linux?
>>
>> Here is the contents of my /var/log/advantage/adsserver.ini:
>>
>> [ServerAliases]
>> FdLbl=/srv/ads/FdLbl
>>
>>> Also what database properties should be set and what is your connection
>>> string?
>>
>> Here is my ARC connection string:
>>
>> //192.168.85.12:6262/FdLbl/FdLbl.add
>>
>
> Hello Peter!
> I see you use slashes instead of backslashes in your connection string.
> And it works so?

Yes. Whether with or without a data dictionary or with or without a
server-side alias, I have never used backslashes. I have, however, never
used local server (only remote server).