sipXcom 18.04.1

115 views
Skip to first unread message

Michael Picher

unread,
Jul 10, 2018, 8:33:49 AM7/10/18
to sipxcom-users
We've updated sipXcom 18.04 RPM's to 18.04.1. The ISO has not been updated. Users running 18.04 should be able to simply 'yum update' when logged in as root to pickup the following updates:

SIPX-403 P-Asserted-Identity of Proxy - SIP SIde    
    - RequestLinter quth plugin now takes into account presence of SIPX_PASS_P_ASSERTED_IDENTITY config paremter
      when passing PAI header

SIPX-404: P-Preferred-Identity of Proxy - GUI work

SIPX-744 sipxlang-pt.jar schema within spring bean xml uses wrong classpath

SIPX-746: Help text should be added to database page to indicate that voting can be disabled only when priority is 0

SIPX-754: elasticsearch using up too much memory due to number of transactions in audit logging
    - Use cron job to delete from ES instead config loading all docs in memory and remove them

UC-4729: zen 7688: g729 in 'selected' codecs by default
    - Move g729 into available section for all phone plugins

Thanks,
  Mike

duf...@gmail.com

unread,
Jul 17, 2018, 11:03:16 PM7/17/18
to sipxcom-users
I did the yum update today.  Rebooted the sipxcom for good measure after doing that but the 503 still appears unless I restart the sipxconfig service.  I thought SIPX-744 should have resolved this.  Do still need to remove the associated language to have successful reboot without the internet?

Todd Hodgen

unread,
Jul 18, 2018, 3:10:00 AM7/18/18
to sipxcom-users, duf...@gmail.com
You may need to do a send profiles on services/servers

sent by my two left twiddling thumbs...


From: sipxco...@googlegroups.com <sipxco...@googlegroups.com> on behalf of duf...@gmail.com <duf...@gmail.com>
Sent: Tuesday, July 17, 2018 8:03:16 PM
To: sipxcom-users
Subject: [sipxcom-users] Re: sipXcom 18.04.1
 
--
You received this message because you are subscribed to the Google Groups "sipxcom-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sipxcom-user...@googlegroups.com.
To post to this group, send email to sipxco...@googlegroups.com.
Visit this group at https://groups.google.com/group/sipxcom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/sipxcom-users/fee8e871-84cf-4fb9-97a5-ab6bff1ccca5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

George Niculae

unread,
Jul 18, 2018, 4:23:43 AM7/18/18
to Roy Reynolds, sipxcom-users
Not sure I got it right - so it works after you restart sipxconfig? Did it work before upgrade?

--

duf...@gmail.com

unread,
Jul 18, 2018, 2:09:34 PM7/18/18
to sipxcom-users
I had the same issues before doing the yum update on rel 18.x.  In version 16.x and 17.x I didn't experience this issue.  Just be clear,  I can't access the web gui after a reboot unless I restart the sipxconfig service,

Regards,

duf...@gmail.com

unread,
Jul 18, 2018, 2:10:12 PM7/18/18
to sipxcom-users
I will try that today.

Thanks.

tho...@frontier.com

unread,
Dec 20, 2018, 2:28:22 AM12/20/18
to sipxcom-users
Curious if this was resolved and what the solution was to resolve it?

Michael Picher

unread,
Dec 20, 2018, 4:40:41 AM12/20/18
to thodgen, sipxcom-users
Not sure what you are referring to... 

--
You received this message because you are subscribed to the Google Groups "sipxcom-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sipxcom-user...@googlegroups.com.
To post to this group, send email to sipxco...@googlegroups.com.
Visit this group at https://groups.google.com/group/sipxcom-users.

Todd Hodgen

unread,
Dec 20, 2018, 5:30:08 AM12/20/18
to Michael Picher, thodgen, sipxcom-users

DoH!  I posted it to the wrong thread.   My apologies.

Michael Picher

unread,
Dec 20, 2018, 6:56:01 AM12/20/18
to Todd Hodgen, thodgen, sipxcom-users
Lol

pmkr...@gmail.com

unread,
Dec 20, 2018, 10:16:03 AM12/20/18
to sipxcom-users
What I'm observing with all release 18 versions is that the 503 message appears when trying to access the GUI  when a configured server is rebooted and there is no internet connectivity - in the Sipxconfig log file there are Java errors. Once Internet connectivity is re-established and sipxconfig is restarted,  the 503 message no longer appears and the GUI logon menu  appears. Hope this helps. Peter

George Niculae

unread,
Dec 20, 2018, 10:22:18 AM12/20/18
to Peter Krautle, sipxcom-users
What errors do you get in sipxconfig?

