Hi, We are just starting to evaluate otrs, and an initial setup has been done by our systems group. I've created an en_Custom.pm and those changes look OK. What I want to do next is to make otrs use, for its lists of users, an existing and populated mysql database, while keeping tickets themselves in the test mysql db that was set up for me. If I understand the docs correctly, I can do this by adding stuff into Config.pm. It looks like what I need to add is from section 11.2 of the Admin manual: $Self->{CustomerUser} = { .. .. .. } and in there I set it to use an external database and change the names of fields to match those already in use in the existing db. However, when I do this and restart otrs, I get: Software Error: Got no MainObject! at /home/operations/OTRS/otrs-2.2.2//Kernel/System/DB.pm line 85 Any clue as to why (like, can't do this, or check that) would be appreciated. Thanks, ___________________________________________________________________ * * Tim Streater Network Engineer * * * City House * 126-130 Hills Road Tel +44 1223 371300 * Cambridge CB2 1PQ Fax +44 1223 371371 D A N T E United Kingdom WWW http://www.dante.net ____________________________________________________________________
Hi Tim, add the line marked with "+" into DB.pm... if ($Self->{CustomerUserMap}->{Params}->{DSN}) { $Self->{DBObject} = Kernel::System::DB->new( LogObject => $Param{LogObject}, + MainObject => $Param{MainObject}, ConfigObject => $Param{ConfigObject}, DatabaseDSN => $Self->{CustomerUserMap}->{Params}->{DSN}, DatabaseUser => $Self->{CustomerUserMap}->{Params}->{User}, HTH, best regards, Rico On Tue, 21 Aug 2007, Tim Streater wrote:
However, when I do this and restart otrs, I get:
Software Error:
Got no MainObject! at /home/operations/OTRS/otrs-2.2.2//Kernel/System/DB.pm line 85
-- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: rico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: www.cape-it.de Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192
At 20:15 22/08/2007, Rico Barth wrote:
Hi Tim,
add the line marked with "+" into DB.pm...
if ($Self->{CustomerUserMap}->{Params}->{DSN}) { $Self->{DBObject} = Kernel::System::DB->new( LogObject => $Param{LogObject}, + MainObject => $Param{MainObject}, ConfigObject => $Param{ConfigObject}, DatabaseDSN => $Self->{CustomerUserMap}->{Params}->{DSN}, DatabaseUser => $Self->{CustomerUserMap}->{Params}->{User},
HTH, best regards,
Rico
Hi Rico, Thanks - that fixed the software error (BTW, to me this looks like a bug - should I report this via bugzilla?). -- Tim
Hi Tim! On Thu, 23 Aug 2007, Tim Streater wrote:
Thanks - that fixed the software error (BTW, to me this looks like a bug - should I report this via bugzilla?).
Yes, it's a bug. I didn't find time to look for an existing bug on bugs.otrs.org. If you may do that it was great job. This issue was discussed on mailinglist a few weeks ago. Thanks and regards Rico -- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: rico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: www.cape-it.de Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192
Hi, This bug seems already fixed by OTRS Dev Team : http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup - (2007/08/10) Fixed bug# 2156 - External customer database is not working, if it's configured the following error message appears ("Got no MainObject in Kernel/System/DB.pm line 85"). BR, Laurent Le jeudi 23 août 2007 à 16:29 +0200, Rico Barth a écrit :
Hi Tim!
On Thu, 23 Aug 2007, Tim Streater wrote:
Thanks - that fixed the software error (BTW, to me this looks like a bug - should I report this via bugzilla?).
Yes, it's a bug. I didn't find time to look for an existing bug on bugs.otrs.org. If you may do that it was great job. This issue was discussed on mailinglist a few weeks ago.
Thanks and regards
Rico
-- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: rico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: www.cape-it.de
Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192 _______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/
Hi, Interestingly, the same bug and same fix occur if you try to use a different backend db for Customer Companies, too. tim At 16:19 23/08/2007, Laurent Minost wrote:
Hi,
This bug seems already fixed by OTRS Dev Team :
http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markuphttp://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup
- (2007/08/10) Fixed bug# 2156 - External customer database is not working,
if it's configured the following error message appears ("Got no MainObject in Kernel/System/DB.pm line 85").
BR,
Laurent
Le jeudi 23 août 2007 à 16:29 +0200, Rico Barth a écrit :
Hi Tim!
On Thu, 23 Aug 2007, Tim Streater wrote:
Thanks - that fixed the software error (BTW, to me this looks like a bug - should I report this via bugzilla?).
Yes, it's a bug. I didn't find time to look for an existing bug on bugs.otrs.org. If you may do that it was great job. This issue was discussed on mailinglist a few weeks ago.
Thanks and regards
Rico
-- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: mailto:rico.barth@cape-it.derico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: http://www.cape-it.dewww.cape-it.de
Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192 _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrshttp://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrshttp://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/http://www.otrs.com/
-- Tim
Hi Tim, Are you using an external backend DB for CustomerUser and CustomerCompanies please ? If so, can you tell me which OTRS version are you using and confirm me this bug occurs by your side too please ? http://bugs.otrs.org/show_bug.cgi?id=2239 Thanks by advance. Best regards. Laurent Minost Le jeudi 23 août 2007 à 17:14 +0100, Tim Streater a écrit :
Hi,
Interestingly, the same bug and same fix occur if you try to use a different backend db for Customer Companies, too.
tim
At 16:19 23/08/2007, Laurent Minost wrote:
Hi,
This bug seems already fixed by OTRS Dev Team :
http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markuphttp://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup
- (2007/08/10) Fixed bug# 2156 - External customer database is not working,
if it's configured the following error message appears ("Got no MainObject in Kernel/System/DB.pm line 85").
BR,
Laurent
Le jeudi 23 août 2007 à 16:29 +0200, Rico Barth a écrit :
Hi Tim!
On Thu, 23 Aug 2007, Tim Streater wrote:
Thanks - that fixed the software error (BTW, to me this looks like a bug - should I report this via bugzilla?).
Yes, it's a bug. I didn't find time to look for an existing bug on bugs.otrs.org. If you may do that it was great job. This issue was discussed on mailinglist a few weeks ago.
Thanks and regards
Rico
-- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: mailto:rico.barth@cape-it.derico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: http://www.cape-it.dewww.cape-it.de
Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192 _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrshttp://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrshttp://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/http://www.otrs.com/
-- Tim
Laurent, Yes it did, I fixed it by adding: MainObject => $Param{MainObject}, around line 90. I also files a bug report about this. Cheers -- tim At 14:03 30/08/2007, Laurent Minost wrote:
Hi Tim,
Are you using an external backend DB for CustomerUser and CustomerCompanies please ? If so, can you tell me which OTRS version are you using and confirm me this bug occurs by your side too please ? http://bugs.otrs.org/show_bug.cgi?id=2239http://bugs.otrs.org/show_bug.cgi?id=2239
Thanks by advance.
Best regards.
Laurent Minost
Le jeudi 23 août 2007 à 17:14 +0100, Tim Streater a écrit :
Hi,
Interestingly, the same bug and same fix occur if you try to use a different backend db for Customer Companies, too.
tim
At 16:19 23/08/2007, Laurent Minost wrote:
Hi,
This bug seems already fixed by OTRS Dev Team :
<http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markuphttp://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup>http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup
- (2007/08/10) Fixed bug# 2156 - External customer database is not working,
if it's configured the following error message appears ("Got no MainObject in Kernel/System/DB.pm line 85").
BR,
Laurent
Le jeudi 23 août 2007 à 16:29 +0200, Rico Barth a écrit :
Hi Tim!
On Thu, 23 Aug 2007, Tim Streater wrote:
Thanks - that fixed the software error (BTW, to me this looks like a bug - should I report this via bugzilla?).
Yes, it's a bug. I didn't find time to look for an existing bug on bugs.otrs.org. If you may do that it was great job. This issue was discussed on mailinglist a few weeks ago.
Thanks and regards
Rico
-- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: <mailto:rico.barth@cape-it.demailto:rico.barth@cape-it.de>mailto:rico.barth@cape-it.derico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: <http://www.cape-it.dehttp://www.cape-it.de>www.cape-it.de
Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192 _______________________________________________ OTRS mailing list: otrs - Webpage: <http://otrs.org/http://otrs.org/>http://otrs.org/ Archive: <http://lists.otrs.org/pipermail/otrshttp://lists.otrs.org/pipermail/otrs>http://lists.otrs.org/pipermail/otrs To unsubscribe:
<http://lists.otrs.org/cgi-bin/listinfo/otrshttp://lists.otrs.org/cgi-bin/listinfo/otrs>http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => <http://www.otrs.com/http://www.otrs.com/>http://www.otrs.com/
-- Tim
-- Tim
Laurent, Sorry - forgot to add - version 2.2.2. tim At 14:03 30/08/2007, Laurent Minost wrote:
Hi Tim,
Are you using an external backend DB for CustomerUser and CustomerCompanies please ? If so, can you tell me which OTRS version are you using and confirm me this bug occurs by your side too please ? http://bugs.otrs.org/show_bug.cgi?id=2239http://bugs.otrs.org/show_bug.cgi?id=2239
Thanks by advance.
Best regards.
Laurent Minost
Le jeudi 23 août 2007 à 17:14 +0100, Tim Streater a écrit :
Hi,
Interestingly, the same bug and same fix occur if you try to use a different backend db for Customer Companies, too.
tim
At 16:19 23/08/2007, Laurent Minost wrote:
Hi,
This bug seems already fixed by OTRS Dev Team :
<http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markuphttp://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup>http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup
- (2007/08/10) Fixed bug# 2156 - External customer database is not working,
if it's configured the following error message appears ("Got no MainObject in Kernel/System/DB.pm line 85").
BR,
Laurent
Le jeudi 23 août 2007 à 16:29 +0200, Rico Barth a écrit :
Hi Tim!
On Thu, 23 Aug 2007, Tim Streater wrote:
Thanks - that fixed the software error (BTW, to me this looks like a bug - should I report this via bugzilla?).
Yes, it's a bug. I didn't find time to look for an existing bug on bugs.otrs.org. If you may do that it was great job. This issue was discussed on mailinglist a few weeks ago.
Thanks and regards
Rico
-- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: <mailto:rico.barth@cape-it.demailto:rico.barth@cape-it.de>mailto:rico.barth@cape-it.derico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: <http://www.cape-it.dehttp://www.cape-it.de>www.cape-it.de
Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192 _______________________________________________ OTRS mailing list: otrs - Webpage: <http://otrs.org/http://otrs.org/>http://otrs.org/ Archive: <http://lists.otrs.org/pipermail/otrshttp://lists.otrs.org/pipermail/otrs>http://lists.otrs.org/pipermail/otrs To unsubscribe:
<http://lists.otrs.org/cgi-bin/listinfo/otrshttp://lists.otrs.org/cgi-bin/listinfo/otrs>http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => <http://www.otrs.com/http://www.otrs.com/>http://www.otrs.com/
-- Tim
-- Tim
Tim, Sorry but I was not talking about bug http://bugs.otrs.org/show_bug.cgi?id=2156 which is already fixed as cvs CHANGES file mentions it. I'm talking about a new case I found today : http://bugs.otrs.org/show_bug.cgi?id=2239 which is affecting CustomerCompanySupport when using external backend DB. Could you tell me if you also have the same behaviour please ? It will be easy to test if you already have external backend db in place right now. Thanks. BR. Laurent Minost Le jeudi 30 août 2007 à 14:11 +0100, Tim Streater a écrit :
Laurent,
Sorry - forgot to add - version 2.2.2.
tim
At 14:03 30/08/2007, Laurent Minost wrote:
Hi Tim,
Are you using an external backend DB for CustomerUser and CustomerCompanies please ? If so, can you tell me which OTRS version are you using and confirm me this bug occurs by your side too please ? http://bugs.otrs.org/show_bug.cgi?id=2239http://bugs.otrs.org/show_bug.cgi?id=2239
Thanks by advance.
Best regards.
Laurent Minost
Le jeudi 23 août 2007 à 17:14 +0100, Tim Streater a écrit :
Hi,
Interestingly, the same bug and same fix occur if you try to use a different backend db for Customer Companies, too.
tim
At 16:19 23/08/2007, Laurent Minost wrote:
Hi,
This bug seems already fixed by OTRS Dev Team :
<http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markuphttp://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup>http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup
- (2007/08/10) Fixed bug# 2156 - External customer database is not working,
if it's configured the following error message appears ("Got no MainObject in Kernel/System/DB.pm line 85").
BR,
Laurent
Le jeudi 23 août 2007 à 16:29 +0200, Rico Barth a écrit :
Hi Tim!
On Thu, 23 Aug 2007, Tim Streater wrote:
Thanks - that fixed the software error (BTW, to me this looks like a bug - should I report this via bugzilla?).
Yes, it's a bug. I didn't find time to look for an existing bug on bugs.otrs.org. If you may do that it was great job. This issue was discussed on mailinglist a few weeks ago.
Thanks and regards
Rico
-- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: <mailto:rico.barth@cape-it.demailto:rico.barth@cape-it.de>mailto:rico.barth@cape-it.derico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: <http://www.cape-it.dehttp://www.cape-it.de>www.cape-it.de
Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192 _______________________________________________ OTRS mailing list: otrs - Webpage: <http://otrs.org/http://otrs.org/>http://otrs.org/ Archive: <http://lists.otrs.org/pipermail/otrshttp://lists.otrs.org/pipermail/otrs>http://lists.otrs.org/pipermail/otrs To unsubscribe:
<http://lists.otrs.org/cgi-bin/listinfo/otrshttp://lists.otrs.org/cgi-bin/listinfo/otrs>http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => <http://www.otrs.com/http://www.otrs.com/>http://www.otrs.com/
-- Tim
-- Tim
Laurent, I know, I know :-) Both bugs are fixed in a similar way. The fix I mentioned in my mail refers to the CustomerCompany bug. Cheers -- tim At 14:23 30/08/2007, Laurent Minost wrote:
Tim,
Sorry but I was not talking about bug http://bugs.otrs.org/show_bug.cgi?id=2156http://bugs.otrs.org/show_bug.cgi?id=2http://bugs.otrs.org/show_bug.cgi?id=2156156 which is already fixed as cvs CHANGES file mentions it.
I'm talking about a new case I found today : http://bugs.otrs.org/show_bug.cgi?id=2239http://bugs.otrs.org/show_bug.cgi?id=2239 which is affecting CustomerCompanySupport when using external backend DB. Could you tell me if you also have the same behaviour please ? It will be easy to test if you already have external backend db in place right now.
Thanks. BR.
Laurent Minost
Le jeudi 30 août 2007 à 14:11 +0100, Tim Streater a écrit :
Laurent,
Sorry - forgot to add - version 2.2.2.
tim
At 14:03 30/08/2007, Laurent Minost wrote:
Hi Tim,
Are you using an external backend DB for CustomerUser and CustomerCompanies please ? If so, can you tell me which OTRS version are you using and confirm me this bug occurs by your side too please ? <http://bugs.otrs.org/show_bug.cgi?id=2239http://bugs.otrs.org/show_bug.cgi?id=2239>http://bugs.otrs.org/show_bug.cgi?id=2239
Thanks by advance.
Best regards.
Laurent Minost
Le jeudi 23 août 2007 à 17:14 +0100, Tim Streater a écrit :
Hi,
Interestingly, the same bug and same fix occur if you try to use a different backend db for Customer Companies, too.
tim
At 16:19 23/08/2007, Laurent Minost wrote:
Hi,
This bug seems already fixed by OTRS Dev Team :
GES?revision=1.454&view=markup>http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup>http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup>http://cvs.otrs.org/viewvc.cgi/otrs/CHANGES?revision=1.454&view=markup
- (2007/08/10) Fixed bug# 2156 - External customer database is not working,
if it's configured the following error message appears ("Got no MainObject in Kernel/System/DB.pm line 85").
BR,
Laurent
Le jeudi 23 août 2007 à 16:29 +0200, Rico Barth a écrit :
Hi Tim!
On Thu, 23 Aug 2007, Tim Streater wrote:
> Thanks - that fixed the software error (BTW, to me this looks like a bug - > should I report this via bugzilla?).
Yes, it's a bug. I didn't find time to look for an existing bug on bugs.otrs.org. If you may do that it was great job. This issue was discussed on mailinglist a few weeks ago.
Thanks and regards
Rico
-- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile: +49 176 66680786 mailto: <<mailto:rico.barth@cape-it.demailto:rico.barth@cape-it.de>mailto:rico.barth@cape-it.de><mailto:rico.barth@cape-it.demailto:rico.barth@cape-it.de>mailto:rico.barth@cape-it.derico.barth@cape-it.de , PGP-Key: 0x874C8377 internet: <<http://www.cape-it.dehttp://www.cape-it.de>http://www.cape-it.de>www.cape-it.de
Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192 _______________________________________________ OTRS mailing list: otrs - Webpage: <<http://otrs.org/http://otrs.org/>http://otrs.org/>http://otrs.org/ Archive: <<http://lists.otrs.org/pipermail/otrshttp://lists.otrs.org/pipermail/otrs>http://lists.otrs.org/pipermail/otrs>http://lists.otrs.org/pipermail/otrs To unsubscribe:
<<http://lists.otrs.org/cgi-bin/listinfo/otrshttp://lists.otrs.org/cgi-bin/listinfo/otrs>http://lists.otrs.org/cgi-bin/listinfo/otrs>http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => <<http://www.otrs.com/http://www.otrs.com/>http://www.otrs.com/>http://www.otrs.com/
-- Tim
-- Tim
-- Tim
participants (3)
-
Laurent Minost -
Rico Barth -
Tim Streater