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



0
Young
1/14/2008 8:14:21 AM
sybase.sqlanywhere.replication 4591 articles. 0 followers. Follow

1 Replies
945 Views

Similar Articles

[PageSpeed] 51

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" <young.wong@sybase.com> 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
>
>
> 


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

Similar Artilces:

Using Replication Server for ASA 9.0.1 to ASA 9.0.1 replication
We are an ASA 9.0.1 shop running on Windows XP. We host several of our clients and want to implement a warm standby server for recovery. We've looked into Mobilink and Remote server within ASA and don't like them. I read that Replication Server will support ASA, is what I've described doable? If so, is there a cook book? Thanks Eric ...

Replication is not replicating
The new database is added to the replication system but all tables on the RDB are empty. Setreptable is on and there's no uncommitted transaction. It is using default action class and there's no loss detection. Queue is caught up. We turned on "dsi_buf_dump" and it shows on the error log that the transaction executed on the PDB is replicated. However, the table is again empty on the RDB. Log is not full on both RDB and RSSD. Maint user is dbo. What else can I take a look at? PDS and RDS is 11.0.3.3, RS is 11.0.3 I don't remember since what version warm ...

San replication for replication server
Has anyone ever put a replication server on SAN disk with the intention of replication the stable queues and RSSD to a DR sire via SAN replication In other words replicate the entire replication server across the SAN and bring it up whe DR is invoked would there be any datalose on teh stables queues ? any issues David wrote: > Has anyone ever put a replication server on SAN disk with > the intention of replication the stable queues and RSSD to a > DR sire via SAN replication > In other words replicate the entire replication server > across the SAN and bring it up ...

Replicate SQL Anywhere Text column to ASE using Replication Server
Hi everyone, Is it possible replicate text column in SQL anywhere 5.5.04 using Replication Agent for SQL Anywhere and Replication Server 11.5 to Adaptive Server Enterprise? TIA Virginia yes. Replication of BLOBs works fine /steve -- Stephen Rice Manager Custom Support Sybase Canada Inc. email: srice@sybase.com virginia cheung wrote in message <01bdf3e7$6ed5c420$010414ac@star>... >Hi everyone, > >Is it possible replicate text column in SQL anywhere 5.5.04 using >Replication Agent for SQL Anywhere and Replication Server 11.5 to Adaptive >Server ...

Joint Replication and WorkSpace V-SIG --- Using WorkSpace with Replication Server
You are invited to attend a joint Replication and WorkSpace V-SIG. The topic: Using WorkSpace with Replication Server. Chris Huston, Replication Development Manger, and Mike Crocker, Engineering Director, will be giving a short presentation and a demo, followed by Q&A. Date: Thur, June 12, 2008 Time: 8:00 PST, 11:00 EST For more information, and connection information see http://my.isug.com/index.php?module=calendar&op=view&sid=591 -- Aryeh Silverberg ISUG Virtual Users Group Director http://...

Replication doesn't work from ASE to SA using Replication Server
I have been setup replication between ASE 11.5 and SQL Anywhere using Repliation Server. The primary database is in ASE 11.5 and the replicate database is SQL Anywhere 5.5.04. I have been setup Open gateway for SQL Anyway, create the connection, create replciation definition and subscription. No error show on the Replication Server Manager. But If I inserted/updated/deleted data in the ASE database, no changes will be replicated to the SQL Anywhere database. No queue has been written in the outbound queue for this connection. No error also. Would anyone help me? TIA. On M...

Bi-directional replication with Replication Server
What are the databases that participate in bi-directional replication with a SQL Anywhere database? I heard that you can replicate only INTO MS SQL Server, but not out (into SQL Anyhwere). Does the same limitation hold for Adaptive Server Enterprize (a.k.a. Sybase SQL Server) or Oracle on NT? Please note that we are developing for Win95/Win NT paltform only. Any feedback is appreciated. Sergey Beyder Inspectech Corp. SQL Anywhere can participate fully and bidirectionally in a Rep Server setup. This means that it can replicate bidirectionally with ASE on all platforms. It can re...

Having two replication servers replicating from one primary
Hi all, Sorry for cluttering this place with questions, but i kinda have so many questions that i need to be answered.. Heres another one.. The primary DB that i am gonna replicate from currently has another replication server replicating from it.. hence it already has been configured and all.. I am gonna have my own rep server to connect to the primary database, so there is gonna be two replication servers connected to the primary DB. The two repservers will be independent of each other The question is, are there any issues that i need to be aware of when i configure to a...

