[Serusers] Logging into SERWEB

[Leo]

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 at gigo.co.uk] 
Sent: Thursday, June 30, 2005 1:31 PM
To: Leo
Cc: 'li wei'; serusers at 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:

>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 at sip.leosser.net and password heslo,
>root at 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 at ltcjp.com
>
>-----Original Message-----
>From: li wei [mailto:augzbaby at yahoo.com.au] 
>Sent: Wednesday, June 29, 2005 10:14 PM
>To: Leo
>Cc: serusers at 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 at ltcjp.com> wrote:
>
>  
>
>>Dear serusers,
>>
>> 
>>
>>I successfully installed SERWEB.I think.
>>
>> 
>>
>>However, I cannot seem to login at the login screen.
>>
>> 
>>
>>I go to http://mydomain/admin/index.php and I get
>>the login screen, but
>>nothing I try there works. What could this be?
>>
>> 
>>
>>I already tried:
>>
>>'root' and my passoword
>>
>>admin and heslo
>>
>> 
>>
>>I don't know what else to do. Please help.
>>
>> 
>>
>>Sincerely,
>>
>> 
>>
>>Leo Papadopoulos
>>
>>leo at ltcjp.com
>>
>> 
>>
>>    
>>
>>>_______________________________________________
>>>      
>>>
>>Serusers mailing list
>>serusers at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>    
>>
>
>
>
>	
>
>	
>		
>____________________________________________________ 
>Do you Yahoo!? 
>Try Yahoo! Photomail Beta: Send up to 300 photos in one email! 
>http://au.photomail.mail.yahoo.com
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>
>.
>
>  
>