George 

Todd Hodgen

unread,
Dec 20, 2018, 11:23:20 AM12/20/18
to George Niculae, Peter Krautle, sipxcom-users

Oh, maybe I didn’t respond to the wrong thread.   I did two updates last night, one is giving me that same 503 message.  It has internet access, as my update was done remote.  I don’t recall if I rebooted the server or not though.   I have bigger issues on the second one, as the primary partition has plenty of disc space, bit it appears to be using a Backup partition that ran out of space.   Status of sipXecs shows some missing packages.  

 

I don’t have remote access to fill in more details – but will shortly.

 

The site with the 503 has a sipxecs status that looks decent.  There are several services that don’t come up, SAA, paging.  Sipxconfig looks good – which is what normally I see not up completely on startup showing the 503.

 

From: sipxco...@googlegroups.com [mailto:sipxco...@googlegroups.com] On Behalf Of George Niculae
Sent: Thursday, December 20, 2018 7:22 AM
To: Peter Krautle <pmkr...@gmail.com>
Cc: sipxcom-users <sipxco...@googlegroups.com>
Subject: Re: [sipxcom-users] Re: sipXcom 18.04.1

 

What errors do you get in sipxconfig?

 

George 

Todd Hodgen

unread,
Dec 20, 2018, 12:50:45 PM12/20/18
to George Niculae, Peter Krautle, sipxcom-users

So updated a system last night.   I made an adjustment to the DNS this morning by adding an external DNS option – not sure it helps but there wasn’t one there beyond the customers domain controllers.   The system now shows a good status on all sipXcom components.   However, the 503 error is still given when trying to open the web gui.

 

Here is what the sipxconfig log contains -    "2018-12-20T17:22:58.157000Z":1:JAVA:INFO:phonesd.domainname.com:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory"

"2018-12-20T17:23:05.481000Z":2:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Starting parallel regeneration of mongo group of 56 entities on 2 threads using chunks of 1000 users"

"2018-12-20T17:23:06.126000Z":3:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 415"

"2018-12-20T17:23:06.443000Z":4:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 413"

"2018-12-20T17:23:06.708000Z":5:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 428"

"2018-12-20T17:23:06.902000Z":6:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 440"

"2018-12-20T17:23:06.910000Z":7:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 441"

"2018-12-20T17:23:07.402000Z":8:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed james"

"2018-12-20T17:23:07.413000Z":9:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 435"

"2018-12-20T17:23:07.619000Z":10:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 446"

"2018-12-20T17:23:07.735000Z":11:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 449"

"2018-12-20T17:23:07.743000Z":12:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 450"

"2018-12-20T17:23:07.804000Z":13:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 451"

"2018-12-20T17:23:07.900000Z":14:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 454"

"2018-12-20T17:23:08.051000Z":15:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 457"

"2018-12-20T17:23:08.195000Z":16:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Regeneration of entities finished in 2s | 0m."

"2018-12-20T17:23:08.197000Z":17:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Starting parallel regeneration of mongo group of 38 entities on 2 threads using chunks of 1000 users"

"2018-12-20T17:23:08.679000Z":18:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Regeneration of entities finished in 0s | 0m."

"2018-12-20T17:23:08.819000Z":19:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Replication: removed Voip.ms.test"

"2018-12-20T17:23:09.634000Z":21:JAVA:INFO:phonesd.domainname.com:main:00000000:auditlog:"Replicated in Mongo DBDatabase regeneration to phonesd.domainname.com"

"2018-12-20T17:23:09.898000Z":22:JAVA:INFO:phonesd.domainname.com:main:00000000:SetupManagerImpl:"2 setup listeners will be called again"

"2018-12-20T17:23:09.898000Z":23:JAVA:INFO:phonesd.domainname.com:main:00000000:SetupManagerImpl:"0 setup listeners will be called again"

"2018-12-20T17:23:09.898000Z":24:JAVA:INFO:phonesd.domainname.com:main:00000000:ConfigManagerImpl:"Configuration work to do. Notifying providers."

"2018-12-20T17:23:09.915000Z":25:JAVA:INFO:phonesd.domainname.com:Thread-21:00000000:SimpleCommandRunner:"/usr/bin/mongodb-status --full"

"2018-12-20T17:23:09.916000Z":26:JAVA:INFO:phonesd.domainname.com:main:00000000:ResLimitsConfiguration:"Write FEATURED resource limits"

"2018-12-20T17:23:10.122000Z":27:JAVA:INFO:phonesd.domainname.com:Thread-21:00000000:SimpleCommandRunner:"/usr/bin/mongodb-analyzer"

