nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Possible to deploy to external database?

System

Is it possible to deploy content to an external database via its IP? i can connect fine to the external DB in Toad, but when i drop it in the database.xml i get the following error - any help/thoughts would be greatly appreciated, thanks.

[HTML] [/HTML]

DBD: Loading com.inet.tds.TdsDriver
DBD: url : jdbc:inetdae:65.36.****.xx?database=mitch_testing&sql7=true
DBD: login : cms-test
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:inetdae:65.36.****.xx?database=mitch_testing&sql7=true...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc:inetdae:65.36.****.xx?database=mitch_testing&sql7=true]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: [TDS Driver]Connection was closed from the SQL Server site or network at header (0)
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [TDS Driver]Connection was closed from the SQL Server site or network at header (0)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.(Unknown Source)
at com.inet.tds.TdsDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.interwoven.dd100.dd.JdbcCheckup.MakeConnection(JdbcCheckup.java:447)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:551)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:550)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:272)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: ERROR:Could not connect to [65.36.243.12?database=mitch_testing]
DBD: ERROR:Unable to connect to 65.36.243.12?database=mitch_testing
DBD: ERROR:TDbAgent constructor failed.

Find more posts tagged with

Comments

nipper

I would be surprised if the IP is the issue. Try putting the host into the hosts file and try by hostname.

Migrateduser

Is mitch_testing running sql server express? If so, then I don't believe you will be able be able to connect until you turn on tcp/ip.

http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx

Just guessing of course.

Also, is your sql server running on port 1433?

db="myhostname:1433?database=mydb"
user="sa"
password="mypassword"
vendor = "microsoft-inetuna"
max-id-length = "128" />

Migrateduser

1) I tried adding the server to the hosts file on the OD server, this didnt work (i think i did it correctly)

C:\WINDOWS\system32\drivers\etc\hosts

new line added:
65.36.****.xx online.school.edu oheau

2) they are on the regular sql server 2000 - im not sure about the port, as its a external vendor provided DB, i can find out hopefully

DBD: Setting up TDbSchemaAgent.
DBD: >>> Loading drivers <<<
DBD: Loading com.informix.jdbc.IfxDriver
DBD: Loading oracle.jdbc.driver.OracleDriver
DBD: Loading com.sybase.jdbc2.jdbc.SybDriver
DBD: Loading COM.ibm.db2.jdbc.net.DB2Driver
DBD: Loading sun.jdbc.odbc.JdbcOdbcDriver
DBD: Loading com.inet.tds.TdsDriver
DBD: url : jdbc:inetdae Smiley Surprised

heau?database=mitch_testing&sql7=true
DBD: login : cms-test
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:inetdae Smiley Surprised

heau?database=mitch_testing&sql7=true...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc:inetdae Smiley Surprised

heau?database=mitch_testing&sql7=true]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: [TDS Driver]Connection was closed from the SQL Server site or network at header (0)
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [TDS Driver]Connection was closed from the SQL Server site or network at header (0)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.(Unknown Source)
at com.inet.tds.TdsDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.interwoven.dd100.dd.JdbcCheckup.MakeConnection(JdbcCheckup.java:447)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:551)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:550)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:272)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: ERROR:Could not connect to [oheau?database=mitch_testing]
DBD: ERROR:Unable to connect to oheau?database=mitch_testing
DBD: ERROR:TDbAgent constructor failed.
DBD: Error occured in TDbSchemaAgent
DBD: Stat for group [test_name]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Event reporting turned on
DBD: Rollback database [oheau?database=mitch_testing]...
DBD: Deployment[news_qa]
DBD: Closing database connection
DBD: ERROR:Exception4: java.lang.NullPointerException
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbAgent.Close(TDbAgent.java:3584)
at com.interwoven.dd100.dd.TDbSchemaAgent.Close(TDbSchemaAgent.java:506)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:519)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD:
### IWDataDeploy FAILED ###

DBD:
### Sending result ###

ENG: 2010-01-19 09:49:39 EST GMT-05:00 Database deployment execution returned 1

ENG: 2010-01-19 09:49:39 EST GMT-05:00 <<< Completed database deployment Invocation>>>

ENG: 2010-01-19 09:49:39 EST GMT-05:00 Manifest path is

/Interwoven/OpenDeployNG/log/DataDeploy/src.OheDbTest_109067_ebarker.news_qa.CSDCMSADM01.to.database.log.mf

ENG: 2010-01-19 09:49:39 EST GMT-05:00 Got Manifest object com.interwoven.od.adapter.delivery.base.IWODManifest@1487e30

ENG: 2010-01-19 09:49:39 EST GMT-05:00 fHasFailedItems is set to true

ENG: 2010-01-19 09:49:39 EST GMT-05:00 Published leg event depUuid=[187fd6c0-0509-11df-8fca-87619cdb3c14] legLabel=[database] nextUuid=[null] nextDep=[null]
ENG: 2010-01-19 09:49:39 EST GMT-05:00 Job ID=m2 Deployment leg=database Elapsed Time=332520 ms <<<
ENG: 2010-01-19 09:49:39 EST GMT-05:00 End logfile [D:\Interwoven\OpenDeployNG\log\DataDeploy\src.OheDbTest_109067_ebarker.news_qa.CSDCMSADM01.to.database.log]

nipper

Fromthe TS server run:

telnet SQLSERVER 1433

post the results

Migrateduser

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

telnet 65.36.****.xx 1433
telnet MySiteFromHosts 1433

both go right a to blank black command window (which is what to expect from google apparently? "but you won't achieve nothing... SQL Server will just close the connection as soon as you start typing in because it does not understand what the telnet program is sending.")

i also tried adding the remote ftp IP as an ODBC SYSTEM DSN(which tests fine) but also doesn't work in OD/DD.

nipper

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

telnet 65.36.****.xx 1433
telnet MySiteFromHosts 1433

both go right a to blank black command window (which is what to expect from google apparently? "but you won't achieve nothing... SQL Server will just close the connection as soon as you start typing in because it does not understand what the telnet program is sending.")

i also tried adding the remote ftp IP as an ODBC SYSTEM DSN(which tests fine) but also doesn't work in OD/DD.

OK, telnet was correct, I am confused why you are using JDBC connection when you have an ODBC open.

Migrateduser

Not sure, i just tried the ODBC as another option. OD appears to default to JDBC? the settings in database.xml are exactly the same as our other connections to sql server databases (which work fine)- should i switch those attributes or point to a specific ODBC driver?

the commented out example i see in database.xml has

jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
vendor = "microsoft-microsoft"

[HTML] [/HTML]

Migrateduser

I found this in the documentation...but it looks like the UNA2000.jar is in place? how would i reference that in database.xml?

Use JDBC type 4 drivers from i-net software if you are using Microsoft SQL Server 2000. The i-net driver is packaged with OpenDeploy and resides in the following location:
od-home/drivers/UNA2000.jar.