Hi All,
We are currently using radius server for authentication. Is it possible to use oracle database with SER without using radius server. We have no problem if need to develop our own module for it, but the concern is whether we still be able to do digest authentication if we take out the radius server.
Best Regards, Abdul Qadir
--------------------------------- Want to start your own business? Learn how on Yahoo! Small Business.
Hi Abdul, A suggestion: openser and ser are pretty similar in module interfaces. Openser has an unixodbc module that pretty much can be dropped into the modules dir (0.9.x) and compiled. Ottendorf may need some modifications. And yes, digest is implemented for databases without radius. If you are interested in maintaining the unixodbc modules for ser, that is of interest, I think. g-)
Abdul Qadir wrote:
Hi All,
We are currently using radius server for authentication. Is it
possible to use oracle database with SER without using radius server. We have no problem if need to develop our own module for it, but the concern is whether we still be able to do digest authentication if we take out the radius server.
Best Regards, Abdul Qadir
Want to start your own business? Learn how on Yahoo! Small Business. http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index
Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
On Tue, 28 Nov 2006 at 19:23 -0800, Abdul Qadir wrote:
We are currently using radius server for authentication. Is
it possible to use oracle database with SER without using radius server.
Yes, it is.
We have no problem if need to develop our own module for it,
There is working oracle module in stable (rel_0_9_0) branch of experimental tree. It might not work with all ser & serweb tables, but it definitely works with version, subscriber, and location ones, (though you should create them manually with proper types, and probably change the name of uid column if any). This is enough for authentication and persistent storage of registered contacts.
I'm going to review this module for Ottendorf release, and commit necessary fixes to proper CVS branch or HEAD within a week or two. I'll also provide patches for XSLT scripts for oracle schema creation real-soon-now.
Note that SER-150 issue has to be fixed as well.
I'm sorry, Dmitri, I was just to answer quickly and for some reason I totally forgot about it. :-( I have even followed the recent serdev thread on conflicts. I think I'll go for a vacation... g-)
Dmitry Semyonov wrote:
On Tue, 28 Nov 2006 at 19:23 -0800, Abdul Qadir wrote:
We are currently using radius server for authentication. Is
it possible to use oracle database with SER without using radius server.
Yes, it is.
We have no problem if need to develop our own module for it,
There is working oracle module in stable (rel_0_9_0) branch of experimental tree. It might not work with all ser & serweb tables, but it definitely works with version, subscriber, and location ones, (though you should create them manually with proper types, and probably change the name of uid column if any). This is enough for authentication and persistent storage of registered contacts.
I'm going to review this module for Ottendorf release, and commit necessary fixes to proper CVS branch or HEAD within a week or two. I'll also provide patches for XSLT scripts for oracle schema creation real-soon-now.
Note that SER-150 issue has to be fixed as well.
Dmitry Semyonov wrote:
On Tue, 28 Nov 2006 at 19:23 -0800, Abdul Qadir wrote:
We are currently using radius server for authentication. Is
it possible to use oracle database with SER without using radius server.
Yes, it is.
We have no problem if need to develop our own module for it,
There is working oracle module in stable (rel_0_9_0) branch of experimental tree. It might not work with all ser & serweb tables, but it definitely works with version, subscriber, and location ones, (though you should create them manually with proper types, and probably change the name of uid column if any). This is enough for authentication and persistent storage of registered contacts.
I'm going to review this module for Ottendorf release, and commit necessary fixes to proper CVS branch or HEAD within a week or two. I'll also provide patches for XSLT scripts for oracle schema creation real-soon-now.
Note that SER-150 issue has to be fixed as well.
I have scheduled that one to be fixed before Ottendorf is out, so this will be fixed soon.
Jan.
Hi Dmitry,
Thanks for your response. Actually i was looking for this module but was unable to locate it. (I followed the steps mentioned on http://www.iptel.org/downloads)
Could you please send me link which i can use to download it.
Thanking you in advance :-) Best Regards, Abdul Qadir
Dmitry Semyonov dsemyonov@dins.ru wrote: On Tue, 28 Nov 2006 at 19:23 -0800, Abdul Qadir wrote:
We are currently using radius server for authentication. Is
it possible to use oracle database with SER without using radius server.
Yes, it is.
We have no problem if need to develop our own module for it,
There is working oracle module in stable (rel_0_9_0) branch of experimental tree. It might not work with all ser & serweb tables, but it definitely works with version, subscriber, and location ones, (though you should create them manually with proper types, and probably change the name of uid column if any). This is enough for authentication and persistent storage of registered contacts.
I'm going to review this module for Ottendorf release, and commit necessary fixes to proper CVS branch or HEAD within a week or two. I'll also provide patches for XSLT scripts for oracle schema creation real-soon-now.
Note that SER-150 issue has to be fixed as well.
Abdul,
On Wed, 29 Nov 2006 at 19:04 -0800, Abdul Qadir wrote:
Thanks for your response. Actually i was looking for this module
but was unable to locate it. (I followed the steps mentioned on http://www.iptel.org/downloads)
Could you please send me link which i can use to download it.
You need to use CVS:
export CVSROOT=:pserver:anonymous@cvs.berlios.de:/cvsroot/ser cvs -z4 co -r rel_0_9_0 experimental/oracle cvs -z4 co -r rel_0_9_0 sip_router
Hi,
This is the error I received when I compiled the modules.
dbase.c: In function `db_free_result': dbase.c:377: warning: passing arg 2 of `fm_free' discards qualifiers from pointer target type dbase.c: In function `oci_prepare': dbase.c:1145: parse error before `rc' dbase.c:1148: `rc' undeclared (first use in this function) dbase.c:1148: (Each undeclared identifier is reported only once dbase.c:1148: for each function it appears in.) dbase.c: In function `oci_execute': dbase.c:1170: parse error before `rc' dbase.c:1173: `rc' undeclared (first use in this function) make: *** [dbase.o] Error 1
Best Regards, Abdul Qadir
Dmitry Semyonov dsemyonov@dins.ru wrote: Abdul,
On Wed, 29 Nov 2006 at 19:04 -0800, Abdul Qadir wrote:
Thanks for your response. Actually i was looking for this module
but was unable to locate it. (I followed the steps mentioned on http://www.iptel.org/downloads)
Could you please send me link which i can use to download it.
You need to use CVS:
export CVSROOT=:pserver:anonymous@cvs.berlios.de:/cvsroot/ser cvs -z4 co -r rel_0_9_0 experimental/oracle cvs -z4 co -r rel_0_9_0 sip_router
Abdul,
On Mon, 4 Dec 2006 at 02:01 -0800, Abdul Qadir wrote:
This is the error I received when I compiled the modules.
dbase.c: In function `db_free_result': dbase.c:377: warning: passing arg 2 of `fm_free' discards qualifiers from pointer target type dbase.c: In function `oci_prepare': dbase.c:1145: parse error before `rc'
Please, follow the instructions in oracle/README file. I've just verified that the following sequence of commands results in successfully created module on Debian Etch:
Dmitry Semyonov dsemyonov@dins.ru wrote:
export CVSROOT=:pserver:anonymous@cvs.berlios.de:/cvsroot/ser cvs -z4 co -r rel_0_9_0 experimental/oracle cvs -z4 co -r rel_0_9_0 sip_router
cp -a experimental/oracle sip_router/modules/ sudo unzip $HOME/instantclient-sdk-linux32-10.1.0.5-20060511.zip -d /usr/local sudo unzip $HOME/instantclient-basic-linux32-10.1.0.5-20060511.zip -d /usr/local sudo ln -s libclntsh.so.10.1 /usr/local/instantclient10_1/libclntsh.so sudo ln -s instantclient10_1 /usr/local/instantclient make modules=modules/oracle modules
On Mon, 4 Dec 2006 at 14:03 +0300, Dmitry Semyonov wrote:
Please, follow the instructions in oracle/README file. I've just verified that the following sequence of commands results in successfully created module on Debian Etch:
Dmitry Semyonov dsemyonov@dins.ru wrote:
export CVSROOT=:pserver:anonymous@cvs.berlios.de:/cvsroot/ser cvs -z4 co -r rel_0_9_0 experimental/oracle cvs -z4 co -r rel_0_9_0 sip_router
cp -a experimental/oracle sip_router/modules/ sudo unzip $HOME/instantclient-sdk-linux32-10.1.0.5-20060511.zip -d /usr/local sudo unzip $HOME/instantclient-basic-linux32-10.1.0.5-20060511.zip -d /usr/local sudo ln -s libclntsh.so.10.1 /usr/local/instantclient10_1/libclntsh.so sudo ln -s instantclient10_1 /usr/local/instantclient
cd sip_router
make modules=modules/oracle modules
Hi Dmitry,
I followed the steps in the README file. The only difference is that you are using Instant Client but I had full oracle client installed on my machine. Thats why I did modified the make file to reflect my path. But still getting the same error. Do u think I still need to install Instant Client, although I have full client installed. My Oracle Server/Client is 9 Os is Fedora core 3
Best Regards, Abdul Qadir
Dmitry Semyonov dsemyonov@dins.ru wrote: On Mon, 4 Dec 2006 at 14:03 +0300, Dmitry Semyonov wrote:
Please, follow the instructions in oracle/README file. I've just verified that the following sequence of commands results in successfully created module on Debian Etch:
Dmitry Semyonov wrote:
export CVSROOT=:pserver:anonymous@cvs.berlios.de:/cvsroot/ser cvs -z4 co -r rel_0_9_0 experimental/oracle cvs -z4 co -r rel_0_9_0 sip_router
cp -a experimental/oracle sip_router/modules/ sudo unzip $HOME/instantclient-sdk-linux32-10.1.0.5-20060511.zip -d /usr/local sudo unzip $HOME/instantclient-basic-linux32-10.1.0.5-20060511.zip -d /usr/local sudo ln -s libclntsh.so.10.1 /usr/local/instantclient10_1/libclntsh.so sudo ln -s instantclient10_1 /usr/local/instantclient
cd sip_router
make modules=modules/oracle modules
Abdul,
On Mon, 4 Dec 2006 at 23:44 -0800, Abdul Qadir wrote:
I followed the steps in the README file. The only difference is
that you are using Instant Client but I had full oracle client installed on my machine.
Another difference is version number. Some types might be missing in previous version.
Thats why I did modified the make file to reflect my path. But still getting the same error. Do u think I still need to install Instant Client, although I have full client installed.
I don't think so. Note however that full Oracle Client installation might not include OCI headers by default, (i.e. you have to select them manually during the installation at least on Windows). I guess this is not your case, so could you send me the archived contents of the folder with your Oracle client include files? TIA
My Oracle Server/Client is 9
BTW, we have no problems using SER + Instant Client 10 which connects to Oracles Server 9.
Os is Fedora core 3