Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For registration and login issues contact website support.

Support Ticket System is replacing forum

This forum was converted into a searchable archive. You cannot add posts here any more. For support please use our new Ticket System.

Create your first ticket
Error connecting to the Prepared Configuration
To watch this topic for replies  Register (enables digests) or give email address:
This topic is locked: you cannot edit posts or make replies.
Display posts from previous:   
    View previous topic :: View next topic    
Author Message
Dong

Joined: 02 Mar 2010
Posts: 193

View user's profile

Back to top
Link to postPosted: Mon Mar 19, 2012 2:30 pmPost subject: Error connecting to the Prepared Configuration Reply with quote

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>



Last edited by Dong on Tue Mar 20, 2012 2:12 pm; edited 1 time in total
Dong

Joined: 02 Mar 2010
Posts: 193

View user's profile

Back to top
Link to postPosted: Tue Mar 20, 2012 2:06 pmPost subject: Reply with quote

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

fzimandl

Joined: 23 Jun 2011
Posts: 434

View user's profile

Back to top
Link to postPosted: Tue Mar 20, 2012 2:18 pmPost subject: Reply with quote

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

Dong

Joined: 02 Mar 2010
Posts: 193

View user's profile

Back to top
Link to postPosted: Tue Mar 20, 2012 2:28 pmPost subject: Reply with quote

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.

fzimandl

Joined: 23 Jun 2011
Posts: 434

View user's profile

Back to top
Link to postPosted: Tue Mar 20, 2012 2:50 pmPost subject: Reply with quote

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

fzimandl

Joined: 23 Jun 2011
Posts: 434

View user's profile

Back to top
Link to postPosted: Tue Mar 20, 2012 3:25 pmPost subject: Reply with quote

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  

Dong

Joined: 02 Mar 2010
Posts: 193

View user's profile

Back to top
Link to postPosted: Tue Mar 20, 2012 3:34 pmPost subject: Reply with quote

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>

fzimandl

Joined: 23 Jun 2011
Posts: 434

View user's profile

Back to top
Link to postPosted: Tue Mar 20, 2012 3:51 pmPost subject: Reply with quote

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.

Dong

Joined: 02 Mar 2010
Posts: 193

View user's profile

Back to top
Link to postPosted: Tue Mar 20, 2012 3:54 pmPost subject: Reply with quote

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

 

 

fzimandl

Joined: 23 Jun 2011
Posts: 434

View user's profile

Back to top
Link to postPosted: Tue Oct 02, 2012 8:46 amPost subject: Reply with quote

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

Thanks,
Filip

This topic is locked: you cannot edit posts or make replies.
Page 1 of 1


To watch this topic for replies   Register (enables digests) or give email address  
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum