29 Nov
2006
29 Nov
'06
4:23 a.m.
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.
29 Nov
29 Nov
11:12 a.m.
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
11:32 a.m.
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.
--
...Bye..Dmitry.
1:25 p.m.
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.
1:31 p.m.
Dmitry Semyonov wrote:
On Tue, 28 Nov 2006 at 19:23 -0800, Abdul Qadir
wrote:
I have scheduled that one to be fixed before Ottendorf is out, so this
will be fixed soon.
Jan.
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.
30 Nov
30 Nov
4:04 a.m.
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(a)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.
--
...Bye..Dmitry.
---------------------------------
Want to start your own business? Learn how on Yahoo! Small Business.
6:20 a.m.
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
--
...Bye..Dmitry.
4 Dec
4 Dec
11:01 a.m.
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(a)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
--
...Bye..Dmitry.
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.
12:03 p.m.
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(a)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
--
...Bye..Dmitry.
12:06 p.m.
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:
cd sip_router
Dmitry Semyonov <dsemyonov(a)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
--
...Bye..Dmitry.
5 Dec
5 Dec
8:44 a.m.
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(a)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:
cd sip_router
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 make modules=modules/oracle modules
--
...Bye..Dmitry.
---------------------------------
Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done
faster.
11:37 a.m.
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
--
...Bye..Dmitry.
6362
days inactive
6368
days old
11 comments
4 participants
participants (4)
-
Abdul Qadir -
Dmitry Semyonov -
Greger V. Teigre -
Jan Janak