---------- Forwarded message ---------- From: Asim Riaz ariaz78@gmail.com Date: Thu, Aug 21, 2008 at 2:49 PM Subject: Re: [Kamailio-Users] Help with SerMyAdmin To: Nuno Marques yangsengopenser@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@gmail.comwrote:
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,
Nuno2008/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
Hi Asim,
Discovered the solution for our problem ! Just delete the folder serMyAdmin that you have on tomcat6 folder (or other webserver). Then restart tomcat (or other webserver). Open the web page http://<server address>:8080/serMyAdmin and it will add the necessary columns to the subscriber table. Try that and then tell something!
BR,
Nuno
2008/8/21 Asim Riaz ariaz78@gmail.com
---------- Forwarded message ---------- From: Asim Riaz ariaz78@gmail.com Date: Thu, Aug 21, 2008 at 2:49 PM Subject: Re: [Kamailio-Users] Help with SerMyAdmin To: Nuno Marques yangsengopenser@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@gmail.comwrote:
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,
Nuno2008/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
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
-
Asim Riaz -
Nuno Marques