Peter,
I am not a perl guy ....

Here is the setup in Defaults.pm  

Is there something else I need to setup ?


Thanks
Chris

# --------------------------------------------------- #
    # database settings                                   #
    # --------------------------------------------------- #
    # DatabaseHost
    # (The database host.)
    $Self->{DatabaseHost} = 'myhost';

    # Database
    # (The database name.)
    $Self->{Database} = 'oracle';

    # DatabaseUser
    # (The database user.)
    $Self->{DatabaseUser} = 'otrs';

    # DatabasePw
    # (The password of database user.)
    $Self->{DatabasePw} = 'xxxx';

    # DatabaseDSN
    # (The database DSN for MySQL ==> more: "man DBD::mysql")
    #$Self->{DatabaseDSN} = "DBI:mysql:database=<OTRS_CONFIG_Database>;host=<OTRS_CONFIG_DatabaseHost>;";

    # (The database DSN for PostgreSQL ==> more: "man DBD::Pg")
    # $Self->{DatabaseDSN} = "DBI:Pg:dbname=<OTRS_CONFIG_Database>;host=<OTRS_CONFIG_DatabaseHost>;";

    # (The database DSN for DBI:ODBC ==> more: "man DBD::ODBC")
    #$Self->{DatabaseDSN} = "DBI:ODBC:$Self->{Database}";
    # If you use ODBC, no database auto detection is possible,
    # so set the database type here. Possible: mysq,postgresql,sapdb
    #$Self->{'Database::Type'} = 'oracle';

    # (The database DSN for Oracle ==> more: "man DBD::oracle")
    # $Self->{DatabaseDSN} = "DBI:Oracle:sid=$Self->{Database};host=$Self->{DatabaseHost};port=1521;";

    $Self->{DatabaseDSN} = "DBI:Oracle:sid=lab;host=10.3.161.1;port=1521;";


Chris Roffler <croffler@yahoo.com> wrote:
Yes I did !



Peter van Beugen <Peter@tda.nl> wrote:
Did you create the OTRS database in Oracle??
 
Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Chris Roffler
Verzonden: vrijdag 20 oktober 2006 17:04
Aan: otrs@otrs.org
Onderwerp: [otrs] OTRS and Oracle
 
I have installed OTRS out of the box  ... so far so good !

I installed ldap as authentication mechanism , works !
Now I want to use Oracle as my repository for my data ..... storing tickets etc. I have installed Oracle with the DDL from OTRS.

I changed all the parameters in Config.pm to point to Oracle .. at least I think so...

I stop MySQL ... when I start OTRS and try to hit the login url I get an error, OTRS can't find MySQL .   What am I missing here, using Oracle as a backend it still needs mySQL ? 
Does anybody have clear instructions what needs to be configured and where in order to have Oracle as a repository for the tickets ?

Thanks
Chris
 
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail.
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com _______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/




Chris Roffler <croffler@yahoo.com> wrote:
Yes I did !



Peter van Beugen <Peter@tda.nl> wrote:
Did you create the OTRS database in Oracle??
 
Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Chris Roffler
Verzonden: vrijdag 20 oktober 2006 17:04
Aan: otrs@otrs.org
Onderwerp: [otrs] OTRS and Oracle
 
I have installed OTRS out of the box  ... so far so good !

I installed ldap as authentication mechanism , works !
Now I want to use Oracle as my repository for my data ..... storing tickets etc. I have installed Oracle with the DDL from OTRS.

I changed all the parameters in Config.pm to point to Oracle .. at least I think so...

I stop MySQL ... when I start OTRS and try to hit the login url I get an error, OTRS can't find MySQL .   What am I missing here, using Oracle as a backend it still needs mySQL ? 
Does anybody have clear instructions what needs to be configured and where in order to have Oracle as a repository for the tickets ?

Thanks
Chris
 
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail.
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com _______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/

How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.