[Serusers] hi all, newbie problem probably
Iqbal
iqbal at gigo.co.uk
Thu Mar 3 18:51:55 CET 2005
well thats because linux et all is opensource hence the advice free,
whereas if I was supporting MS I would have to:
1. Charge
2. Ask you to reboot before anything
3. Ask you to install patches
4. Ask you to upgrade the underlying OS
5. transfer the support email
6. Post as a open ticket to tech support in US,,,and then hope you dont
call back
7. Charge....ad infinitum :-)
Iqbal
On 3/3/2005, "Olivier.taylor" <olivier.taylor at gmail.com> wrote:
>First of all, I am really surprised how Linux and ser users are so kind,
>I am from the windows world and they are not so fast and kind, spending
>time to help a stupid noob user, thanks for that, when i'll be the king
>of Linux(hope I will be) and Ser, i will help everyone needing help like
>you do.
>I will check all the stuff coming to me by you and tell you more after.
>Thanks again,
>
>Olivier
>
>Iqbal wrote:
>
>>In short u are trying to connect to a database but cant
>>
>>1. Do you have a database
>>2. If yes, is it on same machine
>>3. If not on same machine can you connect to the database from the ser
>>machine from the command line eg mysql -h DB.IP.ADD.RESS -u ser -p<pass>
>><db_name>
>>4. If not then make sure you can before you go into ser
>>5. Once you can connect from the command line, then change
>>modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
>>
>>and enter is ur username instead of "ser", and your password instead of
>>"heslo" and your IP address of machine where DB is instead of
>>"localhost", and if by some strange act s & M you have decided to call
>>your database something other than "ser" replace the "ser" at the
>>end with your db name
>>
>>6. Try starting ser again, and it should connect
>>7. To debug your DB connection, and to see what ser is doing under the
>>hood, start mysql with logging enabled, usually will goto mysqld.log in
>>/var/log
>>
>>8. then tail -f /var/log/mysqld.log |more and sit and watch as ser tries
>>to connect, and see what error it shows
>>
>>Iqbal
>>
>>PS If you have changed your DB name to something other than ser....change
>>back :-)
>>
>>
>>
>>On 3/3/2005, "Mohammad Khan" <info at beeplove.com> wrote:
>>
>>
>>
>>>First of all, I am not SER expert.
>>>From my last couple of weeks learning I will suggest below:
>>>
>>>
>>>Olivier.taylor wrote:
>>>
>>>
>>>
>>>>Thx to be so fast,
>>>>here is my ser.cfg
>>>>#
>>>># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 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
>>>>debug=7
>>>>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_db_url="mysql://ser:heslo@localhost/ser" #
>>><--------- if you want fifo db
>>>
>>>
>>>
>>>># ------------------ module loading ----------------------------------
>>>>
>>>># Uncomment this if you want to use SQL database
>>>>loadmodule "/usr/lib/ser/modules/mysql.so"
>>>>
>>>>loadmodule "/usr/lib/ser/modules/sl.so"
>>>>loadmodule "/usr/lib/ser/modules/tm.so"
>>>>loadmodule "/usr/lib/ser/modules/rr.so"
>>>>loadmodule "/usr/lib/ser/modules/maxfwd.so"
>>>>loadmodule "/usr/lib/ser/modules/usrloc.so"
>>>>loadmodule "/usr/lib/ser/modules/registrar.so"
>>>>
>>>># Uncomment this if you want digest authentication
>>>># mysql.so must be loaded !
>>>>loadmodule "/usr/lib/ser/modules/auth.so"
>>>>loadmodule "/usr/lib/ser/modules/auth_db.so"
>>>>
>>>># ----------------- setting module-specific parameters ---------------
>>>>
>>>># -- usrloc params --
>>>>
>>>>#modparam("usrloc", "db_mode", 0)
>>>>
>>>># Uncomment this if you want to use SQL database
>>>># for persistent storage and comment the previous line
>>>>
>>>>
>>>modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser") #
>>><---- you need define this, if your database is different than default
>>>
>>>
>>>
>>>>modparam("usrloc", "db_mode", 2)
>>>>
>>>># -- auth params --
>>>># Uncomment if you are using auth module
>>>>#
>>>>#modparam("auth_db", "calculate_ha1", yes)
>>>>#
>>>># If you set "calculate_ha1" parameter to yes (which true in this
>>>>config),
>>>># uncomment also the following parameter)
>>>>#
>>>>#modparam("auth_db", "password_column", "password")
>>>>
>>>># -- rr params --
>>>># add value to ;lr param to make some broken UAs happy
>>>>
>>>>
>>>modparam("rr", "enable_full_lr", 1) # <----------- i think you want this
>>>
>>>
>>>
>>>># ------------------------- request routing logic -------------------
>>>>
>>>># main routing logic
>>>>alias="finalcut.be"
>>>>alias="linux.finalcut.be"
>>>>alias="82.146.123.252"
>>>>
>>>>
>>>its better to put above three lines in global section
>>>if your computer ip is 82.146.123.252
>>>you should have
>>>listen=82.146.123.252
>>>alias="finalcut.be"
>>>alias="linux.finalcut.be"
>>>
>>>
>>>For the rest of your config file, i really can't help.
>>>I am also learing to write route logic.
>>>
>>>
>>>
>>>>route{
>>>>
>>>> # initial sanity checks -- messages with
>>>> # max_forwards==0, or excessively long requests
>>>> if (!mf_process_maxfwd_header("70")) {
>>>> sl_send_reply("483","Too Many Hops");
>>>> break;
>>>> };
>>>> if ( msg:len > max_len ) {
>>>> sl_send_reply("513", "Message too big");
>>>> break;
>>>> };
>>>>
>>>> # we record-route all messages -- to make sure that
>>>> # subsequent messages will go through our proxy; that's
>>>> # particularly good if upstream and downstream entities
>>>> # use different transport protocol
>>>> record_route(); # loose-route processing
>>>> if (loose_route()) {
>>>> t_relay();
>>>> break;
>>>> };
>>>>
>>>> # if the request is for other domain use UsrLoc
>>>> # (in case, it does not work, use the following command
>>>> # with proper names and addresses in it)
>>>> if (uri==myself) {
>>>>
>>>> if (method=="REGISTER") {
>>>>
>>>># Uncomment this if you want to use digest authentication
>>>> if (!www_authorize("82.146.123.252", "subscriber")) {
>>>> www_challenge("82.146.123.252", "0");
>>>> break;
>>>> };
>>>>
>>>> save("location");
>>>> break;
>>>> };
>>>>
>>>> # native SIP destinations are handled using our USRLOC DB
>>>> if (!lookup("location")) {
>>>> sl_send_reply("404", "Not Found");
>>>> break;
>>>> };
>>>> };
>>>> # forward to current uri now; use stateful forwarding; that
>>>> # works reliably even if we forward from TCP to UDP
>>>> if (!t_relay()) {
>>>> sl_reply_error();
>>>> };
>>>>
>>>>}
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>Mohammad Khan wrote:
>>>>
>>>>
>>>>
>>>>>you will need something like this in you ser.cfg
>>>>>modparam("auth_db", "db_url", "mysql://ser:heslo@localhost/ser")
>>>>>modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
>>>>>
>>>>>I can tell you better if I could see your ser.cfg
>>>>>
>>>>>MOhammad
>>>>>
>>>>>
>>>>>Olivier.taylor wrote:
>>>>>
>>>>>
>>>>>
>>>>>>I installed ser on a linux box centos 3.4
>>>>>>I use mysql 4.10
>>>>>>
>>>>>>Furthermore I am noob on Linux and Ser :(
>>>>>>
>>>>>>I get this messages at boot in the messages file
>>>>>>Impossible the for an UA to connect to ser...
>>>>>>
>>>>>>Help is welcome,
>>>>>>regards,
>>>>>>
>>>>>>Olivier
>>>>>>
>>>>>>Mar 3 17:12:19 linux ser: WARNING: could not rev. resolve
>>>>>>82.146.123.252
>>>>>>Mar 3 17:12:19 linux ser: Listening on
>>>>>>Mar 3 17:12:19 linux ser: 127.0.0.1 [127.0.0.1]:5060
>>>>>>Mar 3 17:12:19 linux ser: 82.146.123.252
>>>>>>[82.146.123.252]:5060
>>>>>>Mar 3 17:12:19 linux ser: Aliases: localhost:5060
>>>>>>localhost.localdomain:5060 82.146.123.252:* linux.finalcut.be:*
>>>>>>finalcut.be:*
>>>>>>Mar 3 17:12:19 linux ser: Listening on
>>>>>>Mar 3 17:12:19 linux ser: 127.0.0.1 [127.0.0.1]:5060
>>>>>>Mar 3 17:12:19 linux ser: 82.146.123.252
>>>>>>[82.146.123.252]:5060
>>>>>>Mar 3 17:12:19 linux ser: Aliases: localhost:5060
>>>>>>localhost.localdomain:5060 82.146.123.252:* linux.finalcut.be:*
>>>>>>finalcut.be:*
>>>>>>Mar 3 17:12:19 linux ser: Listening on
>>>>>>Mar 3 17:12:19 linux ser: 127.0.0.1 [127.0.0.1]:5060
>>>>>>Mar 3 17:12:19 linux ser: 82.146.123.252
>>>>>>[82.146.123.252]:5060
>>>>>>Mar 3 17:12:19 linux ser: Aliases: localhost:5060
>>>>>>localhost.localdomain:5060 82.146.123.252:* linux.finalcut.be:*
>>>>>>finalcut.be:*
>>>>>>Mar 3 17:12:19 linux ser: ser startup succeeded
>>>>>>Mar 3 17:12:19 linux /usr/sbin/ser[2649]: connect_db(): Can't
>>>>>>connect to local MySQL server through socket
>>>>>>'/var/lib/mysql/mysql.sock' (2)
>>>>>>Mar 3 17:12:19 linux /usr/sbin/ser[2649]: db_init(): Error while
>>>>>>trying to connect database
>>>>>>Mar 3 17:12:19 linux /usr/sbin/ser[2649]: mod_init(): Error while
>>>>>>connecting database
>>>>>>Mar 3 17:12:19 linux /usr/sbin/ser[2649]: init_mod(): Error while
>>>>>>initializing module usrloc
>>>>>>
>>>>>>_______________________________________________
>>>>>>Serusers mailing list
>>>>>>serusers at lists.iptel.org
>>>>>>http://lists.iptel.org/mailman/listinfo/serusers
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>Let me know, if it improves the situation.
>>>
>>>Good Luck
>>>MOhammad
>>>
>>>
>>>_______________________________________________
>>>Serusers mailing list
>>>serusers at lists.iptel.org
>>>http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
>
More information about the sr-users
mailing list