Support Centre

Find articles, help and advice.

 
Welcome, Guest Login

Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Pass phrase not working.

Arunamshu Udayakumar Mar 30, 2015 05:52AM UTC

Hi,

I have been working with nnDB. I have made a new directory in /usr/ISS "nnDB4". I have added DB server details in /usr/ISS/conf/nnDB.cfg file as well. When Iám starting, its showing another instance is running. So i had to kill the tomcat process and clear /work directory as you have showed in the demo. I wanted to know:

Is it not possible that multiple nnDB run at the same time in one ASI server?

My next question is:

I was trying to use ./keyImport.sh to import server.crt file. I tired to give the pass phrase, but "keytool error: java.io.IOException: Keystore was tampered with, or password was incorrect" message appears. How can i resolve this?

Regards
Arunamshu

Up 0 rated Down
David Harwood Mar 30, 2015 07:30AM UTC Interlink Software Agent
Hi Arunamshu,

When you created nnDB4, did you copy a previous nnDB directory and just change the config? Or did you run the install script again within the nnDB4 directory?

Regards,
David
Up 0 rated Down
Arunamshu Udayakumar Mar 30, 2015 11:13AM UTC
i took a tar copy of nnDB3(previous nnDB) into /tmp directory untar'd it there. changed name, configuration and copied it back to ISS directory. and tried to start.
Up 0 rated Down
David Harwood Mar 30, 2015 11:29AM UTC Interlink Software Agent
Hi Arunamshu,

Can you send me the latest logs for both nnDB3 and nnDB4? These can be found in the logs directory within the nnDB3 and nnDB4 directory.

Regards,
David
Up 0 rated Down
Arunamshu Udayakumar Mar 30, 2015 11:40AM UTC
Hi David,

Below are the logs you have asked for

nnDB3:

[root@AESSRVTECHM logs]# tail -f nnDB.txt
at java.net.AbstractPlainSocketImpl.connect(Unknown Source) ~[na:1.7.0_55]
at java.net.SocksSocketImpl.connect(Unknown Source) ~[na:1.7.0_55]
at java.net.Socket.connect(Unknown Source) ~[na:1.7.0_55]
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source) ~[na:1.7.0_55]
at sun.security.ssl.SSLSocketImpl.<init>(Unknown Source) ~[na:1.7.0_55]
at sun.security.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source) ~[na:1.7.0_55]
at co.netnow.sender.socket.RemoteConnection.connectSocket(RemoteConnection.java:55) [nnDB-2.7-SNAPSHOT.jar:2.7-SNAPSHOT]
at co.netnow.sender.socket.RemoteConnection.connect(RemoteConnection.java:138) [nnDB-2.7-SNAPSHOT.jar:2.7-SNAPSHOT]
at co.netnow.integrations.java.nndb.RightHandConnectionNN.run(RightHandConnectionNN.java:196) [nnDB-2.7-SNAPSHOT.jar:2.7-SNAPSHOT]
15/03/31 06:48:45.473 ERROR: c.n.s.s.RemoteConnection: Waiting to retry...



[root@AESSRVTECHM logs]# tail -f nnDB_errors.txt
at java.net.AbstractPlainSocketImpl.connect(Unknown Source) ~[na:1.7.0_55]
at java.net.SocksSocketImpl.connect(Unknown Source) ~[na:1.7.0_55]
at java.net.Socket.connect(Unknown Source) ~[na:1.7.0_55]
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source) ~[na:1.7.0_55]
at sun.security.ssl.SSLSocketImpl.<init>(Unknown Source) ~[na:1.7.0_55]
at sun.security.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source) ~[na:1.7.0_55]
at co.netnow.sender.socket.RemoteConnection.connectSocket(RemoteConnection.java:55) [nnDB-2.7-SNAPSHOT.jar:2.7-SNAPSHOT]
at co.netnow.sender.socket.RemoteConnection.connect(RemoteConnection.java:138) [nnDB-2.7-SNAPSHOT.jar:2.7-SNAPSHOT]
at co.netnow.integrations.java.nndb.RightHandConnectionNN.run(RightHandConnectionNN.java:196) [nnDB-2.7-SNAPSHOT.jar:2.7-SNAPSHOT]
15/03/31 06:49:45.476 ERROR: c.n.s.s.RemoteConnection: Waiting to retry...



nnDB4:

[root@AESSRVTECHM logs]# tail -f nnDB.txt
15/03/31 06:33:25.619 DEBUG: c.n.i.j.n.ConfigurationBase: Found: nnRemoteHost
15/03/31 06:33:26.278 ERROR: c.n.i.j.n.MultiThreadServer: Error = org.jasypt.exceptions.EncryptionOperationNotPossibleException org.jasypt.exceptions.EncryptionOperationNotPossibleException
at org.jasypt.encryption.pbe.StandardPBEByteEncryptor.decrypt(StandardPBEByteEncryptor.java:918)
at org.jasypt.encryption.pbe.StandardPBEStringEncryptor.decrypt(StandardPBEStringEncryptor.java:725)
at org.jasypt.util.text.BasicTextEncryptor.decrypt(BasicTextEncryptor.java:112)
at co.netnow.integrations.java.nndb.Configuration.loadPasswordNN(Configuration.java:408)
at co.netnow.integrations.java.nndb.Configuration.load(Configuration.java:341)
at co.netnow.integrations.java.nndb.MultiThreadServer.init(MultiThreadServer.java:220)
at co.netnow.integrations.java.nndb.MultiThreadServer.main(MultiThreadServer.java:94)


