dbmaint user error in ASA replication using LTM and replication server

Hi all,

I have problem on using the ASA Replication Agent. Any help will be 
appreciated. Thanks.

I have installed SQL Anywhere 10.0.1 build 3559, and the Replication Agent 
Version 10.0.0.2465

I have tried the Tutorial of Replicate data using Replication Server of page 
937 to page 945  of the System Admin Guide of ASA 10 (dbdaen10.pdf).

When I try to start the LTM with the following command

dbltm -S PRIMELTM -C primeltm.cfg

The following error with Invalid user ID or password of dbmaint occurs (in 
DBLTM.log).
Based on the tutorial we kept dbmaint ID and password the same, and the same 
name and password was used in RS 'create connection' command. It is very 
simple and we try logging in successfully using isql.

We then try to use another user (muser as the create connection ... set 
username muser set password muser_ps) and the same error reported. Do anyone 
encourter the same problem before?

I. 2008-01-14 11:03:52. SQL Anywhere Replication Agent Version 10.0.0.2465
I. 2008-01-14 11:03:52.
I. 2008-01-14 11:03:52. Copyright ? 2002-2006, iAnywhere Solutions, Inc.
                        Portions copyright ? 1988-2006, Sybase, Inc.
I. 2008-01-14 11:03:52. All rights reserved. All unpublished rights 
reserved.
I. 2008-01-14 11:03:52.
I. 2008-01-14 11:03:52. This software contains confidential and trade secret 
information of
I. 2008-01-14 11:03:52. iAnywhere Solutions, Inc.
                        Use, duplication or disclosure of the software and 
documentation
I. 2008-01-14 11:03:52. by the U.S. Government is subject to restrictions 
set forth in a license
I. 2008-01-14 11:03:52. agreement between the Government and iAnywhere 
Solutions, Inc. or
I. 2008-01-14 11:03:52. other written agreement specifying the Government's 
rights to use the
I. 2008-01-14 11:03:52. software and any applicable FAR provisions, for 
example, FAR 52.227-19.
I. 2008-01-14 11:03:52.
I. 2008-01-14 11:03:52. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, 
CA 94568, USA
I. 2008-01-14 11:03:52.
I. 2008-01-14 11:03:52. Sybase Server-Library/15.0/P/PC 
Intel/BUILD1500-050/OPT/Tue Jul 12 15:32:18 2005
I. 2008-01-14 11:03:52. Configuration File: primeltm.cfg
I. 2008-01-14 11:03:52. LTM mode: batch LTL, continuous
I. 2008-01-14 11:03:52. LTM Started
I. 2008-01-14 11:03:52. Open Server "PRIMELTM" started
I. 2008-01-14 11:03:52. Negotiating LTL version: LTM version 700, Rep. 
Server version 600
I. 2008-01-14 11:03:53. Successfully connected to replication server 
'sample_rs' as user 'adm'
I. 2008-01-14 11:03:53. Maintenance user: 'dbmaint'
E. 2008-01-14 11:03:54. Invalid user ID or password
E. 2008-01-14 11:03:54. Shutdown caused by fatal error
I. 2008-01-14 11:03:54. Beginning LTM shutdown sequence and freeing 
resources
I. 2008-01-14 11:03:55. LTM Shutdown Complete





I. 2008-01-14 11:24:54. SQL Anywhere Replication Agent Version 10.0.0.2465
I. 2008-01-14 11:24:54.
I. 2008-01-14 11:24:54. Copyright ? 2002-2006, iAnywhere Solutions, Inc.
                        Portions copyright ? 1988-2006, Sybase, Inc.
I. 2008-01-14 11:24:54. All rights reserved. All unpublished rights 
reserved.
I. 2008-01-14 11:24:54.
I. 2008-01-14 11:24:54. This software contains confidential and trade secret 
information of
I. 2008-01-14 11:24:54. iAnywhere Solutions, Inc.
                        Use, duplication or disclosure of the software and 