How do you get replication server to create tables at the replicate?
I want to set up replication and have replication server create the replicate table at the replicate. Is this possible at all? look at using warm standby with DDL replication. George <olayinkao> wrote in message news:EE9C0658E518EADB002B119185256BDC.002B119F85256BDC@webforums... > I want to set up replication and have replication server create the > replicate table at the replicate. Is this possible at all? ...

Alternative to replication server two way replication?
Greetings, This may sound crazy, but where I work they are looking to implement two way replication without using replication server. In other words, they want two active systems A and B. They want A to replicate to B and B to replicate to A and are looking for alternatives to replication. Does anyone know if this can be done? Thank you. Jean-Pierre Can it be done? yes Are there any 3rd party products (other than RepServer) that'll do this 'out of the box'? *shrug* Not that I know of. [This just means that *I* don't know of any.] If you want t...

Replicating a table using replication defns and subscription
Hi, We have a table in a database, which is in a warm standby setup. The table has more than 128 columns and has a timestamp column. The ltm bombs out giving an error about not being able to handle more than 128 columns. Is it possible to replicate this one table using a replication defn and subscription? Would these steps be ok. use warmdb exec sp_reptable table, false exec sp_setreplicate table, true create a rep definition. define a subscription. activate it. validate it. check it. Has anyone does this before? We are having problems setting up the subscription. Pleas...

Replicate in Cascade for 3 or more Databases with Replication Server
Hi. We want to make a table-to-table replication schema for 3 or more databases using this architecture: The row is created/modified in the first ASE, then, this row is saved in central ASE using Rep Server, and this central ASE replicate this row to other Remotes ASE's, in a cascade fashion. The replication must be bi-directional, and we want that all ASE's are always synchronised with the same data. We try to do this with 3 ASE's, one origin, one repository and one remote, but the record replicates only to the repository and not to the remote ASE. Anyone knows ...

Is Replication Server capable of replicate data in real time?
I have a question about Replication Server, does Replication Server guarantee 100% real time replication to another box? Thanks in advance, Peter Norman > I have a question about Replication Server, does Replication Server > guarantee 100% real time replication to another box? What is your definition of 'real time'?? If you mean 'synchronous', i.e., data modifications take place at the primary and secondary servers at the same time ... the answer is *NO*. RepServer is an asynchronous replication product, i.e., data modifications at the primary site t...

ERROR replicating from ASE -> ASA using repsever
Hi, out there I suddenly get the following error in the log file of the rep server: E. 2001/04/11 13:32:13. ERROR #28049 DSI(113 PC10003.PC10003) - sub_rsts.c(445) Cannot find subscription <0x01000065800000e6> in system tables can someone HELP me, regards, Wim All the subscription information is stored in Rep Server system tables in the RSSD, so this problem is likely not related to anything on the ASA side of things. Hopefully somebody on the rep-server newsgroup can help, I only know enough about Rep Server to be really dangerous. -- Reg Domaratzki, Sybase i...

Web resources about - dbmaint user error in ASA replication using LTM and replication server - sybase.sqlanywhere.replication

Replication (computing) - Wikipedia, the free encyclopedia
... in space , i.e. executed on separate devices, or it could be replicated in time , if it is executed repeatedly on a single device. Replication ...

Facebook Slashes Data Replication With HDFS RAID
Avoiding replication is a key component of efficient data storage , and one method Facebook uses to accomplish this task is HDFS RAID , which ...

PolSci Replication (@PolSciReplicate) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Encryption in demand for backup and replication: Veeam
When it comes to backup and replication, Veeam has found encryption is one of the most requested feature by businesses.

John Sands Australia cuts data replication time from 14 hours to three
Corporate data replication was taking up to 14 hours to complete at greeting card company John Sands Australia until data acceleration software ...

EMC gives VMware admins the reins to replication and recovery
EMC is putting replication and recovery into the hands of VMware administrators with a software version of its RecoverPoint appliance that's ...

Facebook Slashes Data Replication With HDFS RAID - SocialTimes
Avoiding replication is a key component of efficient data storage , and one method Facebook uses to accomplish this task is HDFS RAID , which ...

rsync.net: ZFS Replication to the cloud is finally here—and it’s fast
As friendly of an online advertisement as you'll find. In mid-August, the first commercially available ZFS cloud replication target became available ...


Violin to bring deduplication, replication, other tools to all-flash storage arrays
Violin Memory plans to add deduplication, thin provisioning, snapshots and other features in a software update for its all-flash storage arrays, ...

Resources last updated: 12/18/2015 8:47:44 PM