David,

This happens sometimes when the modules are installed in a different place. For instance, If you have the line:

loadmodule "/usr/local/lib/ser/modules/sl.so"

in your ser.cfg file, but the module is not in that directory, you will have to modify the loadmodule line to point to the correct directory.

You know, if you do a complete linux install, and give me a login, I'd be happy to get the authentication working for you. I'm a glutton for this kind of torture!

---greg Greg Fausak

-----Original Message----- From: serusers-admin@lists.iptel.org [mailto:serusers-admin@lists.iptel.org] On Behalf Of David Beckemeyer Sent: Wednesday, March 12, 2003 3:57 PM To: serusers@lists.iptel.org Subject: Re: [Serusers] Alternative to Mysql?

Unstable indeed. I built SER from CVS and even using the stock (no DB) ser.cfg, it won't start, and reports:

ERROR: bad config file (16 errors)

ser: parse error (36,13-47): failed to load module ser: set_mod_param(): Parameter not found ser: parse error (46,34-35): Can't set module parameter ser: parse error (70,36-37): unknown command, missing loadmodule? ser: parse error (71,38-39): unknown command, missing loadmodule? ser: parse error (75,41-42): unknown command, missing loadmodule? ser: parse error (80,19-20): unknown command, missing loadmodule? ser: parse error (95,19-20): unknown command, missing loadmodule? ser: parse error (100,25-26): unknown command, missing loadmodule? ser: parse error (101,36-37): unknown command, missing loadmodule? ser: parse error (106,15-16): unknown command, missing loadmodule? ser: parse error (107,18-19): unknown command, missing loadmodule? ser: INFO: signal 15 received

On Wed, Mar 12, 2003 at 08:40:04PM +0100, Daniel-Constantin MIERLA wrote:

...

Hello, see dbtext for that. But notice that the module has not

been thoroughly

...

tested. It is not included in v0.8.10 so you have to use a

CVS snapshot

...

which is quite unstable these days due to lots of changes.

If you want

...

to use it before the new release of ser is out you might get weird situations, but you can provide us some help with testing

... It is your

...

choice ...

-.- Best regards, Daniel

David Beckemeyer wrote:

...

I'm trying to get SER up and I need auth. I'm not a Mysql user and, frankly, I'd rather not need to learn it, just to get authentication support. I wish there were a middle-ground between no-auth at all and a full-blown Mysql installation.

I tried the Cookbook approach, using Dan Austin's HOWTO for setting up Mysql for SER, but the commands do not work as shown so I'm left with learning Mysql through and through to debug why those cookbook commands don't work.

I'm very familiar with SIP and I want to test SER, not a new Sql server DB engine. It seems like Mysql is a distraction to that effort.

Is anyone working on something like a flat-file module to replace Mysql? Any pointers for the best place to start on developing such a module (i.e. shortcuts)?

Thanks,

• david

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

It simply won't start. Am I supposed to run "./ser -f ser.cfg" as root or myself? It doesn't run either way. It prints some diagnostics and exits:

Listening on 127.0.0.1 [127.0.0.1]::5060 209.179.6.12 [209.179.6.12]::5060 Aliases: linux:5060 linux.research.earthlink.net:5060 localhost:5060

But then it exists and there is nothing left running in the background (and nothing listening on port 5060).

This is from a clean CVS build pulled just a few minutes ago.

On Thu, Mar 13, 2003 at 01:15:26AM +0100, Jan Janak wrote:

Hello David,

attached please find updated ser.cfg with authentication enabled using plaintext files instead of mysql.

Do the following:

