<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV>Hi Assim, </DIV>
<DIV> </DIV>
<DIV>I'm glad it is working. SerMyAdmin creates the database fields during the first run, that's why it worked after restarting the tomcat. The sql file creates the required users. I'm working to have a debian package for SerMyAdmin soon. </DIV>
<DIV> </DIV>
<DIV>Regards, </DIV>
<DIV> </DIV>
<DIV>Flavio E. Goncalves<BR></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Mensagem original ----<BR>De: Asim Riaz <ariaz78@gmail.com><BR>Para: users <users@lists.kamailio.org><BR>Enviadas: Quinta-feira, 21 de Agosto de 2008 12:02:50<BR>Assunto: Re: [Kamailio-Users] Help with SerMyAdmin<BR><BR>
<DIV dir=ltr>Its working thanks for the help.<BR>I removed my existing serMyAdmin directory from tomcat, restarted the tomcat and run the script mysql -u root -p openser <openser.sql<BR><BR>regards<BR>Asim Riaz<BR><BR>
<DIV class=gmail_quote>On Thu, Aug 21, 2008 at 3:46 PM, Nuno Marques <SPAN dir=ltr><<A href="mailto:yangsengopenser@gmail.com" target=_blank rel=nofollow ymailto="mailto:yangsengopenser@gmail.com">yangsengopenser@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV dir=ltr>How did you add the user? With openserctl or with sermyadmin?<BR>Note that you have to use the same login/pass that are on the sql script - admin@setup for login and secret for pass.<BR><BR><BR>
<DIV class=gmail_quote>
<DIV class=Ih2E3d>2008/8/21 Asim Riaz <SPAN dir=ltr><<A href="mailto:ariaz78@gmail.com" target=_blank rel=nofollow ymailto="mailto:ariaz78@gmail.com">ariaz78@gmail.com</A>></SPAN><BR></DIV>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV dir=ltr>When I am adding a user i am getting java.lang.NullPointerException;
<DIV>
<DIV></DIV>
<DIV class=Wj3C7c><BR>also I cant login using admin username.<BR><BR>
<DIV class=gmail_quote>
<DIV>
<DIV></DIV>
<DIV>On Thu, Aug 21, 2008 at 3:06 PM, Nuno Marques <SPAN dir=ltr><<A href="mailto:yangsengopenser@gmail.com" target=_blank rel=nofollow ymailto="mailto:yangsengopenser@gmail.com">yangsengopenser@gmail.com</A>></SPAN> wrote:<BR></DIV></DIV>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>
<DIV></DIV>
<DIV>
<DIV dir=ltr>Hi again,<BR><BR> I was looking at the database schema of openser and i noticed that the subscriber table only has 12 columns till rpid.<BR> Looking at the openser.sql script, it has more than 12 columns (including the 'version' column...).<BR> What is wrong? Should SerMyAdmin add this columns to the subscriber table?<BR> Is it lacking me something in the database subscribet table?<BR> Any help with this?<BR><BR> Thanks in advance,<BR><BR> Nuno<BR><BR>
<DIV class=gmail_quote>2008/8/20 muhammad akl <SPAN dir=ltr><<A href="mailto:muhammad.akl@gmail.com" target=_blank rel=nofollow ymailto="mailto:muhammad.akl@gmail.com">muhammad.akl@gmail.com</A>></SPAN>
<DIV>
<DIV></DIV>
<DIV><BR>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV dir=ltr><BR><BR>Hi Nuno <BR><BR>i faced some problems your already facing and succeeded to solve them so i'd like to as you <BR><BR>did you install SERweb tables ? <BR><BR>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 <BR><BR>p.s i recommend you to remove the whole database e.g openser and install it again using openser_mysql.sh script <BR><BR>e.g /path/to/openser_mysql.sh create <BR><BR>press yes for presence and that stuff but for SERweb no <BR><BR>try and tell me what you get <BR><BR>BR <BR><BR>Muhammad<BR></DIV></BLOCKQUOTE></DIV></DIV></DIV><BR></DIV><BR></DIV></DIV>
<DIV>_______________________________________________<BR>Users mailing list<BR><A href="mailto:Users@lists.kamailio.org" target=_blank rel=nofollow ymailto="mailto:Users@lists.kamailio.org">Users@lists.kamailio.org</A><BR><A href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target=_blank rel=nofollow>http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</A><BR><BR></DIV></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV>
<DIV>
<DIV></DIV>
<DIV class=Wj3C7c><BR>_______________________________________________<BR>Users mailing list<BR><A href="mailto:Users@lists.kamailio.org" target=_blank rel=nofollow ymailto="mailto:Users@lists.kamailio.org">Users@lists.kamailio.org</A><BR><A href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target=_blank rel=nofollow>http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</A><BR><BR></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></div></body></html>