DLP scanning of MySQL 5.5 target
Created: 20 Nov 2012 | Updated: 14 Dec 2012 | 5 comments
This issue has been solved. See solution.
I configured MySQL 5.5 Server with one Network Discovery Server but when I run the scan I get this error. I searched this over symantec connect forum but could not find any specific solution to this error.
| WARNING | Failed to read sqlserver:@//172.1.1.1:3306/sakila; error: Unable to create a database connection: Unable to create connection: jdbc:jtds:sqlserver:@//172.1.1.1:3306/sakila, Reason: The syntax of the connection URL 'jdbc:jtds:sqlserver:@//172.1.1.1:3306/sakila' is invalid. |
Discussion Filed Under:
Comments 5 Comments • Jump to latest comment
I removed the @ sign in the string now I am getting this error.
Failed to read sqlserver://172.1.1.1:3306/sakila; error: Unable to create a database connection: Unable to create connection: jdbc:jtds:sqlserver://172.1.1.1:3306/sakila, Reason: I/O Error: Unknown packet type 0x45
Anyone???
Hi Atif,
Please refer
If you are using a domain account for scanning SQL Server databases, the syntax of “<domain>\<username>” in the credentials field of the scan will not work. This syntax will cause a login error on the scan.
In order to specify the domain, it must be included in the database connection string using the following syntax:
SQLSERVER://<server>:<port>/<database>;domain=<domain>
In the scan credentials field, you then must specify the domain user name without the domain qualification.
More information on the exact syntax of the database call through the JTDS driver can be found at:
http://jtds.sourceforge.net/faq.html#instanceName
Hi Atif,
Also find the below
To enable SQL Query logging in the Manager:
Once SQL logging is enabled, go into the UI and perform any task that is perceived as slow; i.e., run reports, select incidents -- whatever takes more time than it should.
Any SQL statement not executed through OJB will be logged to \Vontu\Protect\logs\jdbc.log along with the time it took to execute the statement.
After performing this test:
Thanks Kishorilal,
Can you please confirm that last post of your is related to SQL scanning or Enforce performance issue? I am asking this question because we are facing severe Enforce performance issue at one our clients and I doubt that their database (external instance provided by client) is the cause of slow enforce performance. Do you suggest that above steps are for performance related issue or for SQL target scanning?
Regards
Would you like to reply?
Login or Register to post your comment.