escaping of passwords?

Markus_Schorer

Hi,

our db admins setup our cms databases with passwords containing special characters. We're using the same password for all related DBs.

for the management and delivery server (migrated from 8.0 to 8.1) the password works.

the password looks similar to this: someChars-&otherChars@U!done (with excatly these special characters)

When i'm trying to add a new delivery stage, i can choose between 2 errors:

- when i'm using the password "as-is", i get a sax parser error complaining about the unescaped "&" ampersand (see attached sax_error.log), but i don't get errors from the jdbc driver, publish works

- when i'm escaping the "&" as "&", no sax errors, but jdbc errors (see attached jdbc_error.log), vgnTest.jsp shows "ok", publish results in the endpoint getting suspended

now the questions:

- why does it work in the current setup

- how do i need to encode the pwd to make db-connectivity _AND_ xml parsing work

thanks,

markus

jdbc_error.log

sax_error.log

Mukul_Bishnoi

Hi Markus,

 

Open Config Console and go to the property JDBC_XML located under (Vignette Configuration Console > Vignette Content > Vignette Content Delivery Services > Content Management Stage > Content Delivery Services - mgmt > Application Services > Castor), here comment out the password parameter.

 

This should fix the problem.

 

Cheers!

Mukul

 

From: eLink Entry: Discussion Group - Web Experience Management [mailto:v7webcontentmanagement@elinkkc.opentext.com]
Sent: Thursday, July 28, 2011 8:09 AM
To: eLink Recipient
Subject: escaping of passwords?

 

escaping of passwords?

Posted by mschorer@pocketkings.ie (Schorer, Markus) On 2011/07/28 08:03

 

Hi, our db admins setup our cms databases with passwords containing special characters. We're using the same password for all related DBs. for the management and delivery server (migrated from 8.0 to 8.1) the password works. the password looks similar to this: someChars-&otherChars@U!done (with excatly these special characters) When i'm trying to add a new delivery stage, i can choose between 2 errors: - when i'm using the password "as-is", i get a sax parser error complaining about the unescaped "&" ampersand (see attached sax_error.log), but i don't get errors from the jdbc driver, publish works - when i'm escaping the "&" as "&", no sax errors, but jdbc errors (see attached jdbc_error.log), vgnTest.jsp shows "ok", publish results in the endpoint getting suspended now the questions: - why does it work in the current setup - how do i need t! o encode the pwd to make db-connectivity _AND_ xml parsing work thanks, markus

 

Attachment Links:

jdbc_error.log (3 KB)

sax_error.log (3 KB)

---

[To post a comment, use the normal reply function]
Forum:	Discussion Group - Web Experience Management
Livelink Server:	knowledge-wlweb01