documentation
I. 2008-01-14 11:24:54. by the U.S. Government is subject to restrictions 
set forth in a license
I. 2008-01-14 11:24:54. agreement between the Government and iAnywhere 
Solutions, Inc. or
I. 2008-01-14 11:24:54. other written agreement specifying the Government's 
rights to use the
I. 2008-01-14 11:24:54. software and any applicable FAR provisions, for 
example, FAR 52.227-19.
I. 2008-01-14 11:24:54.
I. 2008-01-14 11:24:54. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, 
CA 94568, USA
I. 2008-01-14 11:24:54.
I. 2008-01-14 11:24:54. Sybase Server-Library/15.0/P/PC 
Intel/BUILD1500-050/OPT/Tue Jul 12 15:32:18 2005
I. 2008-01-14 11:24:54. Configuration File: primeltm.cfg
I. 2008-01-14 11:24:54. LTM mode: batch LTL, continuous
I. 2008-01-14 11:24:54. LTM Started
I. 2008-01-14 11:24:54. Open Server "PRIMELTM" started
I. 2008-01-14 11:24:54. Negotiating LTL version: LTM version 700, Rep. 
Server version 600
I. 2008-01-14 11:24:55. Successfully connected to replication server 
'sample_rs' as user 'adm'
I. 2008-01-14 11:24:55. Maintenance user: 'muser'
E. 2008-01-14 11:24:55. Invalid user ID or password
E. 2008-01-14 11:24:55. Shutdown caused by fatal error
I. 2008-01-14 11:24:55. Beginning LTM shutdown sequence and freeing 
resources
I. 2008-01-14 11:24:56. LTM Shutdown Complete

Young 1/14/2008 8:14:21 AM

can you post your .cfg file.  Last time I had trouble (admittedly *many* 
years ago) I had a typo in the file that caused me to thrash about for far 
longer than it should have.

-- 
/steve
Stephen Rice
Sybase iAnywhere

