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.

login trigger and HA

2 posts in General Discussion Last posting was on 2012-04-09 20:18:19.0Z
Max DBA Posted on 2012-04-05 14:23:58.0Z
Sender: 42e7.4f7da7a0.1804289383@sybase.com
From: Max DBA
Newsgroups: sybase.public.ase.general
Subject: login trigger and HA
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f7daafe.43aa.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Apr 2012 07:23:58 -0700
X-Trace: forums-1-dub 1333635838 172.20.134.41 (5 Apr 2012 07:23:58 -0700)
X-Original-Trace: 5 Apr 2012 07:23:58 -0700, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31010
Article PK: 73905

Hi,
I am trying to use login trigger with ASE 15 with HA option
(active/active not CE). I am not sure if it works or not in
HA. I created the procedure in one user db and associated
the login but what on the other node? The same login does
not have associated the procedure (info from sp_displaylogin
output), trying to associate an error occur (cannot find the
proc...). I also changed default db to master and created
the stored procedure on both masters, I associated the
procedure to the login on both nodes but when I connect I
get the correct behaviour on one node but on the other node
I get an error (Could not execute proc for user...). I have
not find specific info from manuals or solved cases. Do you
know if login triggers can be used with HA option and how?


Rob V Posted on 2012-04-09 20:18:19.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: login trigger and HA
References: <4f7daafe.43aa.1681692777@sybase.com>
In-Reply-To: <4f7daafe.43aa.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f83440b@forums-1-dub>
Date: 9 Apr 2012 13:18:19 -0700
X-Trace: forums-1-dub 1334002699 10.22.241.152 (9 Apr 2012 13:18:19 -0700)
X-Original-Trace: 9 Apr 2012 13:18:19 -0700, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31017
Article PK: 73907


On 05-Apr-2012 16:23, Max DBA wrote:
> Hi,
> I am trying to use login trigger with ASE 15 with HA option
> (active/active not CE). I am not sure if it works or not in
> HA. I created the procedure in one user db and associated
> the login but what on the other node? The same login does
> not have associated the procedure (info from sp_displaylogin
> output), trying to associate an error occur (cannot find the
> proc...). I also changed default db to master and created
> the stored procedure on both masters, I associated the
> procedure to the login on both nodes but when I connect I
> get the correct behaviour on one node but on the other node
> I get an error (Could not execute proc for user...). I have
> not find specific info from manuals or solved cases. Do you
> know if login triggers can be used with HA option and how?

I doubt anyone has ever looked at this... I guess it should work, but
you'd probably need to define it in both master databases indeed, as you
mention.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------