Ldap Authentication setup question

RT Users
21

Have you done steps from UPGRADING.mysql?On Sat, Oct 25, 2008 at 12:08 AM, Kobus Bensch kbensch@fullnet.co.uk wrote:

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)

The rt-users Archives

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

The rt-users Archives

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 Kobus Bensch: kbensch@fullnet.co.uk

Information: info@fullnet.co.uk>

Sales Team: 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!”.

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!”.

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!”.

The rt-users Archives

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

Best regards, Ruslan.

22

No, because the previous server had the same version of MySQL as the new
one.

Ruslan Zakirov wrote:

Have you done steps from UPGRADING.mysql?

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)

The rt-users Archives

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

The rt-users Archives

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 Kobus Bensch: kbensch@fullnet.co.uk

Information: info@fullnet.co.uk>

Sales Team: 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!”.

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!”.

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!”.

The rt-users Archives

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)

23

You still must do that.On Sat, Oct 25, 2008 at 12:43 AM, Kobus Bensch kbensch@fullnet.co.uk wrote:

No, because the previous server had the same version of MySQL as the new
one.

Ruslan Zakirov wrote:

Have you done steps from UPGRADING.mysql?

On Sat, Oct 25, 2008 at 12:08 AM, Kobus Bensch kbensch@fullnet.co.uk wrote:

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)

The rt-users Archives

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

The rt-users Archives

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 Kobus Bensch: kbensch@fullnet.co.uk

Information: info@fullnet.co.uk>

Sales Team: 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!”.

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!”.

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!”.

The rt-users Archives

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 Kobus Bensch: kbensch@fullnet.co.uk

Information: info@fullnet.co.uk>

Sales Team: 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!”.

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!”.

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!”.

The rt-users Archives

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

Best regards, Ruslan.

24

Kobus Bensch wrote:

No, because the previous server had the same version of MySQL as the new
one.
you need to upgrade the mysql schema when upgrading rt from 3.6 to 3.8

Chaim Rieger

25

Yeah that’s strange, I had a similar issue where my fastcgi segfaulted
causing a permanent error state, which causes the process to keep
cycling filling up the log/hard drive. This would only happen in low
memory situations, yours seems to be somewhat driver/software related
where it keeps trying and just fills up the log.

Kobus Bensch wrote:

26

Hi

I have now run the actions for the upgrading rt and it still give me the
same error.

Kobus

Chaim Rieger wrote:

signature.asc (258 Bytes)

27

Kobus Bensch - No Sig wrote:

Hi

I have now run the actions for the upgrading rt and it still give me the
same error.

Kobus

stop and restart your web server
clear the mason cache

Chaim Rieger

28

Ok here is some more diags

I have deleted the database and recreated the database from the
installation instructions. I am still getting the same error.
In a browser it says 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.

This is the last few lines of the log says this:
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x2af2d455f180)’,
‘TimeEstimated’, ‘’, ‘Status’, ‘new’, ‘new-DependsOn’, ‘’, ‘Queue’,
‘General’, …) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1284
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘TimeEstimated’, ‘’, ‘Status’, ‘new’, ‘new-DependsOn’, ‘’, …) called
at /opt/rt3/share/html/autohandler line 308
HTML::Mason::Commands::ANON(‘TimeEstimated’, ‘’, ‘Status’,
‘new’, ‘new-DependsOn’, ‘’, ‘Queue’, ‘General’, ‘AdminCc’, …) 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(0x2af2d4188ed0)’,
‘TimeEstimated’, ‘’, ‘Status’, ‘new’, ‘new-DependsOn’, ‘’, ‘Queue’,
‘General’, …) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’,
‘TimeEstimated’, ‘’, ‘Status’, ‘new’, ‘new-DependsOn’, ‘’, …) called
at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {…} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 425

HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x2af2d44ad6d0)’)
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(0x2af2d44ad6d0)’)
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(0x2af2d10de3f0)’,
‘Apache2::RequestRec=SCALAR(0x2af2d430fa50)’) 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(0x2af2d430fa50)’)
called at -e line 0
eval {…} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Sun Oct 26 11:21:28 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)
[Sun Oct 26 11:21:28 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)

Please can someone help with this.

Thank you

Kobus

Ruslan Zakirov wrote:

kbensch.vcf (179 Bytes)

29

Michael Mollard wrote:

Mike,
Let me know when you’re up and about again. I’ve installed RT::Authen::ExternalAuth v.06_2 and now just logging in as local root generates this error.

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)

