nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

error in Publish LiveSite Content -ORA-01005

elenav

Hello,
I'm using the Publish LiveSite Content default workflow. I'm trying to publish on the development node.
It returns an opendeploy error trying to connect to the development target database (sitepublisher). The error is this:

DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: ORA-01005: null password given; logon denied

In the configuration file livesite-database.xml (/in InterWoven/OpenDeployNG/etc) the password is correctly written

Does anyone know why it doesn't see the password?

Thanks in advance,
Elena

Find more posts tagged with

Comments

vaibhav2288

Hello,
I'm using the Publish LiveSite Content default workflow. I'm trying to publish on the development node.
It returns an opendeploy error trying to connect to the development target database (sitepublisher). The error is this:

DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: ORA-01005: null password given; logon denied

In the configuration file livesite-database.xml (/in InterWoven/OpenDeployNG/etc) the password is correctly written

Does anyone know why it doesn't see the password?

Thanks in advance,
Elena

Which OD/DD version you are using ?

If you are using the OD/DD 7.1, then it supports only encoded or encrypted passwords for DB.

In "livesite-database.xml" set password-encoded="yes" and then encode the password with iwodpasscoder.

I hope, it will solve your problem.

elenav

Thank you very much.

Yes, I'm using OD/DD Version 7.3.1.0.0.

In the configuration file is already set password-encoded="yes".

So, I have to encrypt the password with the iwodpasscoder command and then write it in the database-livesite.xml file and restart Opendeploy, is it correct?

Thanks again,
Elena

OS BIRT 450 Pos Neg.png

nipper

Thank you very much.

Yes, I'm using OD/DD Version 7.3.1.0.0.

In the configuration file is already set password-encoded="yes".

So, I have to encrypt the password with the iwodpasscoder command and then write it in the database-livesite.xml file and restart Opendeploy, is it correct?

Thanks again,
Elena

Yes to the encrypt the password step. I am not certain if you need to restart/reset OD, or if this is built into the UI, which would mean run build.sh

elenav

Thanks a lot again.

I've tried running build.sh from /InterWoven/TeamSite/local/config/lib/content_center/livesite_customer_src/ and restarting OD but it didn't work.

So I've tried changing password-encoded="no" and leaving the normal password, restarting OD and now it works!

I have another problem now. The workflow doesn't move the files, I don't see the OD with conf file OpenDeployWebRoot.xml...can you help me?

thanks again!
elena

vaibhav2288

Thanks a lot again.

I've tried running build.sh from /InterWoven/TeamSite/local/config/lib/content_center/livesite_customer_src/ and restarting OD but it didn't work.

So I've tried changing password-encoded="no" and leaving the normal password, restarting OD and now it works!

I have another problem now. The workflow doesn't move the files, I don't see the OD with conf file OpenDeployWebRoot.xml...can you help me?

thanks again!
elena

Is it giving any error ? Check OD logs.
To find your configuration file you need to go to /iwov/OpenDeployNG/conf/
folder.

elenav

The problem is that the workflow doesn't invoke the OpenDeploy for moving the files (the step that uses the file config OpenDeployWebRoot.xml) so I don't have the OD logs.

I have changed the file customer-teamsite-resource-config.xml in the dirtectory /local/config/lib/content_center/livesite_customer_src/etc/conf/livesite_customer/resources to change the directortTarget and run ./build.sh. Where do I have to check that the file has been correctly moved?

What do I have to check in this file? there in a node

and then I have where LiveSiteRuntime is a node defined in odnodes.xml,is it correct?

or there is something else that I have to check?

Thanks a lot,
Elena

Capture1.PNG

sahu

check your odnodes.xml file what is host name written there, then check in that host "targetDirectory"

like
[PHP]

[/PHP]

file will be deploy there

app.zip

elenav

I don't see what you wrote in the php code...

can you rewrite it? thanks