Yes, saw that too. I saw "both' were installed (the prior one). I didn't
raise an issue because this build is probably outdated. I deleted the old
version manually. Will keep an eye on it as new builds come out though.

On Mon, Feb 22, 2010 at 4:52 PM, Pizza Napoletana <[email protected]> wrote:

> 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.
>
>


-- 
======================
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/

Reply via email to