1. Get the latest CVS snapshot (yes, again)
2. Compile it, but do not install it (don't do make install)
3. Create a directory where your plaintext files containing database tables will be stored
4. Put attached "subscriber" and "location" files in the directory
5. Edit attached ser.cfg
6. Replace /home/janakj/ser with path to the directory (2 occurrencies)
7. save ser.cfg in sip_router directory (the CVS snaphot)
8. Edit subscriber and replace jan with your username, heslo with your password and iptel.org with your domain
9. cd sip_router
10. ./ser -f ser.cfg

Please report any problems to us.

Jan.

PS: See sip_router/modules/dbtext/Readme for description of format of the plaintext files.

On 12-03 13:57, David Beckemeyer wrote:

...

Unstable indeed. I built SER from CVS and even using the stock (no DB) ser.cfg, it won't start, and reports:

ERROR: bad config file (16 errors)

ser: parse error (36,13-47): failed to load module ser: set_mod_param(): Parameter not found ser: parse error (46,34-35): Can't set module parameter ser: parse error (70,36-37): unknown command, missing loadmodule? ser: parse error (71,38-39): unknown command, missing loadmodule? ser: parse error (75,41-42): unknown command, missing loadmodule? ser: parse error (80,19-20): unknown command, missing loadmodule? ser: parse error (95,19-20): unknown command, missing loadmodule? ser: parse error (100,25-26): unknown command, missing loadmodule? ser: parse error (101,36-37): unknown command, missing loadmodule? ser: parse error (106,15-16): unknown command, missing loadmodule? ser: parse error (107,18-19): unknown command, missing loadmodule? ser: INFO: signal 15 received

On Wed, Mar 12, 2003 at 08:40:04PM +0100, Daniel-Constantin MIERLA wrote:

...

Hello, see dbtext for that. But notice that the module has not been thoroughly tested. It is not included in v0.8.10 so you have to use a CVS snapshot which is quite unstable these days due to lots of changes. If you want to use it before the new release of ser is out you might get weird situations, but you can provide us some help with testing ... It is your choice ...

-.- Best regards, Daniel

David Beckemeyer wrote:

...

I'm trying to get SER up and I need auth. I'm not a Mysql user and, frankly, I'd rather not need to learn it, just to get authentication support. I wish there were a middle-ground between no-auth at all and a full-blown Mysql installation.

I tried the Cookbook approach, using Dan Austin's HOWTO for setting up Mysql for SER, but the commands do not work as shown so I'm left with learning Mysql through and through to debug why those cookbook commands don't work.

I'm very familiar with SIP and I want to test SER, not a new Sql server DB engine. It seems like Mysql is a distraction to that effort.

Is anyone working on something like a flat-file module to replace Mysql? Any pointers for the best place to start on developing such a module (i.e. shortcuts)?

Thanks,

• david

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

# # $Id: dbtext.cfg,v 1.2 2003/03/13 00:07:28 janakj Exp $ # # simple quick-start config script #

# ----------- global configuration parameters ------------------------

debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=no # (cmd line: -E)

/* 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"

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database loadmodule "./modules/dbtext/dbtext.so"

loadmodule "./modules/sl/sl.so" loadmodule "./modules/tm/tm.so" loadmodule "./modules/rr/rr.so" loadmodule "./modules/maxfwd/maxfwd.so" loadmodule "./modules/usrloc/usrloc.so" loadmodule "./modules/registrar/registrar.so"

# Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "./modules/auth/auth.so" loadmodule "./modules/auth_db/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_mode", 1) modparam("usrloc", "db_url", "/home/janakj/ser") modparam("auth_db", "db_url", "/home/janakj/ser")

# -- 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")

# ------------------------- request routing logic -------------------

# main routing logic

route{

# initial sanity checks -- messages with # max_forwards==0, or excessively long requests if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); break; }; if (len_gt( max_len )) { sl_send_reply("513", "Message too big"); break; };

# Do strict routing if pre-loaded route headers present loose_route();

# 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") {
	if (!www_authorize("", "subscriber")) {
		www_challenge("", "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 if (!t_relay()) { sl_reply_error(); };

}

user(str) contact(str) expires(int) q(double) callid(str) cseq(int)

username(str) password(str) ha1(str) domain(str) ha1b(str) jan:heslo:xxx:iptel.org:xxx

That would be great, except I'm told I need the CVS version to make use of the feature in question, the alternative database.

Log says:

Mar 31 13:20:00 linux ./ser[17628]: mod_init(): Database connection opened successfuly Mar 31 13:20:00 linux ./ser[17628]: preload_udomain(): Error while doing db_query Mar 31 13:20:00 linux ./ser[17628]: register_udomain(): Error while preloading domain 'location' Mar 31 13:20:00 linux ./ser[17628]: domain_fixup(): Error while registering domain Mar 31 13:20:00 linux ./ser[17628]: INFO: signal 15 received

And I thought VOCAL was difficult to build and get running :-)

On Mon, Mar 31, 2003 at 10:53:20PM +0200, Jiri Kuthan wrote:

At 10:44 PM 3/31/2003, David Beckemeyer wrote:

...

This is from a clean CVS build pulled just a few minutes ago.

That may be exactly the problem. CVS is working place, all of us are committing last-minute changes at full stem now, and we have not started integrating yet. (in particular, I'm aware of a RR commit which has not occured and which is needed to deal with some other changes to core which have already been committed).

Your log file will tell what's exactly wrong. If you need something workable, you will be better off either with the latest release or some elder CVS snapshot (hopefuly, as of March 19th, 6pm is ok).

-Jiri

Hello,

change user(str) in location file to username(str) and try again.

Please note that we only make sure that the code compiles before we commit it. We use our CVS server for development so don't expect that things will always work if you use the latest CVS snapshot. Such a practise is common in the open source world -- and you get what you paid for.

If you find any bugs and report them we will fix them as soon as possible but please don't expect us to test everything after each commit.

regards, Jan.

On 31-03 13:23, David Beckemeyer wrote:

That would be great, except I'm told I need the CVS version to make use of the feature in question, the alternative database.

Log says:

Mar 31 13:20:00 linux ./ser[17628]: mod_init(): Database connection opened successfuly Mar 31 13:20:00 linux ./ser[17628]: preload_udomain(): Error while doing db_query Mar 31 13:20:00 linux ./ser[17628]: register_udomain(): Error while preloading domain 'location' Mar 31 13:20:00 linux ./ser[17628]: domain_fixup(): Error while registering domain Mar 31 13:20:00 linux ./ser[17628]: INFO: signal 15 received

And I thought VOCAL was difficult to build and get running :-)

On Mon, Mar 31, 2003 at 10:53:20PM +0200, Jiri Kuthan wrote:

...

At 10:44 PM 3/31/2003, David Beckemeyer wrote:

...

This is from a clean CVS build pulled just a few minutes ago.

That may be exactly the problem. CVS is working place, all of us are committing last-minute changes at full stem now, and we have not started integrating yet. (in particular, I'm aware of a RR commit which has not occured and which is needed to deal with some other changes to core which have already been committed).

Your log file will tell what's exactly wrong. If you need something workable, you will be better off either with the latest release or some elder CVS snapshot (hopefuly, as of March 19th, 6pm is ok).

-Jiri

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

On Apr 01, 2003 at 18:12, vijay vktiruveedula@foreseeinfo.com wrote:

hi, got the following error while restarting the ser server after changing the ser.cfg file for loading the mysql module.

[root@afi init.d]# ser start 0(4478) ERROR: load_module: could not open module <//usr/lib/ser/modules/mysql.so>: libmysqlclient.so.10: cannot open shared object file: No such file or directory 0(4478) parse error (22,13-44): failed to load module ERROR: bad config file (1 errors)

what may be the cause. Can u help me.

You don't have libmysqlclient installed. The mysql module needs it. Get the package for your linux distribution/os and install it (for debian apt-get install libmysqlclient will do it).

Andrei