Re: [rt-users] Failed to load dashboard
Hi Christian, Thanks a lot, that solved my problem a lot easier than expected. Again thanks a lot. Cheers. On Wed, Sep 17, 2014 at 7:05 AM, Christian Loos cl...@netcologne.de wrote: Am 16.09.2014 um 18:56 schrieb Carlos Ramos: Hi Christian, This script is great, I was able to identify the users with a reference to that specific dashboard. But I could not find how this information is stored in the DB (my best guess is attributes.content which is binary) and I really don't know much about the RT API. Do you know if it's possible to remove theses invalid references directly in the database?, if not, how can I do so through the RT API? In the RT API there is a DeletePreferences in the RT::User class, but i don't see how I can delete a specific DashboardInMenu id from the preferences. Any ideas about this? Thanks a lot for the help. On the user modify page (Admin - Users) you can change a users Dashboards in menu preference. The right select box contains a row without a label for the deleted dashboard, select this row and hit Delete. Chris -- Carlos Ramos -- RT Training November 4 5 Los Angeles http://bestpractical.com/training
Re: [rt-users] Failed to load dashboard
Hi Christian, This script is great, I was able to identify the users with a reference to that specific dashboard. But I could not find how this information is stored in the DB (my best guess is attributes.content which is binary) and I really don't know much about the RT API. Do you know if it's possible to remove theses invalid references directly in the database?, if not, how can I do so through the RT API? In the RT API there is a DeletePreferences in the RT::User class, but i don't see how I can delete a specific DashboardInMenu id from the preferences. Any ideas about this? Thanks a lot for the help. On Tue, Sep 16, 2014 at 12:07 AM, Christian Loos cl...@netcologne.de wrote: Am 16.09.2014 um 05:13 schrieb Carlos Ramos: Hello, I'm getting the following warning on my Apache error log every time I load pretty much every RT page and I would like to get rid of it: [warning]: Failed to load dashboard 235: Failed to load dashboard 235: Couldn't find row (/opt/rt4/share/html/Elements/Tabs:497) I guess some dashboard was deleted and it's somehow still referenced but not showing up in the UI. ¿How can I manually delete this reference? Thanks. -- Carlos Ramos Attached a simple Perl script I use. The pod also notes the bug report for this. Chris -- Carlos Ramos -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Failed to load dashboard
Hello, I'm getting the following warning on my Apache error log every time I load pretty much every RT page and I would like to get rid of it: [warning]: Failed to load dashboard 235: Failed to load dashboard 235: Couldn't find row (/opt/rt4/share/html/Elements/Tabs:497) I guess some dashboard was deleted and it's somehow still referenced but not showing up in the UI. ¿How can I manually delete this reference? Thanks. -- Carlos Ramos -- RT Training - Boston, September 9-10 http://bestpractical.com/training
Re: [rt-users] RT 4.0.2 ExternalAuth and phpbb3
On Mon, Nov 14, 2011 at 3:27 AM, Adrian Stel adisa...@gmail.com wrote: Hi, I would like to use phpbb3 base to auth to my RT. Problem is here: SiteConfig.pm # The Perl package subroutine used to encrypt passwords # e.g. if the passwords are stored using the MySQL v3.23 PASSWORD # function, then you will need Crypt::MySQL::password, but for the # MySQL4+ password function you will need Crypt::MySQL::password41 # Alternatively, you could use Digest::MD5::md5_hex or any other # encryption subroutine you can load in your perl installation 'p_enc_pkg' = 'Crypt::MySQL', 'p_enc_sub' = 'password41', I'm not sure which function I should use. -- Best Adrian Stelmaszyk RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011 Assuming phpbb use this password library http://www.openwall.com/phpass/, as suggested in this post http://www.phpbb.com/community/viewtopic.php?f=71t=585387#p3225746. Then you could probably use that library's perl port available here http://search.cpan.org/~zefram/Authen-Passphrase/lib/Authen/Passphrase/PHPass.pm to authenticate your users. Otherwise I'm guessing you will have to port phpbb's hashing function to perl using the version that came with your phpbb as reference. Cheers. -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom search based on full months
I need this functionality too, and I'm planing to modify TimeParse in order to make it understand something like beginning of last month or end of last week, since as Ruslan suggested I think this would be the cleanest approach. But reading this thread, looks like I'm not the only one with this problem, so I'm forced to ask. Does anyone has a patch for TimeParse that will allow this functionality ? -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT 4.0.3 upgrade problem
On Wed, Nov 9, 2011 at 6:54 PM, Jeff Sampson ffe...@gmail.com wrote: Here are the RT related config sections.. VirtualHost *:80 Alias /rt /opt/rt4/share/html AddDefaultCharset UTF-8 Location /rt Order allow,deny allow from all SetHandler modperl PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /opt/rt4/sbin/rt-server /Location Perl use Plack::Handler::Apache2; Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server); /Perl /VirtualHost VirtualHost *:443 Alias /rt /opt/rt4/share/html AddDefaultCharset UTF-8 Location /rt Order allow,deny allow from all SetHandler modperl PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /opt/rt4/sbin/rt-server /Location Perl use Plack::Handler::Apache2; Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server); /Perl /VirtualHost RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain — November 28 29, 2011 I don't know if it's going to fix it, but the 'Alias /rt /opt/rt4/share/html' is not needed in this setup and it's probably conflicting with the 'Location /rt' section, so i would say get rid of it. http://httpd.apache.org/docs/2.2/mod/core.html#location -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Thu, Nov 3, 2011 at 8:55 AM, Kevin Falcone falc...@bestpractical.com wrote: On Thu, Nov 03, 2011 at 09:47:38AM +0100, Nehmer Torben wrote: we had the same problem here, disabling the GPG Stuff made the segfaults go away. Were you actually using gpg, or did you just have the perl modules installed and that was enough to cause segfaults? I have installed RT out of the box using Debian Packages which as far as I can see pulls all necessary dependencies into the system. RTs GPG configuration was on the defaults in RT_Config.pm, no changes are made by the deb. Once I disabled GPG as outlined in the docs (Enable = undef), the problem disappeared. So, is this a problem with the Debian packages, or do folks have source installs of 4.0.2 on Debian that are having segfaults? -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain — November 28 29, 2011 I have a source install myself on a Debian Squeeze system, not using the RT package that comes with Debian. And this is my GPG configuration on System Config: GnuPG { 'RejectOnBadData' = 1, 'Enable' = 0, 'RejectOnMissingPrivateKey' = 1, 'AllowEncryptDataInDB' = 0, 'OutgoingMessagesFormat' = 'RFC' } GnuPGOptions { 'homedir' = '/opt/rt4-pgsql/var/data/gpg' } I do have the gpg perl modules installed and I do have the gpg executable in my path: ~$ which gpg /usr/bin/gpg ~$ make testdeps ... GPG dependencies: PerlIO::eol ...found GnuPG::Interface ...found ... So again, I'm inclined to think that without the --enable-gpg configure flag, GPG is disabled by default. No more segmentation faults so far. Cheers. -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Wed, Nov 2, 2011 at 1:44 AM, Nehmer Torben torben.neh...@cancom.de wrote: Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Thanks a lot for the answer, this solves the problem. I just ran ./configure again without --enable-gpg and then make install. Since I'm not actually using GPG this will do it. As a side note the GPG modules are still installed on the system, so disabling the functionality in the configure script is enough to fix this issue. -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Wed, Nov 2, 2011 at 10:58 AM, Kevin Falcone falc...@bestpractical.com wrote: On Wed, Nov 02, 2011 at 10:13:40AM -0600, Carlos Ramos wrote: On Wed, Nov 2, 2011 at 1:44 AM, Nehmer Torben torben.neh...@cancom.de wrote: Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Thanks a lot for the answer, this solves the problem. I just ran ./configure again without --enable-gpg and then make install. Since I'm not actually using GPG this will do it. As a side note the GPG modules are still installed on the system, so disabling the functionality in the configure script is enough to fix this issue. Unless you added Enable = 0 to your config, I'm not entirely sure how that would fix it. By default, RT installs with it enabled and then disables it at runtime. Did you rerun with --disable-gpg or did you just leave off --enable-gpg -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain — November 28 29, 2011 This was the configure script I was using: ./configure --enable-graphviz --enable-gd --enable-gpg --with-web-user=www-data --with-web-group=www-data --with-db-type=Pg --with-web-handler=modperl2 All I did was change it to: ./configure --enable-graphviz --enable-gd --with-web-user=www-data --with-web-group=www-data --with-db-type=Pg --with-web-handler=modperl2 and the problem disappeared. As per the configure script help: --enable-gpgTurns on GNU Privacy Guard (GPG) support it does not look like it's on by default so by not providing --enable-gpg should turn gpg off. But if indeed is on by default and I have to use --disable-gpg to disable it, then I have no idea why the problem went away, maybe it will reappear later. I would hate that. -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
As a side note, I do have a working RT4 installation in debian squeeze, but this was installed some time ago and it was the rt-4.0.0 tarball and I guess some of the CPAN modules are older too. Just here to confirm that this only happens with the latest version, 4.0.2. However 4.0.0 and 4.0.1 work without a problem. So I'm sticking with those until this is fixed. I tried the three versions in the same server and the problem is only visible with 4.0.2. Cheers. RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Tue, Nov 1, 2011 at 12:46 PM, Alex Vandiver ale...@bestpractical.com wrote: On Tue, 2011-11-01 at 09:32 -0600, Carlos Ramos wrote: As a side note, I do have a working RT4 installation in debian squeeze, but this was installed some time ago and it was the rt-4.0.0 tarball and I guess some of the CPAN modules are older too. Just here to confirm that this only happens with the latest version, 4.0.2. However 4.0.0 and 4.0.1 work without a problem. So I'm sticking with those until this is fixed. I tried the three versions in the same server and the problem is only visible with 4.0.2. We've suggested SetHandler modperl rather than SetHandler perl-script (as you're using) since 4.0.1. Does changing that resolve the issue? - Alex Hi, while further testing, looks like 4.0.1 does show the same behavior. So 4.0.0 is the only RT4 that does not do this. Also tried with SetHandler modperl but no luck. Is there any other information or test that would help solve this issue?. Thanks a lot in advance for the great software. -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Tue, May 31, 2011 at 9:00 AM, Kevin Falcone falc...@bestpractical.com wrote: On Mon, May 30, 2011 at 12:09:11PM +0200, Robert Wysocki wrote: Hi guys, I've googled it, some people also have this problem, but no solutions were provided by anyone. The problem is: testrt:/opt/rt4/etc# apache2ctl restart /usr/sbin/apache2ctl: line 107: 11712 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t 2 /dev/null Syntax OK /usr/sbin/apache2ctl: line 107: 11715 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t Action 'restart' failed. The Apache error log may have more information. testrt:/opt/rt4/etc# /etc/init.d/apache2 reload Syntax OK /usr/sbin/apache2ctl: line 107: 11729 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t Action 'configtest' failed. The Apache error log may have more information. failed! The way of restarting apache which doesn't cause error to be thrown is just: /etc/init.d/apache2 stop; /etc/init.d/apache2 start but it's, well, inelegant. The issue is probably related to Plack. Unfortunately, it's difficult to try replicating without a perl/apache/mod_perl2/plack version list -kevin Hello, I'm having a VERY similar problem here. Using rt-4.0.2 and debian squeeze 6.0.3, which comes with apache 2.2.16-6+squeeze4, mod_perl 2.0.4-7, perl 5.10.1-17squeeze2 and from what i can tell Plack 0.9984 which i just installed from CPAN. This is my rt config in apache: Location /rt Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /opt/rt4/sbin/rt-server /Location Perl use Plack::Handler::Apache2; Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server); /Perl If I don't comment this Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server);, I can't do the following without getting a segmentation fault, even if apache is not running: root@blazar:~# export APACHE_RUN_USER=www-data root@blazar:~# export APACHE_RUN_GROUP=www-data root@blazar:~# export APACHE_PID_FILE=/var/run/apache2.pid root@blazar:~# export APACHE_RUN_DIR=/var/run/apache2 root@blazar:~# export APACHE_LOCK_DIR=/var/lock/apache2 root@blazar:~# export APACHE_LOG_DIR=/var/log/apache2 root@blazar:~# root@blazar:~# root@blazar:~# apache2 -t Syntax OK Segmentation fault That last sequence of commands is something that apache2ctl do almost every time you run it, and at least in Debian apache2ctl is used in a lot of places, from startup to shutdown to log rotation. RT4 works correctly from what i can tell as long as i don't comment the preload line, but then again apache2ctl breaks down and with it, other things follow. The only error i can see in my syslog every time i run 'apache -t' is the following: Oct 30 21:44:22 blazar kernel: [4016030.401140] apache2[17570]: segfault at 7fa814baa640 ip 7fa814baa640 sp 7d346fc8 error 14 in libnss_files-2.11.2.so[7fa817aaf000+b000] As a side note, I do have a working RT4 installation in debian squeeze, but this was installed some time ago and it was the rt-4.0.0 tarball and I guess some of the CPAN modules are older too. Any help would be really appreciated. Thanks a lot. RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011