This generally means that the User_Vendor.pm has not been found in the
right place to make its methods available. UpdateFromExternal is an
RT::User method, RT looks in User.pm and doesn’t find it, ande then
checks for its existence in User_Local.pm and User_Vendor.pm. Obviously
it’s just not finding or is unable to read User_Vendor.pm.

File permissions perhaps?

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

30

Hello,

Ive been battling trying to get AD external Authentication going as
well. Im pretty new at RT also, but I have read over all the docs and
these posts several times trying to get it working. I am having the
exact same issue as Michael in this thread, and I haven’t been able to
resolve. Have either of you figured out a solution? When I got to my
servers URL I am presented with the normal login screen, but if I try to
login as root, I get this error:

RT::User::UpdateFromExternal Unimplemented in HTML::Mason::Commands.
(/opt/rt3/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAu
th/autohandler/Auth line 82)

If I refresh in the browser it then takes me to roots home screen and
everything functions as normal. I can logout and repeat, I have to
refresh once to get in. If I try to login as an AD user, I get this
error:

Can’t call method “Disabled” on an undefined value at
/opt/rt3/bin/…/lib/RT/User_Overlay.pm line 971.

I have drilled over my RT_SiteConfig.pm and compared it to the ones
posted on the lists. I turned on logging to file and it didn’t generate
anything I could see that was related. I checked file permissions on
the files listed below and they are OK.

Thanks in advance for all the great help.

SeanFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Mike
Peachey
Sent: Monday, October 27, 2008 2:55 AM
To: Michael Mollard; RT Users
Subject: Re: [rt-users] Ldap Authentication setup question

Michael Mollard wrote:

Mike,
Let me know when you’re up and about again. I’ve installed
RT::Authen::ExternalAuth v.06_2 and now just logging in as local root
generates this error.

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)

This generally means that the User_Vendor.pm has not been found in the
right place to make its methods available. UpdateFromExternal is an
RT::User method, RT looks in User.pm and doesn’t find it, ande then
checks for its existence in User_Local.pm and User_Vendor.pm. Obviously
it’s just not finding or is unable to read User_Vendor.pm.

File permissions perhaps?

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://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

31

Sean,
Identical to my error. I did find a ‘make fixperms’ which I stumbled
across, not documented anywhere I could find, alongside ‘make testdeps’,
and ‘make fixdeps’. But it didn’t change anything. Same errors.

If I ever get this going, I may need to write a wiki article for the
‘rest of us’ who are new at this. If I ever get it working :wink:

Keep in touch Sean, if I find anything I’ll let you know.

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

Sean McCreadie wrote:

32

Michael Mollard wrote:

Sean,
Identical to my error. I did find a ‘make fixperms’ which I stumbled
across, not documented anywhere I could find, alongside ‘make testdeps’,
and ‘make fixdeps’. But it didn’t change anything. Same errors.

If I ever get this going, I may need to write a wiki article for the
‘rest of us’ who are new at this. If I ever get it working :wink:

Keep in touch Sean, if I find anything I’ll let you know.

Be aware, this has been identified as a bug and we are working on it.

In the meantime, you can circumvent the problem by turning on Devel mode
if you need to.
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

33

Thanks Mike, nice to know I’m not going nuts. Can you give me a quick
pointer on turning on Devel mode.

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

Mike Peachey wrote:

34

Michael Mollard wrote:

Thanks Mike, nice to know I’m not going nuts. Can you give me a quick
pointer on turning on Devel mode.

I’ll give you a very small pointer:

$RTHOME/etc/RT_Config.pm

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

35

Mike Peachey wrote:

Michael Mollard wrote:

Sean,
Identical to my error. I did find a ‘make fixperms’ which I stumbled
across, not documented anywhere I could find, alongside ‘make testdeps’,
and ‘make fixdeps’. But it didn’t change anything. Same errors.

If I ever get this going, I may need to write a wiki article for the
‘rest of us’ who are new at this. If I ever get it working :wink:

Keep in touch Sean, if I find anything I’ll let you know.

Be aware, this has been identified as a bug and we are working on it.

In the meantime, you can circumvent the problem by turning on Devel mode
if you need to.

Update:

This issue is fixed in RT’s development trunk and will be covered by
RT-3.8.2, but we’re now testing a workaround patch to force ExternalAuth
to work around the bug and co-exist with RT-3.8.1.
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

36

