20 Aug
2008
20 Aug
'08
6:11 a.m.
Hi,
I´m trying to install SerMyAdmin in my Openser 1.2.2 machine. I follow the
steps that were on www.sermyadmin.org.
I accomplished the installation task, but now when i try to do something
on the DB (for example: create a new user) it gives me a lot of errors.
My experience with Grails is null so i don't know were to start.
Below i'll show the error messages.
If anyone could give me an hand i'll appreciate.
Thanks in advance,
Nuno
*Message:* could not insert: [User]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not insert:
[User]
*Caused by:* org.springframework.dao.DataIntegrityViolationException: could
not insert: [User]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not insert:
[User]
*Class:* UserController
*At Line:* [147]
*Code Snippet:*
Stack
org.codehaus.groovy.runtime.InvokerInvocationException:
org.springframework.dao.DataIntegrityViolationException: could not
insert: [User]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not
insert: [User]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.jsecurity.web.servlet.WebInterceptorFilter.doFilterInternal(WebInterceptorFilter.java:106)
at
org.jsecurity.web.servlet.SecurityContextFilter.doFilterInternal(SecurityContextFilter.java:93)
at
org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.springframework.dao.DataIntegrityViolationException:
could not insert: [User]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not
insert: [User]
at UserController$_closure8.doCall(UserController.groovy:147)
at UserController$_closure8.doCall(UserController.groovy)
... 29 more
Caused by: org.hibernate.exception.ConstraintViolationException: could
not insert: [User]
at $Proxy3.saveOrUpdate(Unknown Source)
... 31 more
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Duplicate entry '4000-192.168.137.1' for key 2
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1011)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
... 32 more
20 Aug
20 Aug
1:22 p.m.
Hi Nuno
i faced some problems your already facing and succeeded to solve them so i'd
like to as you
did you install SERweb tables ?
if though the problems come from there especially the phplib_id field a
duplication happened between it and the "id" filed so you have to remove
SERweb tables and all thing will go smoothly without any errors
p.s i recommend you to remove the whole database e.g openser and install it
again using openser_mysql.sh script
e.g /path/to/openser_mysql.sh create
press yes for presence and that stuff but for SERweb no
try and tell me what you get
BR
Muhammad
21 Aug
21 Aug
7:26 a.m.
Hi Muhammad,
I droped the database and then created a new database as you told me...
Now i have to create all users again and an admin for sermyadmin...
But when i tried to run the mysql commands that are on
www.sermyadmin.org/openser/openser.sql they gave me an error: unknown column
'version' in 'field list'.
Have any idea of what is going on?
By the way... do you know what happened to www.sermyadmin.org - it's seem
like it has been hacked or something...
Many tahnks,
Nuno
2008/8/20 muhammad akl <muhammad.akl(a)gmail.com>
Hi Nuno
i faced some problems your already facing and succeeded to solve them so
i'd like to as you
did you install SERweb tables ?
if though the problems come from there especially the phplib_id field a
duplication happened between it and the "id" filed so you have to remove
SERweb tables and all thing will go smoothly without any errors
p.s i recommend you to remove the whole database e.g openser and install it
again using openser_mysql.sh script
e.g /path/to/openser_mysql.sh create
press yes for presence and that stuff but for SERweb no
try and tell me what you get
BR
Muhammad
8:51 a.m.
yea it hacked at the moment hope it will back gain
to solve the error just firstly open the http://ip-address/serMyAdmin
after that you should see the login page , don't login or make anything
now open ur terminal and apply the query
mysql -u root -p openser <openser.sql
that's the trick !!
9:56 a.m.
Hi again,
Still having the same problem... he doesn't recognize the column 'version'
in the 'field list'.
I'm using openser 1.2.2. Could it be the problem?
BR
Nuno
2008/8/21 muhammad akl <muhammad.akl(a)gmail.com>
yea it hacked at the moment hope it will back gain
to solve the error just firstly open the http://ip-address/serMyAdmin
after that you should see the login page , don't login or make anything
now open ur terminal and apply the query
mysql -u root -p openser <openser.sql
that's the trick !!
10:06 a.m.
Hi again,
I was looking at the database schema of openser and i noticed that the
subscriber table only has 12 columns till rpid.
Looking at the openser.sql script, it has more than 12 columns (including
the 'version' column...).
What is wrong? Should SerMyAdmin add this columns to the subscriber
table?
Is it lacking me something in the database subscribet table?
Any help with this?
Thanks in advance,
Nuno
2008/8/20 muhammad akl <muhammad.akl(a)gmail.com>
Hi Nuno
i faced some problems your already facing and succeeded to solve them so
i'd like to as you
did you install SERweb tables ?
if though the problems come from there especially the phplib_id field a
duplication happened between it and the "id" filed so you have to remove
SERweb tables and all thing will go smoothly without any errors
p.s i recommend you to remove the whole database e.g openser and install it
again using openser_mysql.sh script
e.g /path/to/openser_mysql.sh create
press yes for presence and that stuff but for SERweb no
try and tell me what you get
BR
Muhammad
10:41 a.m.
When I am adding a user i am getting java.lang.NullPointerException;
also I cant login using admin username.
On Thu, Aug 21, 2008 at 3:06 PM, Nuno Marques <yangsengopenser(a)gmail.com>wrote;wrote:
Hi again,
I was looking at the database schema of openser and i noticed that the
subscriber table only has 12 columns till rpid.
Looking at the openser.sql script, it has more than 12 columns
(including the 'version' column...).
What is wrong? Should SerMyAdmin add this columns to the subscriber
table?
Is it lacking me something in the database subscribet table?
Any help with this?
Thanks in advance,
Nuno
2008/8/20 muhammad akl <muhammad.akl(a)gmail.com>
Hi Nuno
i faced some problems your already facing and succeeded to solve them so
i'd like to as you
did you install SERweb tables ?
if though the problems come from there especially the phplib_id field a
duplication happened between it and the "id" filed so you have to remove
SERweb tables and all thing will go smoothly without any errors
p.s i recommend you to remove the whole database e.g openser and install
it again using openser_mysql.sh script
e.g /path/to/openser_mysql.sh create
press yes for presence and that stuff but for SERweb no
try and tell me what you get
BR
Muhammad
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
10:49 a.m.
that's what i was talking about Nuno you have to run serMyAdmin firstly then
it will create the necessary fileds
well asim did you downloaded the new openser.sql from sermyadmin ?
5971
days inactive
5972
days old
7 comments
3 participants
participants (3)
-
Asim Riaz -
muhammad akl -
Nuno Marques