Error connecting to the Prepared Configuration

Hi,

As the db admin I prepared the schema config file following the instruction in the manual. When I try to connect to the schema using the URL config I prepared I am getting error:

Could not get JDBC connection ... ORA-01017: invalid username/password.

Following is my .ijs file. I provided everything correctly, such as user name ...

Any clue how to fix the problem.

Dong

 

my .ijs file on server

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> /><properties>
<comment>Schema connection config. Do not edit.</comment>
<entry key="connection.description">###############</entry>
<entry key="registration.code.ijc">MCwCFAfWU08yB/YnEnD72JKCdh9Hi/1QAhR3dTf4Z3/j3Rs0a3yUNJbuXG0XsA==</entry>
<entry key="database.driver">oracle.jdbc.driver.OracleDriver</entry>
<entry key="schema.id">18E4ECA77AF2722FDC8D1ACB495EF011</entry>
<entry key="database.url">################</entry>
<entry key="showoptions.ijc.username">ALWAYS</entry>
<entry key="showoptions.db.username">DEFAULT</entry>
<entry key="database.username">ip</entry>
<entry key="database.password">secret</entry>
<entry key="schema.name">ip</entry>
</properties>

Any remediation suggestion from the experts will be greatly appreciated. Otherwise we will have to do the tradational way... with a lot users, which is why you guys offered the Prepared Configuration in the first place. Really wish this function work

Hi,
are you able to connect using project with that .ijs file locally? I mean not as shared project, but as standard IJC project. It seems to me that some information is missing in the file. E.g. my file for Oracle schema looks like and it's the same for the schema in standard and shared project:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Schema connection config. Do not edit.</comment>
<entry key="custom.connection.pool.minEvictableIdleTimeMillis">30000</entry>
<entry key="database.schema">SYSTEM</entry>
<entry key="custom.connection.pool.timeBetweenEvictionRunsMillis">5000</entry>
<entry key="database.username">827PhcS19dBkXpUu7GA=</entry>
<entry key="database.url">jdbc:oracle:thin:@localhost:1521:XE</entry>
<entry key="schema.name">oracleschema</entry>
<entry key="schema.autoconnect">true</entry>
<entry key="custom.connection.pool.maxActive">8</entry>
<entry key="database.password">827PhcS1uyPVLGioCHE=</entry>
<entry key="schema.id">C68F81BDA9A66511D9F981BEB6758329</entry>
<entry key="database.driver">oracle.jdbc.driver.OracleDriver</entry>
<entry key="showoptions.ijc.username">ALWAYS</entry>
<entry key="custom.connection.pool">true</entry>
<entry key="showoptions.db.username">DEFAULT</entry>
</properties>

Please try to prepare a IJC project you wish to share by using URLs. Shared project can be easily created from any IJC project as described in the manual: http://www.chemaxon.com/instantjchem/ijc_latest/docs/admin/project_deploy.html .

Is that what you have meant? Does it help?

Filip

This may not be a good idea since the projects will be opened by many users simutaneously. Upfront for shared project you have following important warning. Is there a bug with Prepared Configuration!!!!!

Important: The project (as a directory on disk) is designed for single user only. It should never be opened by more than one user even if it is located in a shared disk. This document describes how to achieve sharing of projects correct way.

Ah, I see. Are the username and password in the *.ijs file specified in an unencrypted form, means in plain text?

Is it working with plain-text username and password? Anyway it should be encrypted in such a conf file. So this is ideed a bug and we are working on the solution.

Sorry for this inconvenience.
Filip  

uid, pid are plain text. now I seem move forward a bit, that JDBC error is gone, but get schema error as following, I also attached my current .ijs

Database schema name not specified. Make sure your .ijs file contains 'database.schema' property

 

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> /><properties>
<comment>Schema connection config. Do not edit.</comment>
<entry key="connection.description">#########</entry>
<entry key="database.driver">oracle.jdbc.driver.OracleDriver</entry>
<entry key="schema.id">18E4ECA77AF2722FDC8D1ACB495EF011</entry>
<entry key="database.url">jdbc:oracle:thin:@dupinfo01.pri.bms.com:1521:chemip</entry>
<entry key="showoptions.ijc.username">ALWAYS</entry>
<entry key="showoptions.db.username">DEFAULT</entry>
<entry key="database.username">#####</entry>
<entry key="database.password">#####</entry>
<entry key="custom.connection.pool">true</entry>
<entry key="schema.name">####</entry>
<entry key="custom.connection.pool.minEvictableIdleTimeMillis">30000</entry>
<entry key="custom.connection.pool.timeBetweenEvictionRunsMillis">5000</entry>
<entry key="custom.connection.pool.maxActive">8</entry>
</properties>

I can see that 'database.schema' property is missing from what you have pasted in the last post. Maybe this is the problem.

The easiest way how to prepare your *.ijs file is to connect to Oracle at first - simply fill in all necessary data. And then search for *.ijs file in the project directory. After that you can copy it to the webserver and change the username and password to non-encrypted form. It should work if you were able to "Connect to Schema" by "Oracle" item.

ooops I did not include the database.schema entry in ijs, once I added I got in right away. Just be fair Prepared Configuration function does work!!!!

Thanks

Dong

 

 

Using encrypted credentials in prepared configuration file will be fixed and possible in Instant JChem 5.12 version.

Thanks,
Filip