Its working thanks for the help.
I removed my existing serMyAdmin directory from tomcat, restarted the tomcat
and run the script mysql -u root -p openser <openser.sql
regards
Asim Riaz
On Thu, Aug 21, 2008 at 3:46 PM, Nuno Marques <yangsengopenser(a)gmail.com>wrote:
> How did you add the user? With openserctl or with sermyadmin?
> Note that you have to use the same login/pass that are on the sql script -
> admin@setup for login and secret for pass.
>
>
> 2008/8/21 Asim Riaz <ariaz78(a)gmail.com>
>
>> 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:
>>
>>> 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
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users(a)lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>
>>
>
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
---------- Forwarded message ----------
From: Asim Riaz <ariaz78(a)gmail.com>
Date: Thu, Aug 21, 2008 at 2:49 PM
Subject: Re: [Kamailio-Users] Help with SerMyAdmin
To: Nuno Marques <yangsengopenser(a)gmail.com>
my issue is same as Nano
tried this command mysql -u root -p openser <openser.sql but still
got ERROR 1054 (42S22) at line 1: Unknown column 'version' in 'field list'
Regards
Asim
On Thu, Aug 21, 2008 at 12:26 PM, Nuno Marques <yangsengopenser(a)gmail.com>wrote:
> 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
>>
>
>
> _______________________________________________
> Users mailing list
> Users(a)lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>
>
Hi All,
I have a question about the best solution to ensure that SIP calls are
terminated when the 2 parties drop off the network (wireless).
Is there a std way of doing this (maybe using sst module) or should this be
implemented using some specialised code?
If not supported in a std manner in Kamailio, i thought about creating a
child process within the DLG module that continuously checks all dialogs and
the connected parties and pings them for connectivity. Should connectivity
of any participant drop for more than a specific unit of time then the call
is focefully torn down by openser.
Any ideas?
Cheers
Jason
Hi,
I tried to install on my Openser 1.2.2 the permissions module so i can use
an asterisk gateway. I populated the trusted table with information about
the gateway.
When i tried to run OpenSer it gave me some errors.
Can anyone tell me what could be the problem? Below are the erros and the
data on trusted table.
Thanks in advance,
Nuno
0(3824) init_tcp: using epoll_lt as the io watch method (auto detected)
0(0) INFO: statistics manager successfully initialized
0(0) StateLess module - initializing
0(0) TM - initializing...
0(0) Maxfwd module- initializing
0(0) INFO:ul_init_locks: locks array size 512
0(0) TextOPS - initializing
labvoipua:/etc/openser# 0(0) permissions - initializing
0(0) Default allow file (//etc/openser/permissions.allow) not found
=> empty rule set
0(0) Default deny file (//etc/openser/permissions.deny) not found =>
empty rule set
0(0) hash_table_insert(): Unknown protocol
0(0) ERROR: permissions: trusted_reload(): Hash table problem
0(0) init_trusted(): Reload of trusted table failed
0(0) Error while initializing allow_trusted function
0(0) init_mod(): Error while initializing module permissions
ERROR: error while initializing modules
0(0) INFO:mi_fifo:mi_destroy:memory for the child's mi_fifo_pid was
not allocated -> nothing to destroy
TRUSTED TABLE
+----+----------------+-------+--------------+------+---------+
| id | src_ip | proto | from_pattern | tag | version |
+----+----------------+-------+--------------+------+---------+
| 1 | 192.168.137.20 | Any | ^sip:.*$ | NULL | 3 |
+----+----------------+-------+--------------+------+---------+
Hi,
I have openser 1.2.2 installed with mysql as backend. I was able to
run a simple call service after registering users in location table.
Now that I'm trying implement a speed_dial, it returns "404 call not
found" error at the Xlite panel after dialing a short dial number as
per speed_dial table entry. But if I short dial my own short dial
number it dials back to me(working) ! What might b the problem ?
script file :
...........
if (uri=~"sip:[0-9]{2}@.*")
sd_lookup("speed_dial");
............
speed_dial table entry :
+----+------------+----------+----------------+--------------+----------------+-----------+----------+-----------------+
| id | username | domain | sd_username | sd_domain | new_uri
| fname | lname | description |
+----+------------+----------+----------------+--------------+----------------+-----------+----------+-----------------+
| 5 | 103 | | 33 |
10.1.2.214 | 103(a)10.1.2.214 | |
| 4 | 102 | | 22 |
10.1.2.214 | 102(a)10.1.2.214 | |
| 6 | 101 | | 11 |
10.1.2.214 | 101(a)10.1.2.214 | |
| 9 | 105 | | 55 |
10.1.2.214 | 105(a)10.1.2.214 | |
+----+------------+----------+----------------+--------------+----------------+----------+----------+-----------------+
can anyone clarify ? Thanx
regards
Farci
Good work. I tinkered a bit and came up with something very similar.
- Darren
_____________________________
dmsessions(a)gmail.com
http://www.darrensessions.com
_____________________________
On Aug 20, 2008, at 4:52 PM, Ricky Gutierrez wrote:
> logo with basic colors
>
> Regards
>
> rickygm
>
> ----- Original Message ----
> From: Johansson Olle E <oej(a)edvina.net>
> To: Ricky Gutierrez <xserverlinux(a)yahoo.com>
> Cc: devel(a)lists.kamailio.org
> Sent: Wednesday, August 20, 2008 4:55:21 AM
> Subject: Re: [Kamailio-Devel] logo
>
> Ricky,
> I really like your logo. But I also see issue with using it in pure
> black/white situations - no greyshades.
>
> Can you try to create such a version of it as well?
>
> This is often needed when producing t-shirts and other stuff, where an
> outline is used.
>
> Thanks.
> /O
>
> <kamailio-new.png>_______________________________________________
> Devel mailing list
> Devel(a)lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/devel
With the departure of voice system from the project are there any
commercial entities associated with the development team that offer
support for Kamailio?
Regards,
Bob
--------------------------------------------------------------------------
This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
(W1)