[root@AESSRVTECHM logs]# tail -f nnDB_errors.txt
15/03/31 06:33:26.278 ERROR: c.n.i.j.n.MultiThreadServer: Error = org.jasypt.exceptions.EncryptionOperationNotPossibleException org.jasypt.exceptions.EncryptionOperationNotPossibleException
at org.jasypt.encryption.pbe.StandardPBEByteEncryptor.decrypt(StandardPBEByteEncryptor.java:918)
at org.jasypt.encryption.pbe.StandardPBEStringEncryptor.decrypt(StandardPBEStringEncryptor.java:725)
at org.jasypt.util.text.BasicTextEncryptor.decrypt(BasicTextEncryptor.java:112)
at co.netnow.integrations.java.nndb.Configuration.loadPasswordNN(Configuration.java:408)
at co.netnow.integrations.java.nndb.Configuration.load(Configuration.java:341)
at co.netnow.integrations.java.nndb.MultiThreadServer.init(MultiThreadServer.java:220)
at co.netnow.integrations.java.nndb.MultiThreadServer.main(MultiThreadServer.java:94)
Up 0 rated Down
Arunamshu Udayakumar Mar 30, 2015 11:56AM UTC
When Im starting nnDB4, nnDB3 seems to be starting. I the changed the path in env.sh of nnDB4 as:

PPHOME=/usr/ISS/nnDB4

Is there anywhere else i need to change path?

Up 0 rated Down
Matthew Sweeney Mar 31, 2015 09:04AM UTC Interlink Software Agent
Hi Arunamshu,

When you created your new nnDB4 directory, did you re-run the install ( ./install.sh )? You may need to re-run the install in order to correctly set the environment variables, along with generating the encrypted DB User password.

Regards,
Matthew
Up 0 rated Down
Arunamshu Udayakumar Mar 31, 2015 11:39AM UTC
Hi Matt,

As you told I managed to run nnDB4(latest).

I'm able to connect from my ASI server to the remote database also.

But in nnDB.txt log I'm seeing the following error:

15/04/01 06:48:03.414 ERROR: c.n.s.s.RemoteConnection: Waiting to retry...
15/04/01 06:48:05.447 ERROR: c.n.i.j.n.Database: Exception encounted when connecting to left hand database. Exception: StackTrace: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


What could be the issue?

Regards,
Arunamshu
Up 0 rated Down
Matthew Sweeney Mar 31, 2015 11:49AM UTC Interlink Software Agent
Hi Arunamshu,

Is the nnDB4 instance connecting to a MySQL Database? If so, you will need to copy the file 'mysql-connector-java-5.1.26-bin.jar' from /usr/ISS/nnDB3/classes to /usr/ISS/nnDB4/classes.

It might be best to Stop/Kill nnDB4, remove the 'run.pid' file from /usr/ISS/nnDB4/work, copy over the mysql jar file and then start-up nnDB4.

Hope this helps.

Regards,
Matt
Up 0 rated Down
Arunamshu Udayakumar Mar 31, 2015 12:28PM UTC
Hi Matt,

Thanks for the reply. I got rid of that issue. Its connecting to database. Now I have created a user field with below details:

field62 service_name

and mapped it to _service_name using AlertInboud Mapping List

Still I'm unable to find it when i access

https://172.19.77.122/nn/services/Alert?uf.mcname-eq=nnDB&state-eq=Active&sort=dateCreated-desc&tc=true


I cant find it in

https://172.19.77.122/nn/services/Alert/metadata either.

Regards
Aruanmshu
Up 0 rated Down
Matthew Sweeney Mar 31, 2015 01:15PM UTC Interlink Software Agent
Hi Arunamshu,