"2018-12-20T17:23:13.703000Z":29:JAVA:INFO:phonesd.domainname.com:pool-1-thread-1:00000000:auditlog:"Replicated: 1 - Publish finished replication event ..."

"2018-12-20T17:23:14.927000Z":30:JAVA:INFO:phonesd.domainname.com:pool-7-thread-1:00000000:CheckDST:"Checking DST..."

"2018-12-20T17:23:19.472000Z":31:JAVA:WARNING:phonesd.domainname.com:main:00000000:AbstractSetting:"Cannot find setting: im-portal in user-portal"

"2018-12-20T17:23:19.997000Z":32:JAVA:WARNING:phonesd.domainname.com:main:00000000:RulesXmlFile:"Cannot read from external mapping rules file: "

"2018-12-20T17:23:20.001000Z":33:JAVA:WARNING:phonesd.domainname.com:main:00000000:RulesXmlFile:"Cannot read from external mapping rules file: "

"2018-12-20T17:23:20.657000Z":34:JAVA:INFO:phonesd.domainname.com:main:00000000:ConfigManagerImpl:"Running Signal XMPP configuration change"

"2018-12-20T17:23:40.894000Z":1:JAVA:INFO:phonesd.domainname.com:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory"

"2018-12-20T17:23:50.855000Z":2:JAVA:WARNING:phonesd.domainname.com:main:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 42703"

"2018-12-20T17:23:50.855000Z":3:JAVA:ERR:phonesd.domainname.com:main:00000000:JDBCExceptionReporter:"ERROR: column this_.value_storage_id does not exist"

"2018-12-20T17:23:50.857000Z":4:JAVA:WARNING:phonesd.domainname.com:main:00000000:WebAppContext:"Failed startup of context o.e.j.w.WebAppContext@9c241d7{/sipxconfig,file:/var/sipxdata/tmp/sipxconfig/webapp/,STARTING}{/usr/share/java/sipXecs/sipXconfig/sipxconfig.war}"

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.ldap_connection_id as ldap1_50_5_, this_.host as host50_5_, this_.port as port50_5_, this_.principal as principal50_5_, this_.timeout as timeout50_5_, this_.secret as secret50_5_, this_.use_tls as use7_50_5_, this_.cron_schedule_id as cron8_50_5_, this_.value_storage_id as value9_50_5_, cronschedu2_.cron_schedule_id as cron1_59_0_, cronschedu2_.cron_string as cron2_59_0_, cronschedu2_.enabled as enabled59_0_, valuestora3_.value_storage_id as value1_70_1_, valuestora3_1_.name as name72_1_, valuestora3_1_.description as descript3_72_1_, valuestora3_1_.resource as resource72_1_, valuestora3_1_.weight as weight72_1_, valuestora3_1_.branch_id as branch6_72_1_, case when valuestora3_1_.group_id is not null then 1 when valuestora3_.value_storage_id is not null then 0 end as clazz_1_, branch4_.branch_id as branch1_101_2_, branch4_.name as name101_2_, branch4_.description as descript3_101_2_, branch4_.phone_number as phone4_101_2_, branch4_.fax_number as fax5_101_2_, branch4_.time_zone as time6_101_2_, branch4_.address_id as address7_101_2_, branch4_.fallback_branch_id as fallback8_101_2_, address5_.address_id as address1_86_3_, address5_.street as street86_3_, address5_.zip as zip86_3_, address5_.city as city86_3_, address5_.country as country86_3_, address5_.state as state86_3_, address5_.office_designation as office7_86_3_, branch6_.branch_id as branch1_101_4_, branch6_.name as name101_4_, branch6_.description as descript3_101_4_, branch6_.phone_number as phone4_101_4_, branch6_.fax_number as fax5_101_4_, branch6_.time_zone as time6_101_4_, branch6_.address_id as address7_101_4_, branch6_.fallback_branch_id as fallback8_101_4_ from ldap_connection this_ left outer join cron_schedule cronschedu2_ on this_.cron_schedule_id=cronschedu2_.cron_schedule_id left outer join value_storage valuestora3_ on this_.value_storage_id=valuestora3_.value_storage_id left outer join group_storage valuestora3_1_ on valuestora3_.value_storage_id=valuestora3_1_.group_id left outer join branch branch4_ on valuestora3_1_.branch_id=branch4_.branch_id left outer join address address5_ on branch4_.address_id=address5_.address_id left outer join branch branch6_ on branch4_.fallback_branch_id=branch6_.branch_id]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

                at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635)

                at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

                at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)

                at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)

                at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584)

                at org.sipfoundry.sipxconfig.bulk.ldap.LdapManagerImpl.getAllConnectionParams(LdapManagerImpl.java:326)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:606)

                at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

                at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

                at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

                at com.sun.proxy.$Proxy38.getAllConnectionParams(Unknown Source)

                at org.sipfoundry.sipxconfig.bulk.ldap.LdapImportTrigger.onApplicationEvent(LdapImportTrigger.java:53)

                at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:98)

                at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:333)

                at org.sipfoundry.sipxconfig.site.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:35)

                at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)

                at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:446)

                at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:792)

                at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:296)

                at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1359)

                at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1352)

                at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:744)

                at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:497)

                at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)

                at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)

                at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:154)

                at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)

                at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)

                at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)

                at org.eclipse.jetty.server.Server.start(Server.java:358)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)

                at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)

                at org.eclipse.jetty.server.Server.doStart(Server.java:325)

                at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)

                at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1250)

                at java.security.AccessController.doPrivileged(Native Method)

                at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1174)

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)

                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

                at org.hibernate.loader.Loader.doList(Loader.java:2545)

                at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

                at org.hibernate.loader.Loader.list(Loader.java:2271)

                at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)

                at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)

                at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)

                at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590)

                at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1)

                at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)

                ... 45 more

