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

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.

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

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)

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?

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

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

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

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

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

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

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

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

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

Hi Matt,

This one is finally done. Thanks!

Regards
Arunamshu