Ldap Authentication setup question

Hi all,
I’m an RT newbie, so be gentle with me.

I have setup a functioning RT system (on SLES10sp2), and am trying to setup ldap authentication to our eDirectory (using LDAP) for automatic user authentication/creation. I have spent a week, I’ve googled, wiki’d, and searched the RT list archives. I keep coming back to the same few documents, and am having little luck. I know it’s my understanding of how RT fits together, and probably perl in general, but if someone could help me with this, I’d be very grateful.

I have installed the RT::Authen::ExternalAuth 0.5. This creates a <$RT_HOME>/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm
I have edited that file with the correct site-specific ldap stuff.

Now, what do I need to add to my <$RT_Home>/etc/RT_SiteConfig.pm to activate the LDAP stuff? Are there any other changes needed?

The wiki articles (http://wiki.bestpractical.com/view/ExternalAuth) are helpful to a point, but the Post-Install section (which is apparently the crux of the setup) is too vague for an RT newbie.

Any pointers would be much appreciated…

Kind regards,

Michael Mollard
Network Administrator
Moreton Bay College
mollardm@mbc.qld.edu.au
http://www.mbc.qld.edu.au
Ph: (Direct) 07 3907 5712 / (Mob) 0417 631 801
Fax: 07 3390 8919 ( http://www.mbc.qld.edu.au )

Disclaimer: Whilst every attempt has been made to ensure that material contained in this email is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes all responsibility for use of the material transmitted. This email is intended only for the use of the individual or entity names above and may contain information that is confidential and privileged. If you are not the intended recipient, please note that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone 07 3390 8555 and destroy the original message. The contents of this message are provided without responsibility in law for their accuracy or otherwise, and without assumption of a duty of care by the School.

Michael Mollard wrote:

Hi all,
I’m an RT newbie, so be gentle with me.

I have setup a functioning RT system (on SLES10sp2)

What version of RT?

I have installed the RT::Authen::ExternalAuth 0.5. This creates a <$RT_HOME>/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm
I have edited that file with the correct site-specific ldap stuff.

Now, what do I need to add to my <$RT_Home>/etc/RT_SiteConfig.pm to activate the LDAP stuff? Are there any other changes needed?

The file
$RTHOME/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm is not
part of the installation, it simply contains examples for you to paste
into your $RTHOME/etc/RT_SiteConfig.pm file.

You can alternatively choose to put a line in your RT_SiteConfig to
"include" the example file instead of just copying the lines out of it.

The wiki articles (http://wiki.bestpractical.com/view/ExternalAuth) are helpful to a point, but the Post-Install section (which is apparently the crux of the setup) is too vague for an RT newbie.

I’ve just read it again and the instructions seem fairly clear. If you
can advise what is confusing to you, perhaps we can make it better.

If you are using RT 3.8.x then I recommend using this ExternalAuth
0.06_002 instead of 0.05 as it is a pre-release candidate for RT3.8
compatibility. 0.05 was written before 3.8 came out and so requires
tweaking before it will work properly with 3.8 and later.

You can get it here:
http://www.cpan.org/authors/id/F/FA/FALCONE/RT-Authen-ExternalAuth-0.06_02.tar.gz

Kind Regards,

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com

Thanks for the assistance.
I have downloaded and installed the latest version of RT-Authen-ExternalAuth-0.06_02, with RT 3.8.1(latest)
I seem to have gotten a step further, but still have some issues.

When I try and authenticate with an ldap account, my browser reports:
“Can’t call method “Disabled” on an undefined value at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/local/lib/RT/User_Vendor.pm line 351, line 273.”

and my ./var/log/rt.log says:
[Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn’t, as you didn’t specify an object type and id (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/Record.pm:1439)
[Thu Oct 23 00:11:07 2008] [error]: Couldn’t get principal for not loaded object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm:1113)

It seems to be connectiong to my ldap, (which was more than it was doing) but fails soon after. Am I missing something?

Here is my RT_Siteconfig.pm

Set( $rtname, ‘mbc.qld.edu.au’);
Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘debug’);
Set($LogToFile , ‘debug’);
Set($LogDir, ‘var/log’);
Set($LogToFileNamed , “rt.log”); #log to rt.log

#Set(@Plugins,(qw(Extension::QuickDelete)));
Set( @Plugins, qw(RT::Authen::ExternalAuth) );
Set($ExternalAuthPriority, [ ‘My_LDAP’ ] );
Set($ExternalInfoPriority, [ ‘My_LDAP’ ] );
Set($ExternalServiceUsesSSLorTLS, 0);
Set($AutoCreateNonExternalUsers, 0);
Set($ExternalSettings, { ‘My_LDAP’ => {
‘type’ => ‘ldap’,
‘auth’ => 1,
‘info’ => 1,
‘server’ => ‘ldap.mbc.qld.edu.au’,
#‘user’ => ‘ldaphelpdesk’,
#‘pass’ => ‘rt_ldap_password’,
‘base’ => ‘ou=lab,o=mbc’,
‘filter’ => ‘(objectClass=inetOrgPerson)’,
#‘d_filter’ => ‘(FILTER_STRING)’,
‘tls’ => 0,
‘net_ldap_args’ => [ version => 3 ],
‘group’ => ‘cn=GRP_Staff,ou=lab,o=mbc’,
‘group_attr’ => ‘groupMembership’,
‘attr_match_list’ => [ ‘Name’,
‘EmailAddress’,
#‘RealName’,
#‘WorkPhone’,
#‘Address2’
],
‘attr_map’ => { ‘Name’ => ‘cn’,
‘EmailAddress’ => ‘mail’,
‘Organization’ => ‘l’,
‘RealName’ => ‘cn’,
#‘ExternalAuthId’ => ‘sAMAccountName’,
#‘Gecos’ => ‘sAMAccountName’,
‘WorkPhone’ => ‘telephoneNumber’,
‘Address1’ => ‘streetAddress’,
‘City’ => ‘l’,
‘State’ => ‘st’,
‘Zip’ => ‘postalCode’,
‘Country’ => ‘co’
}
}
}
);
1;

Thanks.
Michael.

Michael Mollard
Network Administrator
Moreton Bay College
mollardm@mbc.qld.edu.au
http://www.mbc.qld.edu.au
Ph: (Direct) 07 3907 5712 / (Mob) 0417 631 801
Fax: 07 3390 8919 ( http://www.mbc.qld.edu.au )

Mike Peachey mike.peachey@jennic.com 23/10/2008 12:43 am >>>
Michael Mollard wrote:
Hi all,
I’m an RT newbie, so be gentle with me.

I have setup a functioning RT system (on SLES10sp2)

What version of RT?

I have installed the RT::Authen::ExternalAuth 0.5. This creates a <$RT_HOME>/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm
I have edited that file with the correct site-specific ldap stuff.

Now, what do I need to add to my <$RT_Home>/etc/RT_SiteConfig.pm to activate the LDAP stuff? Are there any other changes needed?

The file
$RTHOME/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm is not
part of the installation, it simply contains examples for you to paste
into your $RTHOME/etc/RT_SiteConfig.pm file.

You can alternatively choose to put a line in your RT_SiteConfig to
"include" the example file instead of just copying the lines out of it.

The wiki articles (http://wiki.bestpractical.com/view/ExternalAuth) are helpful to a point, but the Post-Install section (which is apparently the crux of the setup) is too vague for an RT newbie.

I’ve just read it again and the instructions seem fairly clear. If you
can advise what is confusing to you, perhaps we can make it better.

If you are using RT 3.8.x then I recommend using this ExternalAuth
0.06_002 instead of 0.05 as it is a pre-release candidate for RT3.8
compatibility. 0.05 was written before 3.8 came out and so requires
tweaking before it will work properly with 3.8 and later.

You can get it here:
http://www.cpan.org/authors/id/F/FA/FALCONE/RT-Authen-ExternalAuth-0.06_02.tar.gz

Kind Regards,

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com

Disclaimer: Whilst every attempt has been made to ensure that material contained in this email is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes all responsibility for use of the material transmitted. This email is intended only for the use of the individual or entity names above and may contain information that is confidential and privileged. If you are not the intended recipient, please note that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone 07 3390 8555 and destroy the original message. The contents of this message are provided without responsibility in law for their accuracy or otherwise, and without assumption of a duty of care by the School.

Thanks for the assistance.
I have downloaded and installed the latest version of RT-Authen-
ExternalAuth-0.06_02, with RT 3.8.1(latest)
I seem to have gotten a step further, but still have some issues.

When I try and authenticate with an ldap account, my browser reports:
“Can’t call method “Disabled” on an undefined value at /srv/www/
vhosts/rt.mbc.qld.edu.au/bin/…/local/lib/RT/User_Vendor.pm line
351, line 273.”

I assume you previously installed 0.05?
You should go delete /srv/www/vhosts/rt.mbc.qld.au/local/lib/RT/
User_vendor.pm and RT/Authen/ExternalAuth.pm

0.05 had a bug where .pm files were being double installed

0.06_02 contains a patch for this bug

-kevin

This sounds like you need the User_Vendor patch… I know it’s been known to work with earlier versions of the ExternalAuth, but is it still needed for the newest version?

http://www.gossamer-threads.com/lists/rt/users/77139?search_string=ldap%

I imagine Mike will be back with words of advice, but may as well make a backup and give this a shot.

EliasFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Michael Mollard
Sent: Wednesday, October 22, 2008 4:10 PM
To: mike.peachey@jennic.com; RT Users
Subject: Re: [rt-users] Ldap Authentication setup question

Thanks for the assistance.
I have downloaded and installed the latest version of RT-Authen-ExternalAuth-0.06_02, with RT 3.8.1(latest)
I seem to have gotten a step further, but still have some issues.

When I try and authenticate with an ldap account, my browser reports:
“Can’t call method “Disabled” on an undefined value at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/local/lib/RT/User_Vendor.pm line 351, line 273.”

and my ./var/log/rt.log says:
[Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn’t, as you didn’t specify an object type and id (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/Record.pm:1439)
[Thu Oct 23 00:11:07 2008] [error]: Couldn’t get principal for not loaded object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm:1113)

It seems to be connectiong to my ldap, (which was more than it was doing) but fails soon after. Am I missing something?

Here is my RT_Siteconfig.pm

Set( $rtname, ‘mbc.qld.edu.au’);
Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘debug’);
Set($LogToFile , ‘debug’);
Set($LogDir, ‘var/log’);
Set($LogToFileNamed , “rt.log”); #log to rt.log

#Set(@Plugins,(qw(Extension::QuickDelete)));
Set( @Plugins, qw(RT::Authen::ExternalAuth) );
Set($ExternalAuthPriority, [ ‘My_LDAP’ ] );
Set($ExternalInfoPriority, [ ‘My_LDAP’ ] );
Set($ExternalServiceUsesSSLorTLS, 0);
Set($AutoCreateNonExternalUsers, 0);
Set($ExternalSettings, { ‘My_LDAP’ => {
‘type’ => ‘ldap’,
‘auth’ => 1,
‘info’ => 1,
‘server’ => ‘ldap.mbc.qld.edu.au’,
#‘user’ => ‘ldaphelpdesk’,
#‘pass’ => ‘rt_ldap_password’,
‘base’ => ‘ou=lab,o=mbc’,
‘filter’ => ‘(objectClass=inetOrgPerson)’,
#‘d_filter’ => ‘(FILTER_STRING)’,
‘tls’ => 0,
‘net_ldap_args’ => [ version => 3 ],
‘group’ => ‘cn=GRP_Staff,ou=lab,o=mbc’,
‘group_attr’ => ‘groupMembership’,
‘attr_match_list’ => [ ‘Name’,
‘EmailAddress’,
#‘RealName’,
#‘WorkPhone’,
#‘Address2’
],
‘attr_map’ => { ‘Name’ => ‘cn’,
‘EmailAddress’ => ‘mail’,
‘Organization’ => ‘l’,
‘RealName’ => ‘cn’,
#‘ExternalAuthId’ => ‘sAMAccountName’,
#‘Gecos’ => ‘sAMAccountName’,
‘WorkPhone’ => ‘telephoneNumber’,
‘Address1’ => ‘streetAddress’,
‘City’ => ‘l’,
‘State’ => ‘st’,
‘Zip’ => ‘postalCode’,
‘Country’ => ‘co’
}
}
}
);
1;

Thanks.
Michael.

Michael Mollard
Network Administrator
Moreton Bay College
mollardm@mbc.qld.edu.au
http://www.mbc.qld.edu.au
Ph: (Direct) 07 3907 5712 / (Mob) 0417 631 801
Fax: 07 3390 8919 ( http://www.mbc.qld.edu.au )

Mike Peachey mike.peachey@jennic.com 23/10/2008 12:43 am >>>
Michael Mollard wrote:
Hi all,
I’m an RT newbie, so be gentle with me.

I have setup a functioning RT system (on SLES10sp2)

What version of RT?

I have installed the RT::Authen::ExternalAuth 0.5. This creates a <$RT_HOME>/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm
I have edited that file with the correct site-specific ldap stuff.

Now, what do I need to add to my <$RT_Home>/etc/RT_SiteConfig.pm to activate the LDAP stuff? Are there any other changes needed?

The file
$RTHOME/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm is not
part of the installation, it simply contains examples for you to paste
into your $RTHOME/etc/RT_SiteConfig.pm file.

You can alternatively choose to put a line in your RT_SiteConfig to
"include" the example file instead of just copying the lines out of it.

The wiki articles (http://wiki.bestpractical.com/view/ExternalAuth) are helpful to a point, but the Post-Install section (which is apparently the crux of the setup) is too vague for an RT newbie.

I’ve just read it again and the instructions seem fairly clear. If you
can advise what is confusing to you, perhaps we can make it better.

If you are using RT 3.8.x then I recommend using this ExternalAuth
0.06_002 instead of 0.05 as it is a pre-release candidate for RT3.8
compatibility. 0.05 was written before 3.8 came out and so requires
tweaking before it will work properly with 3.8 and later.

You can get it here:
http://www.cpan.org/authors/id/F/FA/FALCONE/RT-Authen-ExternalAuth-0.06_02.tar.gz

Kind Regards,

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com

Disclaimer: Whilst every attempt has been made to ensure that material contained in this email is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes all responsibility for use of the material transmitted. This email is intended only for the use of the individual or entity names above and may contain information that is confidential and privileged. If you are not the intended recipient, please note that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone 07 3390 8555 and destroy the original message. The contents of this message are provided without responsibility in law for their accuracy or otherwise, and without assumption of a duty of care by the School.
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

This sounds like you need the User_Vendor patch… I know it’s been
known to work with earlier versions of the ExternalAuth, but is it
still needed for the newest version?

http://www.gossamer-threads.com/lists/rt/users/77139?search_string=ldap%

I imagine Mike will be back with words of advice, but may as well
make a backup and give this a shot.

For the archives:

This patch has been applied to 0.06_02 but if you have an old version
laying around
in local/ you may need to delete it.

I’m checking in an update to the README which will be in the next
release

-kevin

Before I installed v .06 I ‘rm-Rf /srv/www/vhosts/rt.mbc.qld.edu.au/local/plugins/RT-Authen-ExternalAuth’, then did a full install of the module.

But just to be certain, I removed the 2 files you mentioned, and then did a complete re-install of the RT-Authen-ExternalAuth module.

Same error in rt.log file.
Same error in browser, except different line number:
Can’t call method “Disabled” on an undefined value at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm line 971.

Thanks for all the prompt assistance.

Michael.

Michael Mollard
Network Administrator
Moreton Bay College
mollardm@mbc.qld.edu.au
http://www.mbc.qld.edu.au
Ph: (Direct) 07 3907 5712 / (Mob) 0417 631 801
Fax: 07 3390 8919 ( http://www.mbc.qld.edu.au )

Kevin Falcone falcone@bestpractical.com 23/10/2008 9:46 am >>>

Thanks for the assistance.
I have downloaded and installed the latest version of RT-Authen-
ExternalAuth-0.06_02, with RT 3.8.1(latest)
I seem to have gotten a step further, but still have some issues.

When I try and authenticate with an ldap account, my browser reports:
“Can’t call method “Disabled” on an undefined value at /srv/www/
vhosts/rt.mbc.qld.edu.au/bin/…/local/lib/RT/User_Vendor.pm line
351, line 273.”

I assume you previously installed 0.05?
You should go delete /srv/www/vhosts/rt.mbc.qld.au/local/lib/RT/
User_vendor.pm and RT/Authen/ExternalAuth.pm

0.05 had a bug where .pm files were being double installed

0.06_02 contains a patch for this bug

-kevin

and my ./var/log/rt.log says:
[Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn’t,
as you didn’t specify an object type and id (/srv/www/vhosts/
rt.mbc.qld.edu.au/bin/../lib/RT/Record.pm:1439)
[Thu Oct 23 00:11:07 2008] [error]: Couldn’t get principal for not
loaded object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/
User_Overlay.pm:1113)

It seems to be connectiong to my ldap, (which was more than it was
doing) but fails soon after. Am I missing something?

Here is my RT_Siteconfig.pm

Set( $rtname, ‘mbc.qld.edu.au’);
Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘debug’);
Set($LogToFile , ‘debug’);
Set($LogDir, ‘var/log’);
Set($LogToFileNamed , “rt.log”); #log to rt.log

#Set(@Plugins,(qw(Extension::QuickDelete)));
Set( @Plugins, qw(RT::Authen::ExternalAuth) );
Set($ExternalAuthPriority, [ ‘My_LDAP’ ] );
Set($ExternalInfoPriority, [ ‘My_LDAP’ ] );
Set($ExternalServiceUsesSSLorTLS, 0);
Set($AutoCreateNonExternalUsers, 0);
Set($ExternalSettings, { ‘My_LDAP’ => {

‘type’ => ‘ldap’,

‘auth’ => 1,

‘info’ => 1,

‘server’ => ‘ldap.mbc.qld.edu.au’,

#‘user’ => ‘ldaphelpdesk’,

#‘pass’ => ‘rt_ldap_password’,

‘base’ => ‘ou=lab,o=mbc’,

‘filter’ => ‘(objectClass=inetOrgPerson)’,

#‘d_filter’ => ‘(FILTER_STRING)’,

‘tls’ => 0,

‘net_ldap_args’ => [ version => 3 ],

‘group’ => ‘cn=GRP_Staff,ou=lab,o=mbc’,

‘group_attr’ => ‘groupMembership’,

‘attr_match_list’ => [ ‘Name’,
‘EmailAddress
’,
#‘RealName
’,
#‘WorkPhone
’,
#‘Address2

],

‘attr_map’ => { ‘Name’ => ‘cn’,
‘EmailAddress
’ => ‘mail’,
‘Organization
’ => ‘l’,
‘RealName
’ => ‘cn’,
#‘ExternalAuthId
’ => ‘sAMAccountName’,
#‘Gecos
’ => ‘sAMAccountName’,
‘WorkPhone
’ => ‘telephoneNumber’,
‘Address1
’ => ‘streetAddress’,
‘City
’ => ‘l’,
‘State
’ => ‘st’,
‘Zip
’ => ‘postalCode’,
‘Country
’ => ‘co’
}
}
}
);
1;

Thanks.
Michael.

Michael Mollard
Network Administrator
Moreton Bay College
mollardm@mbc.qld.edu.au
http://www.mbc.qld.edu.au
Ph: (Direct) 07 3907 5712 / (Mob) 0417 631 801
Fax: 07 3390 8919 ( http://www.mbc.qld.edu.au )

Mike Peachey mike.peachey@jennic.com 23/10/2008 12:43 am >>>
Michael Mollard wrote:
Hi all,
I’m an RT newbie, so be gentle with me.

I have setup a functioning RT system (on SLES10sp2)

What version of RT?

I have installed the RT::Authen::ExternalAuth 0.5. This creates a <
$RT_HOME>/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm
I have edited that file with the correct site-specific ldap stuff.

Now, what do I need to add to my <$RT_Home>/etc/RT_SiteConfig.pm to
activate the LDAP stuff? Are there any other changes needed?

The file
$RTHOME/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm is
not
part of the installation, it simply contains examples for you to paste
into your $RTHOME/etc/RT_SiteConfig.pm file.

You can alternatively choose to put a line in your RT_SiteConfig to
"include" the example file instead of just copying the lines out of
it.

The wiki articles (http://wiki.bestpractical.com/view/ExternalAuth)
are helpful to a point, but the Post-Install section (which is
apparently the crux of the setup) is too vague for an RT newbie.

I’ve just read it again and the instructions seem fairly clear. If you
can advise what is confusing to you, perhaps we can make it better.

If you are using RT 3.8.x then I recommend using this ExternalAuth
0.06_002 instead of 0.05 as it is a pre-release candidate for RT3.8
compatibility. 0.05 was written before 3.8 came out and so requires
tweaking before it will work properly with 3.8 and later.

You can get it here:
http://www.cpan.org/authors/id/F/FA/FALCONE/RT-Authen-ExternalAuth-0.06_02.tar.gz


Kind Regards,


Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com



Disclaimer: Whilst every attempt has been made to ensure that
material contained in this email is free from computer viruses or
other defects, the attached files are provided, and may only be
used, on the basis that the user assumes all responsibility for use
of the material transmitted. This email is intended only for the use
of the individual or entity names above and may contain information
that is confidential and privileged. If you are not the intended
recipient, please note that any dissemination, distribution or
copying of this email is strictly prohibited. If you have received
this email in error, please notify us immediately by return email or
telephone 07 3390 8555 and destroy the original message. The
contents of this message are provided without responsibility in law
for their accuracy or otherwise, and without assumption of a duty of
care by the School.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Disclaimer: Whilst every attempt has been made to ensure that material contained in this email is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes all responsibility for use of the material transmitted. This email is intended only for the use of the individual or entity names above and may contain information that is confidential and privileged. If you are not the intended recipient, please note that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone 07 3390 8555 and destroy the original message. The contents of this message are provided without responsibility in law for their accuracy or otherwise, and without assumption of a duty of care by the School.

Before I installed v .06 I ‘rm-Rf /srv/www/vhosts/rt.mbc.qld.edu.au/
local/plugins/RT-Authen-ExternalAuth’, then did a full install of
the module.
But just to be certain, I removed the 2 files you mentioned, and
then did a complete re-install of the RT-Authen-ExternalAuth module.

The bug was it installed into plugins AND local rather than just
plugins/

Same error in rt.log file.
Same error in browser, except different line number:
Can’t call method “Disabled” on an undefined value at /srv/www/
vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm line 971.

That is new and exciting.
Try turning on LogStackTraces in your config so we can see what is
calling IsPassword
incorrectly.

-kevin

Mike,
As part of my troubleshooting process, I have tried to wipe my rt installation and restart (I’m testing on a local VM, so not a big deal).
I have deleted my <$RT_HOME> (/srv/www/vhosts/rt.mbc.qld.edu.au/*). Is that enough to reinstall from scratch or are there other things which should be ‘tidied up’?

My Reinstall Process:
-installed rt3.8.1 as per instructions
-make initialize-database
-restarted apache2

(tested login as root/password, all works ok)

-Installed RT-Authen-ExternalAuth-0.06_02
-restarted apache
(left my RT_SiteConfig.pm unmodified to test ‘local only’ root/password again - still works fine)
Modified my RT_SiteConif.pm file with :

Set( @Plugins,(qw(RT::Authen::ExternalAuth)));

Set($ExternalAuthPriority, [ ‘My_LDAP’ ] );
Set($ExternalInfoPriority, [ ‘My_LDAP’ ] );
Set($ExternalServiceUsesSSLorTLS, 0);
Set($AutoCreateNonExternalUsers, 0);
Set($ExternalSettings, { ‘My_LDAP’ => {
‘type’ => ‘ldap’,
‘auth’ => 1,
‘info’ => 1,
‘server’ => ‘ldap.mbc.qld.edu.au’,
#‘user’ => ‘cn=ldaphelpdesk,ou=ldap,ou=lab,o=mbc’,
#‘pass’ => ‘’,
‘base’ => ‘ou=lab,o=mbc’,
‘filter’ => ‘(objectClass=Person)’,
#‘d_filter’ => ‘(FILTER_STRING)’,
‘tls’ => 0,
‘net_ldap_args’ => [ version => 3 ],
‘group’ => ‘cn=GRP_Staff,ou=lab,o=mbc’,
‘group_attr’ => ‘groupMembership’,
‘attr_match_list’ => [ ‘Name’,
‘EmailAddress’
],
‘attr_map’ => { ‘Name’ => ‘cn’,
‘EmailAddress’ => ‘mail’,
‘Organization’ => ‘l’,
‘RealName’ => ‘cn’,
‘ExternalAuthId’ => ‘cn’,
#‘Gecos’ => ‘sAMAccountName’,
‘WorkPhone’ => ‘telephoneNumber’,
‘Address1’ => ‘streetAddress’,
‘City’ => ‘l’,
‘State’ => ‘st’,
‘Zip’ => ‘postalCode’,
‘Country’ => ‘co’
}
}
}
);

-restarted apache
-tested root/password (which should work as a local account)
I get this error in the browser:
RT::User::UpdateFromExternal Unimplemented in HTML::Mason::Commands. (/srv/www/vhosts/rt.mbc.qld.edu.au/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth line 73)

If I go to http://rt.mbc.qld.edu.au (my default rt home), I go straight to the dashboard, already logged in as root.

If I logout and try and login as a valid ldap user (bogust/bogust - see log below) I get this error in the browser:
Can’t call method “Disabled” on an undefined value at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm line 971.
(If I go to http://rt.mbc.qld.edu.au ( http://rt.mbc.qld.edu.au/ ) (my default rt home), I get the login screen)

This is my rt.log:
Trace begun at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT.pm line 289
Log::Dispatch::ANON(‘Log::Dispatch=HASH(0x8244f698)’, ‘Transaction->Create couldn’t, as you didn’t specify an object type and id’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/Record.pm line 1439
RT::Record::_NewTransaction(‘RT::User=HASH(0x825b74ac)’, ‘Type’, ‘Set’, ‘Field’, ‘Name’, ‘NewValue’, ‘bogust’, ‘OldValue’, undef, ‘TimeTaken’, undef) called at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm line 1496
RT::User::_Set(‘RT::User=HASH(0x825b74ac)’, ‘Field’, ‘Name’, ‘Value’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 440
DBIx::SearchBuilder::Record::ANON(‘RT::User=HASH(0x825b74ac)’, ‘bogust’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth line 32
HTML::Mason::Commands::ANON(‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x825b7608)’, ‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279
eval {…} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, ‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/Interface/Web/Request.pm line 176
RT::Interface::Web::Request::callback(‘RT::Interface::Web::Request=HASH(0x824a971c)’, ‘pass’, ‘bogust’, ‘user’, ‘bogust’, ‘CallbackName’, ‘Auth’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/share/html/autohandler line 253
HTML::Mason::Commands::ANON(‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x815f3550)’, ‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279
eval {…} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, ‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {…} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {…} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 425
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x824a971c)’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0x824a971c)’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x80b26370)’, ‘Apache2::RequestRec=SCALAR(0x80fc77d4)’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/webmux.pl line 148
eval {…} at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/webmux.pl line 148
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x80fc77d4)’) called at -e line 0
eval {…} at -e line 0
[Thu Oct 23 06:12:34 2008] [error]: Couldn’t get principal for not loaded object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm:1113)
Trace begun at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT.pm line 289
Log::Dispatch::ANON(‘Log::Dispatch=HASH(0x8244f698)’, ‘Couldn’t get principal for not loaded object’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm line 1113
RT::User::PrincipalObj(‘RT::User=HASH(0x825b74ac)’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/User_Overlay.pm line 971
RT::User::IsPassword(‘RT::User=HASH(0x825b74ac)’, ‘bogust’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth line 35
HTML::Mason::Commands::ANON(‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x825b7608)’, ‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279
eval {…} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, ‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/Interface/Web/Request.pm line 176
RT::Interface::Web::Request::callback(‘RT::Interface::Web::Request=HASH(0x824a971c)’, ‘pass’, ‘bogust’, ‘user’, ‘bogust’, ‘CallbackName’, ‘Auth’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/share/html/autohandler line 253
HTML::Mason::Commands::ANON(‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x815f3550)’, ‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279
eval {…} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, ‘pass’, ‘bogust’, ‘user’, ‘bogust’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {…} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {…} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 425
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x824a971c)’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0x824a971c)’) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x80b26370)’, ‘Apache2::RequestRec=SCALAR(0x80fc77d4)’) called at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/webmux.pl line 148
eval {…} at /srv/www/vhosts/rt.mbc.qld.edu.au/bin/webmux.pl line 148
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x80fc77d4)’) called at -e line 0
eval {…} at -e line 0
[Thu Oct 23 06:12:55 2008] [debug]: RT’s GnuPG libraries couldn’t successfully read your configured GnuPG home directory (/srv/www/vhosts/rt.mbc.qld.edu.au/var/data/gpg). PGP support has been disabled (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/…/lib/RT/Config.pm:276)

I was wondering if it is something I have done (can’t figure out what that could be), or if the ‘pre-release’ 0.06.02 code has a bug.

I really do appreciate your time on this …

Kind regards,
Michael.

Michael Mollard
Network Administrator
Moreton Bay College

mollardm@mbc.qld.edu.au
http://www.mbc.qld.edu.au ( http://www.mbc.qld.edu.au/ )
Ph: (Direct) 07 3907 5712 / (Mob) 0417 631 801
Fax: 07 3390 8919 ( http://www.mbc.qld.edu.au/ )

Mike Peachey mike.peachey@jennic.com 23/10/2008 12:43 am >>>
Michael Mollard wrote:
Hi all,
I’m an RT newbie, so be gentle with me.

I have setup a functioning RT system (on SLES10sp2)

What version of RT?

I have installed the RT::Authen::ExternalAuth 0.5. This creates a <$RT_HOME>/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm
I have edited that file with the correct site-specific ldap stuff.

Now, what do I need to add to my <$RT_Home>/etc/RT_SiteConfig.pm to activate the LDAP stuff? Are there any other changes needed?

The file
$RTHOME/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm is not
part of the installation, it simply contains examples for you to paste
into your $RTHOME/etc/RT_SiteConfig.pm file.

You can alternatively choose to put a line in your RT_SiteConfig to
"include" the example file instead of just copying the lines out of it.

The wiki articles (http://wiki.bestpractical.com/view/ExternalAuth) are helpful to a point, but the Post-Install section (which is apparently the crux of the setup) is too vague for an RT newbie.

I’ve just read it again and the instructions seem fairly clear. If you
can advise what is confusing to you, perhaps we can make it better.

If you are using RT 3.8.x then I recommend using this ExternalAuth
0.06_002 instead of 0.05 as it is a pre-release candidate for RT3.8
compatibility. 0.05 was written before 3.8 came out and so requires
tweaking before it will work properly with 3.8 and later.

You can get it here:
http://www.cpan.org/authors/id/F/FA/FALCONE/RT-Authen-ExternalAuth-0.06_02.tar.gz

Kind Regards,

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com

Disclaimer: Whilst every attempt has been made to ensure that material contained in this email is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes all responsibility for use of the material transmitted. This email is intended only for the use of the individual or entity names above and may contain information that is confidential and privileged. If you are not the intended recipient, please note that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone 07 3390 8555 and destroy the original message. The contents of this message are provided without responsibility in law for their accuracy or otherwise, and without assumption of a duty of care by the School.

Michael Mollard wrote:

I’m sorry I’m not concentrating on replies at the moment, but I’m trying
to recover from being hit from behind at about 50mph on my way home from
work on Monday.

One thing I can tell you is this:

You MUST* specify a d_filter!

When I get a chance I will try to update the wiki to make this more
clear, but I cannot state it clearly enough, if you don’t specify a
d_filter, ExternalAuth will probably not work at all.
Kind Regards,

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com

Michael Mollard wrote:

Mike,
RE: the wiki 'PostInstall’
although I have progressed slightly, I think I didn’t realise that I needed to put
Set( @Plugins,(qw(RT::Authen::ExternalAuth)));

I will add this when I can, this was not required for 3.6 installs.

Kind Regards,

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com

So I have just gotten this working with RHEL5, RT-3.8.1,
ExternalAuth-0.06_02 and eDIR.

A few things i had to hack:
/opt/rt3/local/lib/RT/User_Vendor.pm
Change line 1050 from:
$msg = $ldap->bind($ldap_user, password => $ldap_pass);
to:
$msg = $ldap->bind($ldap_user, ); #This fixed the Novell null
password idiocy

I also had to import or eDIR CA (not sure this is really needed)
certutil -A -d /etc/pki/nssdb -n “root ca cert” -t “CT,C,C” -i
~/eDirCACert.pem
My Netware Admin exported this for me from Console1; Security -->
Organizational CA

Modify /etc/openldap/ldap.conf to use the CA too
[root@tickets-dev:~]# cat /etc/openldap/ldap.conf

LDAP Defaults

See ldap.conf(5) for details

This file should be world readable but not world writable.

#BASE dc=example, dc=com
#URI ldap://ldap.example.com ldap://ldap-master.example.com:666

#SIZELIMIT 12
#TIMELIMIT 15
#DEREF never

TLS_CACERT /etc/pki/tls/certs/eDirCACert.pem

Self signed server cert (nothing to do with eDir)

TLS_CERT /etc/pki/tls/certs/server.crt
TLS_KEY /etc/pki/tls/private/server.key

I had to use the short name of the eDir server as its Certificate was
not FQDN (stupid!)
I also did not define d_filter but plan too just my Netware Admin is in
training.

                       'base'                      =>  'o=ggu',
                       'filter'                    =>  

‘(objectClass=Person)’,
‘d_filter’ => ‘’,
‘tls’ => 1,

Hope this is useful for anybody trying to get this to work with eDir.

Mike Peachey wrote:

Michael Mollard wrote:

Mike,
RE: the wiki 'PostInstall’
although I have progressed slightly, I think I didn’t realise that I needed to put
Set( @Plugins,(qw(RT::Authen::ExternalAuth)));

I will add this when I can, this was not required for 3.6 installs.

John McCoy, Jr
Sr. Systems and Network Administrator
Enterprise Technology Services
Golden Gate University

Hi

Please can someone help.

Fresh install of os and rt and i get this error which ends of with the
ticket email sent but no ticket created and my RT is currently not
working. I have downloaded all the email archives and found other people
with the same error but no real solution.

Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.

Thanks for any help

Kobus

There is a lot more to this log entry, I just could not include it all
here.
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x2b99543613e0)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168

HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0x2b99543613e0)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825

HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)’,
‘Apache2::RequestRec=SCALAR(0x2b995437e480)’) called at
/opt/rt3/bin/webmux.pl line 148
eval {…} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x2b995437e480)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)

signature.asc (258 Bytes)

Please explain in detail what problem you are experiencing. Are you having problems installing RT and running it for the first time? Can you not access RT at all through a browser?-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kobus Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at

Hi

Please can someone help.

Fresh install of os and rt and i get this error which ends of with the ticket email sent but no ticket created and my RT is currently not working. I have downloaded all the email archives and found other people with the same error but no real solution.

Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.

Thanks for any help

Kobus

There is a lot more to this log entry, I just could not include it all here.
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x2b99543613e0)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168

HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0x2b99543613e0)’)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825

HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)’,
‘Apache2::RequestRec=SCALAR(0x2b995437e480)’) called at /opt/rt3/bin/webmux.pl line 148
eval {…} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x2b995437e480)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)

Hi

I am able to access the server, I am able to login, and in some cases
even able to brwose normally.

The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.

Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.

Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.

Last error I sometimes just get blank pages.

Thanks for the help

Kobus

Eli Altman wrote:

Kobus Bensch wrote:

Hi

Please can someone help.

Fresh install of os and rt and i get this error which ends of with the
ticket email sent but no ticket created and my RT is currently not
working. I have downloaded all the email archives and found other people
with the same error but no real solution.

Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.

Thanks for any help

Kobus

try (re)installing DBD::mysql

Chaim Rieger

Sounds like the oom-killer is getting mysql. How much memory is on your
db server? Is it configured in such a way that when the innodb pool is
full it’s not running out of memory? You shouldn’t really have an issue
with this unless you have a large amount of tickets. Might want to check
some of your other logs and see what’s occurring. Apache/mod_perl can be
quite memory intensive at times depending how many children are setup,
it will slowly grow.

Kobus Bensch - No Sig wrote:

Hi

2GB on rt/db server.

I will have to look at the innodb settings, not changed these before so
will have to dig around.

Ticket volume is very low. Around 20 max a day.

I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.

Thanks for the help.

kobus

Curtis Bruneau wrote:

Anything in the mysql logs ?

away at

Hi

2GB on rt/db server.

I will have to look at the innodb settings, not changed these before so
will have to dig around.

Ticket volume is very low. Around 20 max a day.

I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.

Thanks for the help.

kobus

Curtis Bruneau wrote:

Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it’s not running out of memory? You shouldn’t really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what’s occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.

Kobus Bensch - No Sig wrote:

Hi

I am able to access the server, I am able to login, and in some cases
even able to brwose normally.

The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.

Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.

Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.

Last error I sometimes just get blank pages.

Thanks for the help

Kobus

Eli Altman wrote:

Please explain in detail what problem you are experiencing. Are you
having problems installing RT and running it for the first time?
Can you not access RT at all through a browser?

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kobus
Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
gone away at

Hi

Please can someone help.

Fresh install of os and rt and i get this error which ends of with
the ticket email sent but no ticket created and my RT is currently
not working. I have downloaded all the email archives and found
other people with the same error but no real solution.

Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.

Thanks for any help

Kobus

There is a lot more to this log entry, I just could not include it
all here.
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x2b99543613e0)’)

called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168

HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0x2b99543613e0)’)

called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825

HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)’,

‘Apache2::RequestRec=SCALAR(0x2b995437e480)’) called at
/opt/rt3/bin/webmux.pl line 148
eval {…} called at /opt/rt3/bin/webmux.pl line 148

RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x2b995437e480)’)
called at -e line 0
eval {…} called at -e line 0
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

No nothing in the mysql log.

I juast had to restart the server and i sent one ticket via email and it
generated a 122mb log file.

There is something really wrong here and I dont know what and why.

I had RT running on a server with i386 acrch and version 3.6.5.

I then moved it all to a new server and x64 arch and 3.8.1 and now I get
all of these errors.

chaim.rieger@gmail.com wrote:

Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile

-----Original Message-----
From: Kobus Bensch - No Sig kbensch@fullnet.co.uk

Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneaucurtisb@vianet.ca
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
away at

Hi

2GB on rt/db server.

I will have to look at the innodb settings, not changed these before so
will have to dig around.

Ticket volume is very low. Around 20 max a day.

I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.

Thanks for the help.

kobus

Curtis Bruneau wrote:

Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it’s not running out of memory? You shouldn’t really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what’s occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.

Kobus Bensch - No Sig wrote:

Hi

I am able to access the server, I am able to login, and in some cases
even able to brwose normally.

The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.

Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.

Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.

Last error I sometimes just get blank pages.

Thanks for the help

Kobus

Eli Altman wrote:

Please explain in detail what problem you are experiencing. Are you
having problems installing RT and running it for the first time?
Can you not access RT at all through a browser?

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kobus
Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
gone away at

Hi

Please can someone help.

Fresh install of os and rt and i get this error which ends of with
the ticket email sent but no ticket created and my RT is currently
not working. I have downloaded all the email archives and found
other people with the same error but no real solution.

Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.

Thanks for any help

Kobus

There is a lot more to this log entry, I just could not include it
all here.
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x2b99543613e0)’)

called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168

HTML::Mason::Request::ApacheHandler::exec(‘RT::Interface::Web::Request=HASH(0x2b99543613e0)’)

called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825

HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)’,

‘Apache2::RequestRec=SCALAR(0x2b995437e480)’) called at
/opt/rt3/bin/webmux.pl line 148
eval {…} called at /opt/rt3/bin/webmux.pl line 148

RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x2b995437e480)’)
called at -e line 0
eval {…} called at -e line 0
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

7 Marlborough Close

Maidenhead
Berkshire
SL6 4LP
United Kingdom

Telephone: +44 (01628) 675 978
Facsimile: +44 (07092) 289 990
Mobile Phone: +44 (07703) 503 733
Skype ID: fullnetsolutionsltd skype:fullnetsolutionsltd?call Kobus
Bensch: kbensch@fullnet.co.uk mailto:kbensch@fullnet.co.uk

Information: info@fullnet.co.uk> mailto:info@fullnet.co.uk

Sales Team: fslsales@fullnet.co.uk mailto:fslsales@fullnet.co.uk

WWW: http://www.fullnet.co.uk

Registered in England & Wales, Company Number 3568937

VAT registration number: UK 714 7309 42

E & O.E. All prices exclude VAT & Carriage unless otherwise specified.

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system administrator by emailing admin@fullnet.co.uk with the subject
"eMail Confidentiality Query!"
mailto:admin@fullnet.co.uk?subject=eMail%20Confidentiality%20Query!.

The content of this email does not necessarily reflect the views or
opinions of Fullnet Solutions Limited. If you have any queries or
complaints please email info@fullnet.co.uk with the subject "eMail
Comment/Complaint Query!"
mailto:info@fullnet.co.uk?subject=eMail%20Comment/Complaint%20Query!.

This footnote also confirms that this email message has been scanned for
the presence of computer viruses. Fullnet Solutions Limited can however
not be held responsible for any virus infections on the recipients or
any other systems. For more information regarding the solutions Fullnet
has to offer please email sales@fullnet.co.uk with the subject “Sales
Query!” mailto:fslsales@fullnet.co.uk?subject=Sales%20Query!.

signature.asc (258 Bytes)