Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re^3: DBD::Sybase with Repserver and password encryption

by parv (Vicar)
on May 22, 2020 at 03:35 UTC ( #11117081=note: print w/replies, xml ) Need Help??


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 ...

  • perl & DBD::Sybase;
  • the external libraries (e.g. freetds or ones from AES) that DBD::Sybase uses;
  • isql;
  • Replication Server
... 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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11117081]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2020-10-27 17:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (257 votes). Check out past polls.

    Notices?