"Young Wong"  wrote in message 
news:478b19dd$1@forums-1-dub...
> Hi all,
>
> I have problem on using the ASA Replication Agent. Any help will be 
> appreciated. Thanks.
>
> I have installed SQL Anywhere 10.0.1 build 3559, and the Replication Agent 
> Version 10.0.0.2465
>
> I have tried the Tutorial of Replicate data using Replication Server of 
> page 937 to page 945  of the System Admin Guide of ASA 10 (dbdaen10.pdf).
>
> When I try to start the LTM with the following command
>
> dbltm -S PRIMELTM -C primeltm.cfg
>
> The following error with Invalid user ID or password of dbmaint occurs (in 
> DBLTM.log).
> Based on the tutorial we kept dbmaint ID and password the same, and the 
> same name and password was used in RS 'create connection' command. It is 
> very simple and we try logging in successfully using isql.
>
> We then try to use another user (muser as the create connection ... set 
> username muser set password muser_ps) and the same error reported. Do 
> anyone encourter the same problem before?
>
> I. 2008-01-14 11:03:52. SQL Anywhere Replication Agent Version 10.0.0.2465
> I. 2008-01-14 11:03:52.
> I. 2008-01-14 11:03:52. Copyright ? 2002-2006, iAnywhere Solutions, Inc.
>                        Portions copyright ? 1988-2006, Sybase, Inc.
> I. 2008-01-14 11:03:52. All rights reserved. All unpublished rights 
> reserved.
> I. 2008-01-14 11:03:52.
> I. 2008-01-14 11:03:52. This software contains confidential and trade 
> secret information of
> I. 2008-01-14 11:03:52. iAnywhere Solutions, Inc.
>                        Use, duplication or disclosure of the software and 
> documentation
> I. 2008-01-14 11:03:52. by the U.S. Government is subject to restrictions 
> set forth in a license
> I. 2008-01-14 11:03:52. agreement between the Government and iAnywhere 
> Solutions, Inc. or
> I. 2008-01-14 11:03:52. other written agreement specifying the 
> Government's rights to use the
> I. 2008-01-14 11:03:52. software and any applicable FAR provisions, for 
> example, FAR 52.227-19.
> I. 2008-01-14 11:03:52.
> I. 2008-01-14 11:03:52. iAnywhere Solutions, Inc., One Sybase Drive, 
> Dublin, CA 94568, USA
> I. 2008-01-14 11:03:52.
> I. 2008-01-14 11:03:52. Sybase Server-Library/15.0/P/PC 
> Intel/BUILD1500-050/OPT/Tue Jul 12 15:32:18 2005
> I. 2008-01-14 11:03:52. Configuration File: primeltm.cfg
> I. 2008-01-14 11:03:52. LTM mode: batch LTL, continuous
> I. 2008-01-14 11:03:52. LTM Started
> I. 2008-01-14 11:03:52. Open Server "PRIMELTM" started
> I. 2008-01-14 11:03:52. Negotiating LTL version: LTM version 700, Rep. 
> Server version 600
> I. 2008-01-14 11:03:53. Successfully connected to replication server 
> 'sample_rs' as user 'adm'
> I. 2008-01-14 11:03:53. Maintenance user: 'dbmaint'
> E. 2008-01-14 11:03:54. Invalid user ID or password
> E. 2008-01-14 11:03:54. Shutdown caused by fatal error
> I. 2008-01-14 11:03:54. Beginning LTM shutdown sequence and freeing 
> resources
> I. 2008-01-14 11:03:55. LTM Shutdown Complete
>
>
>
>
>
> I. 2008-01-14 11:24:54. SQL Anywhere Replication Agent Version 10.0.0.2465
> I. 2008-01-14 11:24:54.
> I. 2008-01-14 11:24:54. Copyright ? 2002-2006, iAnywhere Solutions, Inc.
>                        Portions copyright ? 1988-2006, Sybase, Inc.
> I. 2008-01-14 11:24:54. All rights reserved. All unpublished rights 
> reserved.
> I. 2008-01-14 11:24:54.
> I. 2008-01-14 11:24:54. This software contains confidential and trade 
> secret information of
> I. 2008-01-14 11:24:54. iAnywhere Solutions, Inc.
>                        Use, duplication or disclosure of the software and 
> documentation
> I. 2008-01-14 11:24:54. by the U.S. Government is subject to restrictions 
> set forth in a license
> I. 2008-01-14 11:24:54. agreement between the Government and iAnywhere 
> Solutions, Inc. or
> I. 2008-01-14 11:24:54. other written agreement specifying the 
> Government's rights to use the
> I. 2008-01-14 11:24:54. software and any applicable FAR provisions, for 
> example, FAR 52.227-19.
> I. 2008-01-14 11:24:54.
> I. 2008-01-14 11:24:54. iAnywhere Solutions, Inc., One Sybase Drive, 
> Dublin, CA 94568, USA
> I. 2008-01-14 11:24:54.
> I. 2008-01-14 11:24:54. Sybase Server-Library/15.0/P/PC 
> Intel/BUILD1500-050/OPT/Tue Jul 12 15:32:18 2005
> I. 2008-01-14 11:24:54. Configuration File: primeltm.cfg
> I. 2008-01-14 11:24:54. LTM mode: batch LTL, continuous
> I. 2008-01-14 11:24:54. LTM Started
> I. 2008-01-14 11:24:54. Open Server "PRIMELTM" started
> I. 2008-01-14 11:24:54. Negotiating LTL version: LTM version 700, Rep. 
> Server version 600
> I. 2008-01-14 11:24:55. Successfully connected to replication server 
> 'sample_rs' as user 'adm'
> I. 2008-01-14 11:24:55. Maintenance user: 'muser'
> E. 2008-01-14 11:24:55. Invalid user ID or password
> E. 2008-01-14 11:24:55. Shutdown caused by fatal error
> I. 2008-01-14 11:24:55. Beginning LTM shutdown sequence and freeing 
> resources
> I. 2008-01-14 11:24:56. LTM Shutdown Complete
>
>
>

Stephen 1/14/2008 5:39:19 PM

Reply:

(Thread closed)