corinis installation, maxdb

Hello all;


just trying to get started using corinis in some intranet
project, and
at the moment, feeling a little disappointed because failing
constantly
(environment: Ubuntu 6.06, tomcat 5.5.12, SAP MaxDB 7.5.*)

A few things:

- corinis-3.0.7.zip is, opposed to what to be read on the
website,
almost unusable on Linux platforms. Doing the quick-install
following
web site instructions didn't work out, and while digging
through the
file system I found corinis.xml to contain a bunch of
configuration
items tailored to work on a special system and not generally
usable
(most notable a database connection to a certain host, as
well as
hardcoded /home/c000<something> entries for pretty
much all path
settings). This is not a big problem as I found it just in a
few
minutes, but it outdates the documentation to be found
online and so is
a little annoying. 

Worse, two database-related issues:

- I'm trying to get corinis to run with MaxDB as backend.
So far, I
configured the JDBC data source but tend to fail while
trying to create
the database:

[...]
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru
n(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
Error (Status: -4006):
com.sap.dbtech.jdbc.exceptions.DatabaseException:
[-4006] (at 43): Unknown dom
ain name:BIGINT Query: create table corinisfunctionauthority
(id bigint
NOT NULL ,userid bigint ,grou
pid bigint ,authority varchar(50) NOT NULL ,source bigint ,
PRIMARY KEY
(id))
[...]

Indeed MaxDB uses INTEGER instead of BIGINT. I modified the
corinis.script changing BIGINT to INTEGER, but the error is
the same (using

http://localhost:8080/corinis/corinis/setup.jsp?app=c
orinis to create
the database).

Why?

After all, _is_ there any use in trying to get corinis to
work with a db
other than mysql or hsqldb right now?




- maxconnections settings: corinis.xml has a configuration
like that for
its database:

[...]
    <CONNECTIONS>2</CONNECTIONS>
    <MAXCONNECTIONS>10</MAXCONNECTIONS>
[...]

Reading the log file, I see right that:

[...]
dbDriver = com.sap.dbtech.jdbc.DriverSapDB
dbServer = jdbc:sapdb://localhost/CMSDB
[...]
log file = /tmp/db.corinis.log
minconnections = 10
maxconnections = 20
Total refresh interval = 0.01 days
logAppend = true
[...]

Why the difference in maxconnections between what is
configured and what
corinis actually tries to use? Any other piece of
configuration to modify?



Thanks in advance for any hints, and thanks for your
patience reading this.
Best regards,
Kris

>
> Hello all;
>
>
> just trying to get started using corinis in some
intranet project, and
> at the moment, feeling a little disappointed because
failing constantly
> (environment: Ubuntu 6.06, tomcat 5.5.12, SAP MaxDB
7.5.*)
>
> A few things:
>
> - corinis-3.0.7.zip is, opposed to what to be read on
the website,
> almost unusable on Linux platforms. Doing the
quick-install following
> web site instructions didn't work out, and while
digging through the
> file system I found corinis.xml to contain a bunch of
configuration
> items tailored to work on a special system and not
generally usable
> (most notable a database connection to a certain host,
as well as
> hardcoded /home/c000<something> entries for
pretty much all path
> settings). This is not a big problem as I found it just
in a few
> minutes, but it outdates the documentation to be found
online and so is
> a little annoying. 
this is quite weird... the .zip configuration should be
completely
realtive-path based... the auto/etc... it seems that a wrong
xml has been
added, i will take a look and update the zip+ mail a new xml
>
> Worse, two database-related issues:
>
> - I'm trying to get corinis to run with MaxDB as
backend. So far, I
> configured the JDBC data source but tend to fail while
trying to create
> the database:
>
> [...]
>         at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru
n(ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
> Error (Status: -4006):
com.sap.dbtech.jdbc.exceptions.DatabaseException:
> [-4006] (at 43): Unknown dom
> ain name:BIGINT Query: create table
corinisfunctionauthority (id bigint
> NOT NULL ,userid bigint ,grou
> pid bigint ,authority varchar(50) NOT NULL ,source
bigint , PRIMARY KEY
> (id))
> [...]
>
> Indeed MaxDB uses INTEGER instead of BIGINT. I modified
the
> corinis.script changing BIGINT to INTEGER, but the
error is the same
> (using
>
> http://localhost:8080/corinis/corinis/setup.jsp?app=c
orinis to create
> the database).
>
> Why?
this is basically because of the inter style on how the
database is
created.. Basically all databases use different slangs when
creating
tables - altough most are pretty consistent when accessing
data (select
and so on).
We did not yet test with MaxDB thus we didnt tweak the
db-conversion
class. but we will see to at asap (probably even today or
tomorrow).

>
> After all, _is_ there any use in trying to get corinis
to work with a db
> other than mysql or hsqldb right now?
yes, it works with oracle as well.

>
> - maxconnections settings: corinis.xml has a
configuration like that for
> its database:
>
> [...]
>     <CONNECTIONS>2</CONNECTIONS>
>     <MAXCONNECTIONS>10</MAXCONNECTIONS>
> [...]
>
> Reading the log file, I see right that:
>
> [...]
> dbDriver = com.sap.dbtech.jdbc.DriverSapDB
> dbServer = jdbc:sapdb://localhost/CMSDB
> [...]
> log file = /tmp/db.corinis.log
> minconnections = 10
> maxconnections = 20
> Total refresh interval = 0.01 days
> logAppend = true
> [...]
>
> Why the difference in maxconnections between what is
configured and what
> corinis actually tries to use? Any other piece of
configuration to modify?

I am roughly guessing: it uses a different corinis.xml... if
not, maybe
its a small bug in the db-init.. i will have a look.
>
> Thanks in advance for any hints, and thanks for your
patience reading
> this.
> Best regards,
> Kris
>
np

Niko

Niko;

at first, thanks a lot for your quick reply.

Niko Berger schrieb:
> this is basically because of the inter style on how the
database is
> created.. Basically all databases use different slangs
when creating
> tables - altough most are pretty consistent when
accessing data (select
> and so on).
> We did not yet test with MaxDB thus we didnt tweak the
db-conversion
> class. but we will see to at asap (probably even today
or tomorrow).


Okay, this sounds good. If I can be of any help getting this
MaxDB
configuration to work... 


> I am roughly guessing: it uses a different
corinis.xml... if not, maybe
> its a small bug in the db-init.. i will have a look.

For what I see, there is just one corinis.xml on my system,
and, aside
from that, changing it actually does somehow affect the
maxconnections
to be shown in the database log, but those values never seem
to match....


Anyway, thanks for your help! 
Best regards,
Kris