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(a)gmail.com>
---------- 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;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
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users