2 Replies Latest reply on Jun 2, 2009 8:47 AM by Hentie

    ePO 4 and patch 4 installation failure - SQL

      Tried installing patch 4 on a ePO 4.0 server. The SQL resides on a remote SQL server that host other data bases.

      The core-patch log

       


      [echo] catalina.home is X:/PROGRA~1/McAfee/EPOLIC~1/server

      backup-config:
      [echo] backing up tomcat configuration files
      [delete] Deleting 48 files from X:\Program Files\McAfee\ePolicy Orchestrator\Installer\core\bak\config
      [copy] Copying 48 files to X:\Program Files\McAfee\ePolicy Orchestrator\Installer\core\bak\config

      upgrade-server-xml:
      [xslt] Processing X:\PROGRA~1\McAfee\EPOLIC~1\server\conf\server.xml to X:\PROGRA~1\McAfee\EPOLIC~1\server\conf\server-modified.xml
      [xslt] Loading stylesheet X:\Program Files\McAfee\ePolicy Orchestrator\Installer\core\scripts\upgrade-server.xsl
      [xslt] X:/Program%20Files/McAfee/ePolicy%20Orchestrator/Installer/core/scripts/upgrade -server.xsl:3: Warning! Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor
      [move] Moving 1 file to X:\PROGRA~1\McAfee\EPOLIC~1\server\conf

      db-upgrade:
      [run-sql] log4j:WARN No appenders could be found for logger (com.mcafee.orion.core.db.base.Database).
      [run-sql] log4j:WARN Please initialize the log4j system properly.
      [run-sql] java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
      [run-sql] at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367)
      [run-sql] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
      [run-sql] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
      [run-sql] at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:609)
      [run-sql] at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:344)
      [run-sql] at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
      [run-sql] at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
      [run-sql] at java.sql.DriverManager.getConnection(DriverManager.java:582)
      [run-sql] at java.sql.DriverManager.getConnection(DriverManager.java:185)
      [run-sql] at com.mcafee.orion.core.db.base.Database.getConnectionNoPool(Database.java:347)
      [run-sql] at com.mcafee.orion.core.db.base.SqlUtil.executeSql(SqlUtil.java:63)
      [run-sql] at com.mcafee.orion.core.db.base.SqlUtil.executeSqlFile(SqlUtil.java:133)
      [run-sql] at com.mcafee.orion.core.db.base.SqlUtil.executeSqlFile(SqlUtil.java:115)
      [run-sql] at com.mcafee.orion.core.install.RunSqlTask.execute(RunSqlTask.java:58)
      [run-sql] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
      [run-sql] at org.apache.tools.ant.Task.perform(Task.java:364)
      [run-sql] at org.apache.tools.ant.Target.execute(Target.java:341)
      [run-sql] at org.apache.tools.ant.Target.performTasks(Target.java:369)
      [run-sql] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
      [run-sql] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
      [run-sql] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java :40)
      [run-sql] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
      [run-sql] at org.apache.tools.ant.Main.runBuild(Main.java:668)
      [run-sql] at org.apache.tools.ant.Main.startAnt(Main.java:187)
      [run-sql] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
      [run-sql] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)

      BUILD FAILED
      X:\Program Files\McAfee\ePolicy Orchestrator\Installer\core\build.xml:444: java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

      Total time: 2 seconds



      Installation worked fine in the lab where the SQL was on the same server as the ePO server.