Thanks. Yes, I did an in-place upgrade on another machine last night and that went OK. The ISO install on another test machine is where I am having this issue. I should probably install the old version and do an in-place upgrade to get around this.
btw, if anyone wants to look into it... The in-place upgrade had the following error. Probably not a big deal. **** Updating : sipxconfig-ftp 3/82 error: %post(sipxconfig-ftp-4.1.6-018058.i386) scriptlet failed, exit status 1 **** On Feb 22, 2010, at 1:46 PM, Tony Graziano wrote: > Looks like a sql issue with branch: > > one.xxx.yyy.com:main:00000000:JDBCExceptionReporter > :"ERROR: relation \"branch\" does not exist" > "2010-02 > > I didn't have thhis same issue with an inplace upgrade but have not > installed a 4.1.8 iso yet. > ============================ > Tony Graziano, Manager > Telephone: 434.984.8430 > Fax: 434.984.8431 > > Email: [email protected] > > LAN/Telephony/Security and Control Systems Helpdesk: > Telephone: 434.984.8426 > Fax: 434.984.8427 > > Helpdesk Contract Customers: > http://www.myitdepartment.net/gethelp/ > > ----- Original Message ----- > From: [email protected] > <[email protected]> > To: Sipx-users list <[email protected]> > Sent: Mon Feb 22 16:00:43 2010 > Subject: [sipx-users] 4.1.6.018058 ISO issue > > Has anyone successfully run the 4.1.6.018058 ISO? > > After install, when I visit the web GUI, I get: > HTTP ERROR: 404 > > /sipxconfig Not Found > RequestURI=/sipxconfig > > Powered by Jetty:// > > > sipxconfig.log says the following: > > "2010-02-22T20:51:11.619000Z":1:JAVA:INFO:pbx.phone.xxx.yyy.com:main:00000000:DynamicSessionFactoryBean:"Building > new Hibernate SessionFactory" > "2010-02-22T20:51:28.839000Z":2:JAVA:INFO:pbx.phone.xxx.yyy.com:main:00000000:FirstRunTask:"Handling > task first-run" > "2010-02-22T20:51:28.839000Z":3:JAVA:INFO:pbx.phone.xxx.yyy.com:main:00000000:FirstRunTask:"Executing > first run tasks..." > "2010-02-22T20:51:28.840000Z":4:JAVA:INFO:pbx.phone.xxx.yyy.com:main:00000000:DomainManagerImpl:"Attempting > to load initial domain-config from > /etc/sipxpbx):""2010-02-22T20:51:28.870000Z":5:JAVA:WARNING:pbx.phone.xxx.yyy.com:main:00000000:JDBCExceptionRepo > rter:"SQL Error: 0, SQLState: 42P01" > "2010-02-22T20:51:28.870000Z":6:JAVA:ERR:pbx.phone.xxx.yyy.com:main:00000000:JDBCExceptionReporter > :"ERROR: relation \"branch\" does not exist" > "2010-02-22T20:51:36.324000Z":7:JAVA:WARNING:pbx.phone.xxx.yyy.com:main:00000000:Server:"EXCEPTION > " > org.mortbay.util.MultiException[org.springframework.dao.InvalidDataAccessResourceUsageException: > coul > d not execute query; nested exception is > org.hibernate.exception.SQLGrammarException: could not execu > te query] > at org.mortbay.http.HttpServer.doStart(HttpServer.java:731) > at org.mortbay.util.Container.start(Container.java:72) > at org.mortbay.jetty.Server.main(Server.java:433) > org.springframework.dao.InvalidDataAccessResourceUsageException: could not > execute query; nested exce > ption is org.hibernate.exception.SQLGrammarException: could not execute > query > Caused by: org.hibernate.exception.SQLGrammarException: could not execute > query > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) > at org.hibernate.loader.Loader.doList(Loader.java:2220) > at > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108) > at org.hibernate.loader.Loader.list(Loader.java:2103) at > org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1570) > at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) > at > org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.jav > a:535) > at > org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:369) > at > org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:531) > at > org.sipfoundry.sipxconfig.admin.commserver.LocationsManagerImpl.getLocations(Unknown > Sourc > e) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMet > hodInvocation.java:172) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) > at > org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:1 > 04) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvoc > ation.java:161) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) > at $Proxy2.getLocations(Unknown Source) > at > org.sipfoundry.sipxconfig.domain.DomainManagerImpl.getAlliasesFromDomainConfig(Unknown > Sou > rce) at > org.sipfoundry.sipxconfig.domain.DomainManagerImpl.parseDomainConfig(Unknown > Source) > at > org.sipfoundry.sipxconfig.domain.DomainManagerImpl.initializeDomain(Unknown > Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMet > hodInvocation.java:172) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvoc > ation.java:139) > at > org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:104) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvoc > ation.java:161) at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) > at $Proxy6.initializeDomain(Unknown Source) at > org.sipfoundry.sipxconfig.admin.FirstRunTask.runTask(Unknown Source) > at org.sipfoundry.sipxconfig.admin.FirstRunTask.onApplicationEvent(Unknown > Source) > at > org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77) > at > org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49) > at > org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75) > at > org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246) > at > org.sipfoundry.sipxconfig.site.ContextLoaderListener.contextInitialized(Unknown > Source) > at > org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:497) > at org.mortbay.util.Container.start(Container.java:72) > at org.mortbay.http.HttpServer.doStart(HttpServer.java:753) > at org.mortbay.util.Container.start(Container.java:72) > at org.mortbay.jetty.Server.main(Server.java:433) > Caused by: org.postgresql.util.PSQLException: ERROR: relation "branch" does > not exist > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187) > at org.hibernate.loader.Loader.getResultSet(Loader.java:1791) > at org.hibernate.loader.Loader.doQuery(Loader.java:674) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) > at org.hibernate.loader.Loader.doList(Loader.java:2217) > ... 46 more > > > Thanks. _______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users sipXecs IP PBX -- http://www.sipfoundry.org/