RT::Authen::ExternalAuth v0.06_03 is now available and is the first (and
hopefully only) release candidate for v0.06.

Michael Mollard, Sean McCreadie,

Can you please test v0.06_03 as soon as possible and let me know how it
goes? Having tested myself, it seems good and I’d like to get 0.06 out
ASAP as it will be the first official release to support RT-3.8.x

Unfortunately, I’m still waiting for CPAN to update with the new
version, and when it does, it will be available here:
http://search.cpan.org/CPAN/authors/id/Z/ZO/ZORDRAK/RT-Authen-ExternalAuth-0.06_03.tar.gz

But if you’d like to try it now, you can get it from the BPS SVN server:

$ svn co http://code.bestpractical.com/bps-public/RT-Authen-ExternalAuth
$ cd RT-Authen-ExternalAuth
$ perl Makefile.PL
$ make
$ make install

and it will overwrite the previous version without conflict.

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

37

Mike,

I would like to report that v0.06_03 is working for my
RHEL5/RT-3.8.1/Sun Directory Server 6.3. I am seeing new information in
my RT log so I know the new version is indeed active.

[Fri Oct 31 10:17:36 2008] [error]: Working around bug in RT and
reloading RT::User
(/usr/local/rt381/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth:8)

For v0.06_03 to work, I have to put in “Set(
@Plugins,(qw(RT::Authen::ExternalAuth)));” into RT_SiteConfig.pm but
didn’t need this when running 0.05. I didn’t even know this option
before reading the posting from Michael Mollard. :slight_smile:

One little comment is that after checking out the source code from SVN,
I had to cd to “RT-Authen-ExternalAuth/trunk” instead.

Thanks for releasing this fix!

Alan

Mike Peachey wrote:

38

Alan Cheng wrote:

Mike,

I would like to report that v0.06_03 is working for my
RHEL5/RT-3.8.1/Sun Directory Server 6.3.

Fantastic!

I am seeing new information in
my RT log so I know the new version is indeed active.

[Fri Oct 31 10:17:36 2008] [error]: Working around bug in RT and
reloading RT::User
(/usr/local/rt381/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth:8)

Indeed. You can thank Kevin Falcone for that.

For v0.06_03 to work, I have to put in “Set(
@Plugins,(qw(RT::Authen::ExternalAuth)));” into RT_SiteConfig.pm but
didn’t need this when running 0.05. I didn’t even know this option
before reading the posting from Michael Mollard. :slight_smile:

Yeah, will make sure this is at least in the README before a stable
release (if Kevin hasn’t put it in already).

One little comment is that after checking out the source code from SVN,
I had to cd to “RT-Authen-ExternalAuth/trunk” instead.

My bad.

Thanks for releasing this fix!

Alan

Pleased to help :slight_smile: Thanks to Kevin for the majority of the work.

Come on then Michael… one more confirmed happy person and I’m releasing
it :slight_smile:
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

39

Mike,

I am downloading the new rev as we speak and will comment shortly.
Thank you very much for all your great help, I appreciate it very much.

SeanFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Mike
Peachey
Sent: Friday, October 31, 2008 7:35 AM
To: chenga@ias.edu
Cc: RT Users
Subject: Re: [rt-users] Ldap Authentication setup question

Alan Cheng wrote:

Mike,

I would like to report that v0.06_03 is working for my
RHEL5/RT-3.8.1/Sun Directory Server 6.3.

Fantastic!

I am seeing new information in
my RT log so I know the new version is indeed active.

[Fri Oct 31 10:17:36 2008] [error]: Working around bug in RT and
reloading RT::User

(/usr/local/rt381/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/Ex
ternalAuth/autohandler/Auth:8)

Indeed. You can thank Kevin Falcone for that.

For v0.06_03 to work, I have to put in “Set(
@Plugins,(qw(RT::Authen::ExternalAuth)));” into RT_SiteConfig.pm but
didn’t need this when running 0.05. I didn’t even know this option
before reading the posting from Michael Mollard. :slight_smile:

Yeah, will make sure this is at least in the README before a stable
release (if Kevin hasn’t put it in already).

One little comment is that after checking out the source code from
SVN,
I had to cd to “RT-Authen-ExternalAuth/trunk” instead.

My bad.

Thanks for releasing this fix!

Alan

Pleased to help :slight_smile: Thanks to Kevin for the majority of the work.

Come on then Michael… one more confirmed happy person and I’m releasing
it :slight_smile:
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://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