I found it . Thanks Tony! I think this is what you need. If you need more of the log I will send.
On Fri, Oct 8, 2010 at 8:46 PM, Tony Graziano <[email protected]>wrote: > I mand > > /var/log/sipxpbx/sipxconfig.log > > > On Fri, Oct 8, 2010 at 8:33 PM, Tony Graziano < > [email protected]> wrote: > >> it will cut a log entry to: >> >> /var/log/sipxconfig.log >> >> grab the offending entry and post it here. >> >> >> On Fri, Oct 8, 2010 at 8:21 PM, Rolland Hart <[email protected]>wrote: >> >>> Hey Tony, >>> Rebooted 3 times and tried three different browsers withe the same >>> result. Anything else I can try? >>> >>> On Fri, Oct 8, 2010 at 8:04 PM, Tony Graziano < >>> [email protected]> wrote: >>> >>>> Reboot >>>> >>>> On 10/8/10, Rolland Hart <[email protected]> wrote: >>>> > Hi all, >>>> > >>>> > I was wondering if any one else got this error message after updating >>>> to >>>> > 4.3.2 from 4.3.0? Was also wondering if there is a fix? This is the >>>> error >>>> > message: >>>> > >>>> > HTTP ERROR: 500 >>>> > >>>> > could not execute query; nested exception is >>>> > org.hibernate.exception.SQLGrammarException: could not execute query >>>> > >>>> > RequestURI=/sipxconfig/j_acegi_security_check >>>> > >>>> >>>> -- >>>> Sent from my mobile device >>>> >>>> ====================== >>>> Tony Graziano, Manager >>>> Telephone: 434.984.8430 >>>> sip: [email protected] >>>> Fax: 434.984.8431 >>>> >>>> Email: [email protected] >>>> >>>> LAN/Telephony/Security and Control Systems Helpdesk: >>>> Telephone: 434.984.8426 >>>> sip: [email protected] >>>> 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/ >>>> >>> >>> >>> _______________________________________________ >>> sipx-users mailing list >>> [email protected] >>> List Archive: http://list.sipfoundry.org/archive/sipx-users/ >>> >> >> >> >> -- >> ====================== >> Tony Graziano, Manager >> Telephone: 434.984.8430 >> sip: [email protected] >> Fax: 434.984.8431 >> >> Email: [email protected] >> >> LAN/Telephony/Security and Control Systems Helpdesk: >> Telephone: 434.984.8426 >> sip: [email protected] >> 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. >> >> > > > -- > ====================== > Tony Graziano, Manager > Telephone: 434.984.8430 > sip: [email protected] > Fax: 434.984.8431 > > Email: [email protected] > > LAN/Telephony/Security and Control Systems Helpdesk: > Telephone: 434.984.8426 > sip: [email protected] > 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/ >
"2010-10-09T00:42:59.054000Z":7:JAVA:INFO:hserver1.ostbnet.net:pool-2-thread-1:00000000:XmlRpcClientInterceptor:"XML/RPC SwAdminRpc.exec with [hserver1.ostbnet.net, check-update] on https://hserver1.ostbnet.net:8092/RPC2"; "2010-10-09T00:42:59.335000Z":8:JAVA:INFO:hserver1.ostbnet.net:pool-2-thread-1:00000000:XmlRpcClientInterceptor:"XML/RPC SwAdminRpc.execStatus with [hserver1.ostbnet.net, check-update] on https://hserver1.ostbnet.net:8092/RPC2"; "2010-10-09T00:43:04.460000Z":9:JAVA:INFO:hserver1.ostbnet.net:pool-2-thread-1:00000000:XmlRpcClientInterceptor:"XML/RPC SwAdminRpc.execStatus with [hserver1.ostbnet.net, check-update] on https://hserver1.ostbnet.net:8092/RPC2"; "2010-10-09T00:46:15.312000Z":10:JAVA:WARNING:hserver1.ostbnet.net:P1-18:00000000:LdapContextSource:"Property 'userName' not set - anonymous context will be used for read-write operations" "2010-10-09T00:46:15.315000Z":11:JAVA:WARNING:hserver1.ostbnet.net:P1-18:00000000:LdapContextSource:"Property 'userName' not set - anonymous context will be used for read-write operations" "2010-10-09T00:46:15.323000Z":12:JAVA:WARNING:hserver1.ostbnet.net:P1-18:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 42703" "2010-10-09T00:46:15.324000Z":13:JAVA:ERR:hserver1.ostbnet.net:P1-18:00000000:JDBCExceptionReporter:"ERROR: column this_.configured does not exist" "2010-10-09T00:46:15.324000Z":14:JAVA:WARNING:hserver1.ostbnet.net:P1-18:00000000:sipXconfig-web:"/sipxconfig/j_acegi_security_check: " org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception 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.java: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.bulk.ldap.LdapManagerImpl.getSystemSettings(LdapManagerImpl.java:252) 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(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:104) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) at $Proxy28.getSystemSettings(Unknown Source) at org.sipfoundry.sipxconfig.security.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:122) at org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:122) at org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:200) at org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:47) at org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:74) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:252) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:814) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Caused by: org.postgresql.util.PSQLException: ERROR: column this_.configured 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) ... 44 more
_______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/
