Doesn't the ISO install wipe out everything from before? On Feb 22, 2010, at 1:56 PM, Huijun Yang wrote:
> The sql error indicates that your system has old database data prior to > 4.1.6 install. Run upgrade should solve your problem. > > Huijun > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Pizza > Napoletana > Sent: Monday, February 22, 2010 4:53 PM > To: Tony Graziano > Cc: [email protected] > Subject: Re: [sipx-users] 4.1.6.018058 ISO issue > > 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:0 >> 0000000:DynamicSessionFactoryBean:"Building >> new Hibernate SessionFactory" >> "2010-02-22T20:51:28.839000Z":2:JAVA:INFO:pbx.phone.xxx.yyy.com:main:0 >> 0000000:FirstRunTask:"Handling >> task first-run" >> "2010-02-22T20:51:28.839000Z":3:JAVA:INFO:pbx.phone.xxx.yyy.com:main:0 >> 0000000:FirstRunTask:"Executing >> first run tasks..." >> "2010-02-22T20:51:28.840000Z":4:JAVA:INFO:pbx.phone.xxx.yyy.com:main:0 >> 0000000: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:00 >> 000000:JDBCExceptionReporter >> :"ERROR: relation \"branch\" does not exist" >> "2010-02-22T20:51:36.324000Z":7:JAVA:WARNING:pbx.phone.xxx.yyy.com:mai >> n:00000000:Server:"EXCEPTION >> " >> > org.mortbay.util.MultiException[org.springframework.dao.InvalidDataAcces > sResourceUsageException: >> 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.ja >> va: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(H >> ibernateTemplate.jav >> a:535) >> at >> > org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTe > mplate.java:369) >> at >> org.springframework.orm.hibernate3.HibernateTemplate.loadAll(Hibernate >> Template.java:531) >> at >> org.sipfoundry.sipxconfig.admin.commserver.LocationsManagerImpl.getLoc >> ations(Unknown >> Sourc >> e) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >> ava:39) >> at >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.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.invokeJoi >> npoint(ReflectiveMet >> hodInvocation.java:172) >> at >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref > lectiveMethodInvocation.java:139) >> at >> org.springframework.orm.hibernate3.HibernateInterceptor.invoke(Hiberna >> teInterceptor.java:1 >> 04) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R >> eflectiveMethodInvoc >> ation.java:161) >> at >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo > pProxy.java:203) >> at $Proxy2.getLocations(Unknown Source) >> at >> org.sipfoundry.sipxconfig.domain.DomainManagerImpl.getAlliasesFromDoma >> inConfig(Unknown >> Sou >> rce) at >> org.sipfoundry.sipxconfig.domain.DomainManagerImpl.parseDomainConfig(U >> nknown >> Source) >> at >> > org.sipfoundry.sipxconfig.domain.DomainManagerImpl.initializeDomain(Unkn > own >> Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >> ava:39) >> at >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.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.invokeJoi >> npoint(ReflectiveMet >> hodInvocation.java:172) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R >> eflectiveMethodInvoc >> ation.java:139) >> at >> > org.springframework.orm.hibernate3.HibernateInterceptor.invoke(Hibernate > Interceptor.java:104) >> at >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref > lectiveMethodInvoc >> ation.java:161) at >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo > pProxy.java:203) >> at $Proxy6.initializeDomain(Unknown Source) at >> org.sipfoundry.sipxconfig.admin.FirstRunTask.runTask(Unknown Source) >> at >> org.sipfoundry.sipxconfig.admin.FirstRunTask.onApplicationEvent(Unknow >> n >> Source) >> at >> > org.springframework.context.event.SimpleApplicationEventMulticaster$1.ru > n(SimpleApplicationEventMulticaster.java:77) >> at >> > org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor. > java:49) >> at >> > org.springframework.context.event.SimpleApplicationEventMulticaster.mult > icastEvent(SimpleApplicationEventMulticaster.java:75) >> at >> > org.springframework.context.support.AbstractApplicationContext.publishEv > ent(AbstractApplicationContext.java:246) >> at >> org.sipfoundry.sipxconfig.site.ContextLoaderListener.contextInitialize >> d(Unknown >> Source) >> at >> > org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationCo > ntext.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(QueryExecu > torImpl.java:1548) >> at >> > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp > l.java:1316) >> at >> > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: > 191) >> at >> > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme > nt.java:452) >> at >> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb > c2Statement.java:351) >> at >> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St > atement.java:255) >> at >> > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxy > PreparedStatement.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(Loade > r.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/ _______________________________________________ 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/
