http://www.perlmonks.org?node_id=11117081


in reply to Re^2: DBD::Sybase with Repserver and password encryption
in thread DBD::Sybase with Repserver and password encryption

Could you list the versions of ...

... for possibly others to help?

You could do DBI->trace(4); before connect() to see where the issue is at more granular level.

At this point all I can say is to check that encrypted passwords match as sent by isql & DBD::Sybase (say, via tcpdump or some other network packet analyzer) to the replication server.

Replies are listed 'Best First'.
Re^4: DBD::Sybase with Repserver and password encryption
by Anonymous Monk on May 22, 2020 at 12:42 UTC

    Setting the trace has helped I believe

    I see this which only appears when the encryptPassword is set on

    -> DBI->connect(dbi:Sybase:server=MY_REPSERVER;encryptPassword=1, rep +serv_user, ****) !! ERROR: 2056 CLEARED by call to connect method -> connect for DBD::Sybase::dr (DBI::dr=HASH(0x1a723a8)~0x1a72420 +'server=MY_REPSERVER;encryptPassword=1' 'repserv_user' **** HASH(0x1d +1d640)) syb_db_login() -> using global CS_LOCALE data servermsg_cb -> number=14021 severity=12 state=0 line=0 server=MY_ +REPSERVER text=Invalid login attempted by user 'repserv_user' clientmsg_cb -> ct_connect(): protocol specific layer: external er +ror: The attempt to connect to the server failed.

    That 2056 error (which is a Sybase syntax error) does not appear when encryptPassword is not set.

    So it looks like a possible bug in DBD::Sybase ?

    I'm not sure if that module is maintained anymore