Dear serusers, It still does not work. Here is what I did so far to figure this out. BACKGROUND INFO: 1) When I log in to MySQL from the command line I use the following command: "mysql -pMyPwd ser" 2) From conf.php: db_host=123.123.123.123, db_name=ser, db_user=ser, db_pass=heslo 3) My domain is sip.leosser.net QUESTIONS/PROBLEMS : 1) Shouldn't db_user='admin' and NOT 'ser' since this is what the 'username' field is for the password 'heslo' in the MySQL database? However, if I change this I don't even get to the login screen on serweb. 2) I have tried logging in as admin(a)sip.leosser.net and password heslo, root(a)sip.leosser.net and mypwd. Nothing works when I do get to the serweb login screen. I am stuck. Anyone have any suggestions? Leo P. leo(a)ltcjp.com -----Original Message----- From: li wei [mailto:augzbaby@yahoo.com.au] Sent: Wednesday, June 29, 2005 10:14 PM To: Leo Cc: serusers(a)lists.iptel.org Subject: Re: [Serusers] Logging into SERWEB Please make sure your username, password and domain values are exactly matched the values of your subscriber table. Wilson --- Leo <leo(a)ltcjp.com> wrote: ____________________________________________________ Do you Yahoo!? Try Yahoo! Photomail Beta: Send up to 300 photos in one email! http://au.photomail.mail.yahoo.com

Dear Karel, Thank you for the quick response and the thorough answer, but I cannot seem to follow your advice because: 1) I cannot find the file 'configure_data_layer.php'. I even did and updatedb and a locate. 2) There is nothing about username and password on my ser.cfg. 3) I don't know which .php file to change to add '$config->enable_loging = true'. I cannot find this parameter in the config.php file. I also don't know to where the logs would be stored. The result of the sql query were as follows Username = admin Password = heslo Domain = sip.mydomain.net Leo P. -----Original Message----- From: Karel Kozlik [mailto:karel@iptel.org] Sent: Thursday, June 30, 2005 7:36 AM To: Leo Cc: serusers(a)lists.iptel.org Subject: Re: [Serusers] Logging into SERWEB Hi Leo, there are two kinds of user: 1. system user for login into mysql. Default username=ser, password=heslo. This is used for security your database against unauthorized access. This values should be set in config_data_layer.php (and ser.cfg of course). How to change default password you can find in mysql manual. 2. sip users Serweb admin is special sip user. Default username is admin@<your_domain> and password is heslo. Usernames and passwords of sip users are stored in table 'subscriber' in DB. To check your exact values you can login to mysql from command line: mysql -u ser -pheslo ser and type: select username, domain, password from subscriber; If you still can't login into serweb follow this FAQ: Q: Still can't login into serweb by default username and password A: Enable loging in serweb ($config->enable_loging = true) and see log file. For more verbosity set log level to PEAR_LOG_DEBUG Karel Leo napsal(a): command: 'username'

Dear Iqbal, I was using an older version of serweb that did not allow logging. So I upgraded. However, no I have a different problem. When I try to start SER with mysql and auth, I get an error message. Here is the info. BACKGROUND: 1) I have installed FC4 successfully. 2) I have installed SER 0.9.3 WITHOUT mysql support successfully. I even made phone calls. 3) I then ran the ser_mysql.sh script successfully. I see the 'ser' database with its tables in mysql. 4) I then modifed ser.cfg to allow authentication. 5) I now get this message in the /var/log/messages file: Jun 30 16:02:09 sip ser: ERROR: load_module: could not open module </usr/local/lib/ser/modules/mysql.so>: libmysqlclient.so.12: cannot open shared object file: No such file or directory Jun 30 16:02:09 sip ser: parse error (35,13-14): failed to load module QUESTION: Why do I get the above error message? For reference the 1st 35 lines of my ser.cfg are enclosed. The above seems to be complaining about line 35, line 14, and line 15 # # $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp $ # # simple quick-start config script # # ----------- global configuration parameters ------------------------ #debug=3 # debug level (cmd line: -dddddddddd) #fork=yes #log_stderror=no # (cmd line: -E) /* Uncomment these lines to enter debugging mode fork=no log_stderror=yes */ check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) #port=5060 #children=4 fifo="/tmp/ser_fifo" fifo_mode=0666 #---leo's stuff listen=69.0.78.113 alias=sip.telecomcto.com alias=69.0.78.113 alias=telecomcto.com # ------------------ module loading ---------------------------------- # Uncomment this if you want to use SQL database loadmodule "/usr/local/lib/ser/modules/mysql.so" Sincerely, Leo P. -----Original Message----- From: Iqbal [mailto:iqbal@gigo.co.uk] Sent: Thursday, June 30, 2005 1:31 PM To: Leo Cc: 'li wei'; serusers(a)lists.iptel.org Subject: Re: [Serusers] Logging into SERWEB are you logging all request which goto Mysql, if so can you tail -f /var/log/<mysql_log_filename> and when you try to connect from serweb see what it sends Iqbal Leo wrote: command: 'username'