Caused by: org.postgresql.util.PSQLException: ERROR: column this_.value_storage_id 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:208)

                at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)

                at org.hibernate.loader.Loader.doQuery(Loader.java:802)

                at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

                at org.hibernate.loader.Loader.doList(Loader.java:2542)

                ... 53 more

"2018-12-20T17:24:00.796000Z":5:JAVA:INFO:phonesd.domainname.com:pool-7-thread-1:00000000:CheckDST:"Checking DST..."

"2018-12-20T17:24:45.983000Z":1:JAVA:INFO:phonesd.domainname.com:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory"

"2018-12-20T17:24:56.043000Z":2:JAVA:WARNING:phonesd.domainname.com:main:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 42703"

"2018-12-20T17:24:56.043000Z":3:JAVA:ERR:phonesd.domainname.com:main:00000000:JDBCExceptionReporter:"ERROR: column this_.value_storage_id does not exist"

"2018-12-20T17:24:56.051000Z":4:JAVA:WARNING:phonesd.domainname.com:main:00000000:WebAppContext:"Failed startup of context o.e.j.w.WebAppContext@256c128d{/sipxconfig,file:/var/sipxdata/tmp/sipxconfig/webapp/,STARTING}{/usr/share/java/sipXecs/sipXconfig/sipxconfig.war}"

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.ldap_connection_id as ldap1_50_5_, this_.host as host50_5_, this_.port as port50_5_, this_.principal as principal50_5_, this_.timeout as timeout50_5_, this_.secret as secret50_5_, this_.use_tls as use7_50_5_, this_.cron_schedule_id as cron8_50_5_, this_.value_storage_id as value9_50_5_, cronschedu2_.cron_schedule_id as cron1_59_0_, cronschedu2_.cron_string as cron2_59_0_, cronschedu2_.enabled as enabled59_0_, valuestora3_.value_storage_id as value1_70_1_, valuestora3_1_.name as name72_1_, valuestora3_1_.description as descript3_72_1_, valuestora3_1_.resource as resource72_1_, valuestora3_1_.weight as weight72_1_, valuestora3_1_.branch_id as branch6_72_1_, case when valuestora3_1_.group_id is not null then 1 when valuestora3_.value_storage_id is not null then 0 end as clazz_1_, branch4_.branch_id as branch1_101_2_, branch4_.name as name101_2_, branch4_.description as descript3_101_2_, branch4_.phone_number as phone4_101_2_, branch4_.fax_number as fax5_101_2_, branch4_.time_zone as time6_101_2_, branch4_.address_id as address7_101_2_, branch4_.fallback_branch_id as fallback8_101_2_, address5_.address_id as address1_86_3_, address5_.street as street86_3_, address5_.zip as zip86_3_, address5_.city as city86_3_, address5_.country as country86_3_, address5_.state as state86_3_, address5_.office_designation as office7_86_3_, branch6_.branch_id as branch1_101_4_, branch6_.name as name101_4_, branch6_.description as descript3_101_4_, branch6_.phone_number as phone4_101_4_, branch6_.fax_number as fax5_101_4_, branch6_.time_zone as time6_101_4_, branch6_.address_id as address7_101_4_, branch6_.fallback_branch_id as fallback8_101_4_ from ldap_connection this_ left outer join cron_schedule cronschedu2_ on this_.cron_schedule_id=cronschedu2_.cron_schedule_id left outer join value_storage valuestora3_ on this_.value_storage_id=valuestora3_.value_storage_id left outer join group_storage valuestora3_1_ on valuestora3_.value_storage_id=valuestora3_1_.group_id left outer join branch branch4_ on valuestora3_1_.branch_id=branch4_.branch_id left outer join address address5_ on branch4_.address_id=address5_.address_id left outer join branch branch6_ on branch4_.fallback_branch_id=branch6_.branch_id]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

                at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635)

                at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

                at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)

                at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)

                at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584)

                at org.sipfoundry.sipxconfig.bulk.ldap.LdapManagerImpl.getAllConnectionParams(LdapManagerImpl.java:326)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:606)

                at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

                at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

                at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

                at com.sun.proxy.$Proxy38.getAllConnectionParams(Unknown Source)

                at org.sipfoundry.sipxconfig.bulk.ldap.LdapImportTrigger.onApplicationEvent(LdapImportTrigger.java:53)

                at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:98)

                at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:333)

                at org.sipfoundry.sipxconfig.site.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:35)

                at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)

                at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:446)

                at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:792)

                at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:296)

                at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1359)

                at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1352)

                at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:744)

                at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:497)

                at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)

                at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)

                at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:154)

                at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)

                at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)

                at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)

                at org.eclipse.jetty.server.Server.start(Server.java:358)

                at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)

                at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)

                at org.eclipse.jetty.server.Server.doStart(Server.java:325)

                at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)

                at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1250)

                at java.security.AccessController.doPrivileged(Native Method)

                at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1174)

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)

                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

                at org.hibernate.loader.Loader.doList(Loader.java:2545)

                at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

                at org.hibernate.loader.Loader.list(Loader.java:2271)

                at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)

                at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)

                at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)

                at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590)

                at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1)

                at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)

                ... 45 more