Have you ran the two utilities: "Rebuild Web Services" and "Update User Fields" under the ASI Admin > System Management Utilities page? (https://172.19.77.122/nn/admin > system management utilities)

Regards,
Matt
Up 0 rated Down
Arunamshu Udayakumar Apr 01, 2015 08:47AM UTC
Hi Matt,

Thanks for the help. It worked. I could successfully add fields and I can see them.

I have 2 nnDBs running nnDB3 and nnDB4 both querying from the same database server. How can i differentiate between both? i.e,

when i give the url

https://172.19.77.122/nn/services/alert?state-eq=CLOSED&uf:host_name-sw=localhost1&uf:mcname-eq=nnDB

I'm getting output of queries in nnDB3 but not nnDB4 with MCNAME as nnDB.

How can i get the output of queries only for nnDB4?

Regards
Arunamshu
Up 0 rated Down
Matthew Sweeney Apr 01, 2015 09:14AM UTC Interlink Software Agent
Hi Arunamshu,

Can you try the following (for nnDB4):

1. Stop nnDB4 (ps -ef |grep -i java , then kill the corresponding nnDB4 pid & remove run.pid from ../nnDB4/work)
2. Open the env.sh file under ../nnDB4
3. Modify the "MCNAME=nnDB" entry, try changing it to "MCNAME=nnDB4"
4. Save the file
5. Restart nnDB4
6. On start-up, you can check the ../nnDB4/logs/nnDB4.txt file, as this logs the given MCNAME e.g.

DEBUG: c.n.i.j.n.MultiThreadServer: Message channel: nnDB

The above entry shows the message channel as "nnDB". After you make the changes above, this should show nnDB4 as the message channel. Let me know if this works for you.

Regards,
Matt
Up 0 rated Down
Arunamshu Udayakumar Apr 01, 2015 10:10AM UTC
Hi Matt,

It worked. Thanks!

I'm trying to fetch the details into Dynamic text box.

In the Data field I have enterd:

${s.appname}/services/Alert?uf.mcname-eq=nnDB4&sort=dateCreated-desc&tc=true


Below is my xml output:

<entity class="co.netnow.alert.Alert" id="3727715"><id>3727715</id><dateCreated>1427930737858</dateCreated><dateUpdated>1427930737886</dateUpdated><entityErrors href="/nn/services/EntityError/?alert-eq=3727715"/><entityType href="/nn/services/EntityType/1">1</entityType><source href="/nn/services/Connection/4">4</source><accepted>false</accepted><acknowledged>false</acknowledged><alertMessages href="/nn/services/AlertMessage/?alert-eq=3727715"/><events href="/nn/services/Event/?alert-eq=3727715"/><help>null</help><integrationID>114279307377509</integrationID><notes href="/nn/services/AlertNote/?alert-eq=3727715"/><occurrences>1</occurrences><severity>1</severity><state>CLOSED</state><text>null</text><userfields><uf:mcname>nnDB4</uf:mcname><uf:service_name>HTTP</uf:service_name><uf:service_status>WARNING</uf:service_status><uf:host_status>OK</uf:host_status><uf:host_name>localhost</uf:host_name></userfields></entity>


And


In the templates tab I'm entering the below code:

<#ftl ns_prefixes={"uf": "http://www.netnow.co/xml/uf"}>
<#-- The above header is added automatically to all FTL templates which use the 'uf:' XML namespace -->
<grid
type="grid"
dataElement="entity"
idField="integrationID"

alertAdmin="true"
showGrid="true"
classic="false"
showWidgetViews="false"
sortName="integrationID" sortOrder="desc"
>

<!--
Any sort criteria specified above, e.g. sortName="integrationID" sortOrder="desc"
will override any sort parameters passed in the URL query string.
-->

<!-- Optionally create shortcuts to Widget Views (if enabled above). The label defaults to the view name. -->
<views>
<view name="View 1"/>
<view name="View 2" label="Another example"/>
</views>

<!-- Define the columns to be displayed in the AID -->
<columns>
<column>
<label>ID</label>
<field>integrationID</field>
<width>80</width>
<searchType>string</searchType>
</column>
<column>
<label>Service Name</label>
<field>uf:service_name</field>
<width>40</width>
<searchType>string</searchType>
</column>
<column>
<label>Service Status</label>
<field>uf:service_status</field>
<width>80</width>
<searchType>string</searchType>
</column>
<column>
<label>Date Updated</label>
<field>dateUpdated</field>
<width>140</width>
<searchType>date</searchType>
</column>
<column>
<label>#</label>
<field>occurrences</field>
<width>40</width>
<searchType>number</searchType>
</column>
<column>
<label>Host Name</label>
<field>uf:host_name</field>
<width>80</width>
<searchType>string</searchType>
</column>
<column>
<label>Host Status</label>
<field>uf:host_status</field>
<width>80</width>
<searchType>string</searchType>
</column>

<column>
<label>State</label>
<field>ServiceState</field>
<width>40</width>
<searchType>number</searchType>
</column>

</columns>
</grid>


But its only showing the Integration ID Date and # fields. Remaining all are empty.


Regards
Arunamshu
Up 0 rated Down
Matthew Sweeney Apr 01, 2015 10:57AM UTC Interlink Software Agent
Hi Arunamshu,

Great!

Configuring the AID can be quite tricky. We have a new and improved version of the AID in the next release of ASI.

However, you should still be able to display the user fields in the columns, can you try the following:

Replace:
<field>uf:service_status</field>

With:
<field>:nn-userfield('service_status')</field>

Do this for each user field, replacing service_status with the corresponding user field. Does this then work?

Regards,
Matt
Up 0 rated Down
Arunamshu Udayakumar Apr 02, 2015 06:37AM UTC
Hi Matt,

This one is finally done. Thanks!

Regards
Arunamshu

This question has received the maximum number of answers.

Contact Us

desk.com@interlinksoftware.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete