DLO DEDUPE problem with configuration

TCP/IP was disabled.

I enabled Named Pipes but i didn't noticed that TCP/IP is disabled.

Thank you for help

Lines from server.xml:

<Connector acceptorThreadCount="2" connectionTimeout="20000" executor="tomcatThreadPool" port="8080" protocol="org.apache.coyote.http11.Http11NioProtocol" redirectPort="8443" server=" "/>
 

 <Connector SSLEnabled="true" SSLProtocol="TLS" acceptorThreadCount="2" ciphers="TLS_RSA_WITH_AES_128_CBC_SHA,TLS_DHE_RSA_WITH_AES_128_CBC_SHA,TLS_DHE_DSS_WITH_AES_128_CBC_SHA,SSL_RSA_WITH_3DES_EDE_CBC_SHA,SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA,SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA" clientAuth="false" executor="tomcatThreadPool" keystoreFile="dedupeserver.jks" keystorePass="dedupeserver" port="8443" protocol="org.apache.coyote.http11.Http11NioProtocol" scheme="https" secure="true" server=" "/>
 

Log from DeDupeserver.log

[11/06/2014], [10:33:57:548], [ERROR], [Thread-4], [localhost], DBConnection::getConnection: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server SDLO is not configured to listen with TCP/IP.)
[11/06/2014], [10:33:57:548], [ERROR], [Thread-4], [localhost], DBConnectionDAO::run: (20002) Could not get database connection. Cannot create PoolableConnectionFactory (The server SDLO is not configured to listen with TCP/IP.)
[11/06/2014], [10:33:57:548], [DEDUPE_TRACE], [Thread-4], [localhost], DBConnectionDAO::run: Connection to the Database failed. Server will retry after 180000 milliseconds.
 

I attached list of opened ports. I can telent to them.

Edit server.xml file located at \Program Files\Symantec\Symantec DLO\Dedupe Server\Tomcat\conf\

Confirm the HTTP & HTTPS port numbers mentioned in this file.

Check the DeDupeserver.log found at :\Program Files\Symantec\Symantec DLO\DedupeServer\Tomcat\logs

Lastly, try this KB as well - http://www.symantec.com/business/support/index?page=content&id=TECH210450

 

In event viewer is error:

The description for Event ID 0 from source DLO Admin Console cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

06/10/2014, 15:31:25:916, 3716, 3720, [Error],"WebServerRequest::RunWebRequest: curl error code = 28; curl error message = Operation timed out after 300688 milliseconds with 0 out of 0 bytes received; Retrying to connect..."

and

06/10/2014, 15:41:27:214, 3716, 3720, [Error],"CRESTHashStoreProxy::HandleCommonServerError/(ERRORLOGGER): Error Code = 23022; Error Message = Could not connect to server host.

WebService API = closeSession; No. of hash = 0; "

and

06/10/2014, 15:41:27:214, 3716, 3720, [Error],"WebServerRequest::RunWebRequest: curl error code = 3; curl error message = <url> malformed"

 

After 10 min of waiting i received error from DLO Console:

The server Host or port details you have entered is invalid or there is no dedupe server running at the specified location

Ports are listening and firewall is turned off

 

 

How can I turn on debugging ?

The second sql query which I mentioned earlier was to add your domain account to the DeDupe DB. Manually, adding the user and providing it appropriate user mapping roles/membership would also help.

Are there any errors/warnings in the event viewer ?

Would recommend to enable debugging as well so that we can try to find out why there is an issue during the DeDupe configuration.

SQL instance, DeDupe and DLO Admin services use the same admin rights.

I have run scripts and still is the same problem.

I found one difference between security configuration DLO database and DedupeDB. Could this be a source of my problems ( I attached print screen from MS SQL Management Studio)?
I tried add entry for domain account for dlo but it didnt help,

No, DeDupe does not require any other instance.

Is the Mindtree Storesmart DeDupe server service running ?

Do ensure the SQL instance, DeDupe and DLO Admin services are running under the same account. Run the following SQL queries via cmd as well so that your domain account has appropriate privileges ~

sqlcmd.exe -E -l 60 -S SERVERNAME\INSTANECENAME -d DedupeDB -Q "EXEC
sp_addsrvrolemember 'DOMAINNAME\USERNAME', 'sysadmin'"

sqlcmd.exe -E -S.\INSTANECENAME -d DedupeDB -Q "insert into
user_info values (5,'DOMAINNAME\USERNAME',NULL,1)"

Lastly, do ensure remote connections are enabled to your SQL instance as well.

Yes, I chose the option of existing SQL instance. Does DeDupe need second SQL instance?

I installed DLO as local admin. For other things I use my domain account with admin rights (to run console, SQL/DLO services are using my account).

Now I noticed that i cant stop tomcat service using Services Console. I have to kill the process.

Did you choose the option of existing SQL instance when you configured SDLO for the first time ?

If not, you will have to attach the DLO and DeDupe DBs to your existing instance and also modify certain registry keys/files to update the instance name.

And under what user account are you logged in to the DLO server ? Is this the same account which was used to install DLO and is this the same account used for the SQL / DLO services ?