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
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
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@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
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 !!
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@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 !!
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@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
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@gmail.comwrote:
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@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@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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 ?
-
Asim Riaz -
muhammad akl -
Nuno Marques