Connect RMP with on-premise SQL Server database

[toni.vida...@gmail.com]

Hi guys,

I need to connect RMP with one SQL Server 2012 database. I have already installed SEC Manager,SEC Agent and JDBC but this generates the following runtime jvm error:

ago 25, 2014 11:25:30 AM org.runmyprocess.sec.SECLogManager log
Informaci¾n: Starting JDBC Adapter...
ago 25, 2014 11:25:30 AM org.runmyprocess.sec.SECLogManager log
Informaci¾n: JDBC Adapter Started
ago 25, 2014 11:25:32 AM org.runmyprocess.sec.PingThread run
Advertencia: null
java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.runmyprocess.sec.PingThread.run(PingThread.java:64)



JDBC.config
#DBAgent Configuration
SQLSERVER_2005 = {"sqlDriver" : "com.microsoft.sqlserver.jdbc.SQLServerDriver", "sqlSource" : "jdbc:sqlserver://127.0.0.1:1433/RMP-AUTH?characterEncoding=UTF-8","sqlDriverPath" : "C:\sqljdbc_4.0\esn\sqljdbc.jar"}

handler.config
#Generic Protocol Configuration
protocol = JDBC
protocolClass = org.runmyprocess.sec.JDBC
handlerHost = 127.0.0.1
connectionPort = 5832
managerHost = 127.0.0.1
managerPort = 4444
pingFrequency = 300

Any help about this?

Thanks in advance,

Toni

[Dimitri MELCHIOR Pro]

Hi Sir,

It seems that your Secure Entreprise Connector is not running. Could you confirm that you launched :

• SECdata-agent
• SEMManager
• JDBC Adapter

Best regards.

--

Dimitri MELCHIOR

PreSales Consultant

Contact: dmel...@runmyprocess.com

Tel: +33(0)1 75 77 51 78

Mobile : +33(0)6 52 70 89 82

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/934d90c0-8692-46f5-9e08-98c43534c771%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[toni.vida...@gmail.com]

Yes, all components were launched. Attached files.

start_RMP_SEC.bat
@echo on
call start "Tunnel" C:\sec-agent-zicatela\runagent.bat
call start "Manager" C:\SECManager-zicatela\manager-zicatela\runManager.bat
cd C:\JDBCAdapter
call start "JDBCAdapter" java -jar JDBC.jar

On Monday, August 25, 2014 12:56:07 PM UTC+2, Dimitri Melchior wrote:
> Hi Sir,
>
>
> It seems that your Secure Entreprise Connector is not running. Could you confirm that you launched :

> SECdata-agentSEMManagerJDBC Adapter

>
> Best regards.
>
>
>
>
> --
> Dimitri MELCHIOR
>
>
>
>
> PreSales Consultant
> Contact: dmel...@runmyprocess.com
>
>
> Tel: +33(0)1 75 77 51 78
> Mobile : +33(0)6 52 70 89 82
> Website: Fujitsu RunMyProcess
>
>
>
>      
>
>
>
>
>
>
>

[Dimitri MELCHIOR Pro]

Other hand, do you have another Adapter already installed?

If yes, you must change your JDBC Adapter connection port from

connectionPort = 5832

to :

connectionPort = 5835

Best regards.

--

Dimitri MELCHIOR

PreSales Consultant

Contact: dmel...@runmyprocess.com

Tel: +33(0)1 75 77 51 78

Mobile : +33(0)6 52 70 89 82

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/a075ce27-91df-4cd3-acc3-df1b96500755%40runmyprocess.com.

[toni.vida...@gmail.com]

It seems that agent run correctly but JDBC adaptor persists one console error:

ago 25, 2014 2:27:06 PM org.runmyprocess.sec.SECLogManager log

Informaci¾n: Starting JDBC Adapter...

ago 25, 2014 2:27:06 PM org.runmyprocess.sec.SECLogManager log

Informaci¾n: JDBC Adapter Started

ago 25, 2014 2:27:07 PM org.runmyprocess.sec.PingThread run

Advertencia: null
java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.runmyprocess.sec.PingThread.run(PingThread.java:64)

java.lang.NullPointerException
java.lang.NullPointerException


Best regards,

Toni

El lunes, 25 de agosto de 2014 13:57:23 UTC+2, Dimitri Melchior escribió:
> Other hand, do you have another Adapter already installed?
>
>

> If yes,you must change your JDBC Adapter connection port from

>
>
> connectionPort = 5832
>
>
>
>
> to :
>
>
>
> connectionPort = 5835
>
>
>
>
> Best regards.
>
>
>
>
> --
>
> Dimitri MELCHIOR
>
>
>
>
> PreSales Consultant
> Contact: dmel...@runmyprocess.com
>
> Tel: +33(0)1 75 77 51 78
> Mobile : +33(0)6 52 70 89 82
>
> Website: Fujitsu RunMyProcess
>
>
>      
>
>
>
>
>
>
>

[Dimitri MELCHIOR Pro]

Did you change the connectionport?

--

Dimitri MELCHIOR

PreSales Consultant

Contact: dmel...@runmyprocess.com

Tel: +33(0)1 75 77 51 78

Mobile : +33(0)6 52 70 89 82

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/b3a2c0fa-5d33-4f18-bb97-27b2e41777c6%40runmyprocess.com.

[toni.vida...@gmail.com]

Yes

protocol = JDBC
protocolClass = org.runmyprocess.sec.JDBC
handlerHost = 127.0.0.1

connectionPort = 5835

managerHost = 127.0.0.1
managerPort = 4444
pingFrequency = 300

El lunes, 25 de agosto de 2014 16:07:44 UTC+2, Dimitri Melchior escribió:
> Did you change the connectionport?
>
>
>
>
> --
>
> Dimitri MELCHIOR
>
>
>
>
> PreSales Consultant
> Contact: dmel...@runmyprocess.com
>
> Tel: +33(0)1 75 77 51 78
> Mobile : +33(0)6 52 70 89 82
>
> Website: Fujitsu RunMyProcess
>
>
>      
>
>
>
>
>
>
>

[Nicolas Triballier]

Hi Toni,

Also, seems like you haven't encoded the sqlDriverPath :

cf http://docs.runmyprocess.com/Integration_Guide/SEC/Adapters/JDBC#install-and-configure-the-adapter

=> 

In the DBAgent.config file, the Database configuration must be set. The adapter will look for the correct configuration depending on the DBType. The DBAgent.config file should look like this :

1 2 3 4 5

#DBAgent Configuration MYSQL = {"sqlDriver" : "com.mysql.jdbc.Driver", "sqlSource" : "jdbc:mysql://localhost:3306/mydb?characterEncoding=UTF-8","sqlDriverPath" : "C:/\Program Files (x86)/\Fujitsu RunMyProcess/\Secure Enterprise Connector/\drivers_jdbc/\mysql/\mysql-connector-java-5.1.28-bin.jar"} SQLSERVER_2004 = {"sqlDriver" : "com.microsoft.jdbc.sqlserver.SQLServerDriver", "sqlSource" : "jdbc:microsoft:sqlserver://localhost:1433/mydatabase?characterEncoding=UTF-8","sqlDriverPath" : "C:/\Program Files (x86)/\Fujitsu RunMyProcess/\Secure Enterprise Connector/\drivers_jdbc/\sql/\sql-connector-java-1.1.jar"} SQLSERVER_2005 = {"sqlDriver" : "com.microsoft.sqlserver.jdbc.SQLServerDriver", "sqlSource" : "jdbc:sqlserver://localhost:1433/mydatabase?characterEncoding=UTF-8","sqlDriverPath" : "C:/\Program Files (x86)/\Fujitsu RunMyProcess/\Secure Enterprise Connector/\drivers_jdbc/\sql/\sql-connector-java-1.1.jar"} ORACLE_11_EXPRESS = {"sqlDriver" : "oracle.jdbc.driver.OracleDriver", "sqlSource" : "jdbc:oracle:thin://localhost:1521/XE/mydatabase?characterEncoding=UTF-8","sqlDriverPath" : "C:/\Program Files (x86)/\Fujitsu RunMyProcess/\Secure Enterprise Connector/\drivers_jdbc/\oracledb/\oracle-connector-java-1.1.jar"}

Each line of the config file must be populated with the information of the DB we are trying to connect to. Note that you must download the corresponding JDBC driver file, and provide its path, the driver name, the protocol, the port, and the name of the DB.

Also, use the escape characters to navigate through folders on Windows machines.

=> so you should modify your #DBAgent Configuration file:

SQLSERVER_2005 = {"sqlDriver" : "com.microsoft.sqlserver.jdbc.SQLServerDriver", "sqlSource" : "jdbc:sqlserver://127.0.0.1:1433/RMP-AUTH?characterEncoding=UTF-8","sqlDriverPath" : "C:\sqljdbc_4.0\esn\sqljdbc.jar"}

ttyl

Nicolas

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/2f814103-baf5-4a09-9582-deb482b2c7df%40runmyprocess.com.

[toni.vida...@gmail.com]

Hi Nicolas,

It seems that the JDBC adapter did not run correctly because previously there was not enough time for the manager to have the available ports. This is solved.

Now, the problem comes with "502 Bad Gateway" message that service returns me.

Any idea ?

Thanks in advance.
Toni

[Dimitri MELCHIOR Pro]

Hi Toni,

Whar's the amount of data transfered?

Best regards

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/b5a18d43-abd3-4810-bfab-34cd74684c08%40runmyprocess.com.

[toni.vida...@gmail.com]

Very little information. It's a query that should return 2 records with 2 fields.

Regards.

> ><br...

[Pray Desai]

Hi Toni,

Can you check if you are succesfully able to send a GET request to your protocol manager by launching test on a connector via your configured SEC domain from RunMyProcess ? Let us know what result you get.

You should see this result (if SEC tunnel is established and listens to your DB agent) :

​

Let us know if you see the above response then we can check your JDBC configurations.


-- 

Regards,

Pray Desai,

Fujitsu RunMyProcess.

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/345e21b5-b5a2-434d-aa1f-0f1954a92d60%40runmyprocess.com.

[toni.vida...@gmail.com]

Thank you guys, now it works correctly.

El jueves, 28 de agosto de 2014 07:19:51 UTC+2, Pray Desai escribió:
> Hi Toni,
>
>
>
> Can you check if you are succesfully able to send a GET request to your protocol manager by launching test on a connector via your configured SEC domain from RunMyProcess ? Let us know what result you get.
>
>
>
>
>
>
>
>
>
>
>
>
>

> You should see this result (if SEC tunnel is established and listens to your DB agent) :
>
>
>
>
> ​
>

> Let us know if you see the above response then we can check your JDBC configurations.
>
>
>
> -- 
>
>
> Regards,
> Pray Desai,
> Fujitsu RunMyProcess.
>
>
>
>
> On Wed, Aug 27, 2014 at 3:59 AM, <toni.vida...@gmail.com> wrote:
>

> ...