Caused by: org.postgresql.util.PSQLException: ERROR: column this_.value_storage_id 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:208)

                at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)

                at org.hibernate.loader.Loader.doQuery(Loader.java:802)

                at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

                at org.hibernate.loader.Loader.doList(Loader.java:2542)

                ... 53 more

"2018-12-20T17:25:06.015000Z":5:JAVA:INFO:phonesd.domainname.com:pool-7-thread-1:00000000:CheckDST:"Checking DST..."

 

From: sipxco...@googlegroups.com [mailto:sipxco...@googlegroups.com] On Behalf Of George Niculae
Sent: Thursday, December 20, 2018 7:22 AM
To: Peter Krautle <pmkr...@gmail.com>
Cc: sipxcom-users <sipxco...@googlegroups.com>
Subject: Re: [sipxcom-users] Re: sipXcom 18.04.1

 

What errors do you get in sipxconfig?

 

George 

 

To post to this group, send email to sipxco..@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "sipxcom-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sipxcom-user...@googlegroups.com.

To post to this group, send email to sipxcom-users@googlegroupscom.

--
You received this message because you are subscribed to a topic in the Google Groups "sipxcom-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sipxcom-users/mnP-NxjM2-Q/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sipxcom-user...@googlegroups.com.


To post to this group, send email to sipxco...@googlegroups.com.
Visit this group at https://groups.google.com/group/sipxcom-users.

Charles Chalekson

unread,
Sep 1, 2019, 12:00:55 AM9/1/19
to sipxcom-users
Todd,

How did you resolve the 503 errors?  I am doing a new install with CentOS 7 and am unable to bring up the GUI with 503 errors.

Todd Hodgen

unread,
Sep 1, 2019, 9:18:17 AM9/1/19
to Charles Chalekson, sipxcom-users
Sorry, I'm traveling on vacation with limited access.  I find sometimes if the system has had a disorderly shutdown that I see this issue.  From command line tell it reboot now, let it reboot and give it time to restart services.  This may not be your issue, but it's my first step.

sent by my two left twiddling thumbs...


From: sipxco...@googlegroups.com <sipxco...@googlegroups.com> on behalf of Charles Chalekson <chal...@gmail.com>
Sent: Saturday, August 31, 2019 11:00:55 PM
To: sipxcom-users <sipxco...@googlegroups.com>

Subject: Re: [sipxcom-users] Re: sipXcom 18.04.1
Todd,

How did you resolve the 503 errors?  I am doing a new install with CentOS 7 and am unable to bring up the GUI with 503 errors.

--
You received this message because you are subscribed to the Google Groups "sipxcom-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sipxcom-user...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages