It should have reformatted the drive, only you can confirm that though. If it did reformat the drive, the error message would make one think there is something missing from the build itself as it relates to the "branch" function for the postgres db.
On Mon, Feb 22, 2010 at 5:01 PM, Pizza Napoletana <[email protected]> wrote: > 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/ > -- ====================== 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/ Why do mathematicians always confuse Halloween and Christmas? Because 31 Oct = 25 Dec.
_______________________________________________ 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/
