Re: [rt-users] Issues on RT 3.8.1

2008-09-15 Thread rmp dmd
Hi, still need help. The install of DBD:mysql just hang on t/75supported_sql...ok t/76multi_statement.ok 1/24 any ideas. Thanks! Roehl On Thu, Sep 11, 2008 at 10:45 AM, rmp dmd [EMAIL PROTECTED] wrote: Thanks for the help. I did create a testdb and grant ALL privileges to

Re: [rt-users] Issues on RT 3.8.1

2008-09-11 Thread Curtis Bruneau
Basically you need to make a database called 'test' which is somewhat standard for mysql installations, these scripts will run a series of tests like creating tables and trying different kinds of queries, it wouldn't be a good idea to try it on a production database. Make sure the user has

Re: [rt-users] Issues on RT 3.8.1

2008-09-11 Thread rmp dmd
Thanks for the help. I did create a testdb and grant ALL privileges to user. Run the make but still stock on t/55utf8ok t/60leaks...skipped all skipped: Skip $ENV{SLOW_TESTS} is not set t/65types...ok t/70takeimp.skipped

Re: [rt-users] Issues on RT 3.8.1

2008-09-09 Thread rmp dmd
Hi, Just want to follow-up on this. when I run #perl Makefile.PL --testuser=root --testpassword= #make #make test its getting error all skipped: ERROR: Unknown database 'test' Can't continue test t/20createdrop..skipped when I run #perl Makefile.PL --testuser=root

Re: [rt-users] Issues on RT 3.8.1

2008-08-29 Thread Sven Sternberger
just my 2c! On Do, 2008-08-28 at 18:45 -0700, Jesse Vincent wrote: How do I upgrade DBD::mysql to version 4.002? sudo cpan DBD::mysql but for a real world site it is not as simple as that, on RPM based system the package perl-DBD-mysql is often required by the mysql packages. So of

Re: [rt-users] Issues on RT 3.8.1

2008-08-29 Thread Jesse Vincent
So it would be nice if you consider the real world environments of the RT user out there. Unfortunately, we can't always keep our version requirements at those pre-packaged by every vendor. In this case, we're talking about a major new release that's over 18 months old that has features we

Re: [rt-users] Issues on RT 3.8.1

2008-08-29 Thread Tim Cutts
On 29 Aug 2008, at 7:59 am, Sven Sternberger wrote: but for a real world site it is not as simple as that, on RPM based system the package perl-DBD-mysql is often required by the mysql packages. So of course I can install the CPAN package over the rpm, but with the next update of the rpm

Re: [rt-users] Issues on RT 3.8.1

2008-08-29 Thread Shannon Adams
: Thursday, August 28, 2008 9:45:28 PM Subject: Re: [rt-users] Issues on RT 3.8.1 On Aug 28, 2008, at 6:43 PM, Shannon Adams wrote: Thanks, Drew. When I run: perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pw sql.queries I get: DBD::mysql version 4.002 required--this is only version 2.9007

Re: [rt-users] Issues on RT 3.8.1

2008-08-29 Thread rmp dmd
It seems that it creating new ~/.cpan/build/DBD-mysql-version everytime install DBD::mysql is run. The changes on Makefile.PL is overwritten. Any other way? On Thu, Aug 28, 2008 at 11:56 AM, David Svejda [EMAIL PROTECTED]wrote: rmp dmd wrote: Hi, Im getting errors when I run 'install

Re: [rt-users] Issues on RT 3.8.1

2008-08-29 Thread Ruslan Zakirov
On Fri, Aug 29, 2008 at 10:46 PM, rmp dmd [EMAIL PROTECTED] wrote: It seems that it creating new ~/.cpan/build/DBD-mysql-version everytime install DBD::mysql is run. The changes on Makefile.PL is overwritten. Any other way? cd ~/.cpan/build/DBD-mysql-version perl Makefile.PL ... make make test

Re: [rt-users] Issues on RT 3.8.1

2008-08-29 Thread rmp dmd
Thank you very much. Does this process take times? I run #perl Makefile.PL --testuser=root --testpassword= --testdb=rt3 #make #make test and its been on t/75supported_sql...ok t/76multi_statement.ok 1/24 for quite a while - Roehl On Fri, Aug 29, 2008 at 2:50 PM, Ruslan

[rt-users] Issues on RT 3.8.1

2008-08-28 Thread Shannon Adams
RT 3.8.1 mysql version - 4.1.20-log Fedora Core 4 SHOW CREATE TABLE sessions; shows:

Re: [rt-users] Issues on RT 3.8.1

2008-08-28 Thread rmp dmd
Hi, Im getting errors when I run 'install DBD::mysql'. Is there a way to put password when runinng 'install DBD::mysql'. Basically put this mysql -uroot -p t/10connect.skipped all skipped: ERROR: Access denied for user 'root'@'localhost' (using password: NO) Can't continue

Re: [rt-users] Issues on RT 3.8.1

2008-08-28 Thread David Svejda
rmp dmd wrote: Hi, Im getting errors when I run 'install DBD::mysql'. Is there a way to put password when runinng 'install DBD::mysql'. Basically put this mysql -uroot -p t/10connect.skipped all skipped: ERROR: Access denied for user 'root'@'localhost'

Re: [rt-users] Issues on RT 3.8.1

2008-08-28 Thread Shannon Adams
] Issues on RT 3.8.1 You missed a step. Per Ruslan yesterday: `a_session` column is longtext what is WRONG and means that you HAVN'T upgraded correctly. Read UPGRADING.mysql, this column must be LONGBLOB. Shannon Adams wrote: RT 3.8.1 mysql version - 4.1.20-log Fedora Core 4 SHOW CREATE

Re: [rt-users] Issues on RT 3.8.1

2008-08-28 Thread Jesse Vincent
, 2008 10:52:21 AM Subject: Re: [rt-users] Issues on RT 3.8.1 You missed a step. Per Ruslan yesterday: `a_session` column is longtext what is WRONG and means that you HAVN'T upgraded correctly. Read UPGRADING.mysql, this column must be LONGBLOB. Shannon Adams wrote: RT 3.8.1 mysql version

Re: [rt-users] Issues on RT 3.8.1

2008-08-27 Thread rmp dmd
Thanks for the reply Ruslan. I'm not that familiar with mysql but when I run SHOW CREATE TABLE sessions; I have this output which I believe does not indicate any corruption. How do I know if there is corruption RT3.8.1 is working fine only this weird occurence of asking to log-again after

Re: [rt-users] Issues on RT 3.8.1

2008-08-27 Thread Ruslan Zakirov
`a_session` column is longtext what is WRONG and means that you HAVN'T upgraded correctly. Read UPGRADING.mysql, this column must be LONGBLOB. On Wed, Aug 27, 2008 at 7:16 PM, rmp dmd [EMAIL PROTECTED] wrote: Thanks for the reply Ruslan. I'm not that familiar with mysql but when I run

Re: [rt-users] Issues on RT 3.8.1

2008-08-27 Thread rmp dmd
Thank you very for the help Ruslan. I'm running perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 user password sql.queries I'm getting DBD::mysql version 4.002 required--this is only version 3.0002 at etc/upgrade/schema.mysql-4.0-4.1.pl line 7. BEGIN failed--compilation aborted at

Re: [rt-users] Issues on RT 3.8.1

2008-08-27 Thread David Svejda
Upgrade your DBD::mysql module. The easiest way is using CPAN shell, so type this command: /usr/bin/perl -MCPAN -e shell and when in shell, type: upgrade DBD::mysql Regards Davdi rmp dmd wrote: Thank you very for the help Ruslan. I'm running perl etc/upgrade/schema.mysql-4.0-4.1.pl

Re: [rt-users] Issues on RT 3.8.1

2008-08-27 Thread rmp dmd
Thanks for the help David. Apologies for my simple questions as I do not have any knowledge on CPAN. I run below but upgrade is not an available command on CPAN shell. Error: Unknown command 'upgrade'. Type ? for help. What do I need to run to upgrade? Thanks! Roehl On Wed, Aug 27, 2008 at

Re: [rt-users] Issues on RT 3.8.1

2008-08-27 Thread David Svejda
rmp dmd wrote: Thanks for the help David. Apologies for my simple questions as I do not have any knowledge on CPAN. I run below but upgrade is not an available command on CPAN shell. Error: Unknown command 'upgrade'. Type ? for help. What do I need to run to upgrade? It seems you

Re: [rt-users] Issues on RT 3.8.1

2008-08-27 Thread Ruslan Zakirov
yep, but it's 'install DBD::mysql' On Wed, Aug 27, 2008 at 10:51 PM, David Svejda [EMAIL PROTECTED] wrote: rmp dmd wrote: Thanks for the help David. Apologies for my simple questions as I do not have any knowledge on CPAN. I run below but upgrade is not an available command on CPAN shell.

Re: [rt-users] Issues on RT 3.8.1

2008-08-27 Thread Ruslan Zakirov
once again, send us results of SHOW CREATE TABLE sessions; and SHOW CREATE TABLE Attachments; On Wed, Aug 27, 2008 at 6:23 AM, Ruslan Zakirov [EMAIL PROTECTED] wrote: send us results of SHOW CREATE TABLE sessions; On Wed, Aug 27, 2008 at 4:05 AM, Carlos A. Alvarez [EMAIL PROTECTED] wrote: I

[rt-users] Issues on RT 3.8.1

2008-08-26 Thread rmp dmd
Hi, First, I'd like to say great job on putting up an excellent documentation that is easy to follow for upgrading 3.8.1. I'm newbie RT user/admin but was able to do the updagrade easily. I just have few minor issues on 3.8.1. - On RT at Glance the link for Bookmarked Tickets, 10 highest

Re: [rt-users] Issues on RT 3.8.1

2008-08-26 Thread Rainer Duffner
Am 26.08.2008 um 17:15 schrieb rmp dmd: Hi, First, I'd like to say great job on putting up an excellent documentation that is easy to follow for upgrading 3.8.1. I'm newbie RT user/admin but was able to do the updagrade easily. I just have few minor issues on 3.8.1. - On RT at Glance

Re: [rt-users] Issues on RT 3.8.1

2008-08-26 Thread Brian Buchanan
On Tue, 2008-08-26 at 11:15 -0400, rmp dmd wrote: Hi, First, I'd like to say great job on putting up an excellent documentation that is easy to follow for upgrading 3.8.1. I'm newbie RT user/admin but was able to do the updagrade easily. I just have few minor issues on 3.8.1. -

Re: [rt-users] Issues on RT 3.8.1

2008-08-26 Thread rmp dmd
Thank you for all the replies. I will try later on adjusting the links. There are no logs from apache2/error.logs when click Home-Tickets-configuration but will ask me to log again. Here's the access.log 192.168.1.1 - - [26/Aug/2008:15:25:47 -0400] GET /rt/ HTTP/1.1 301 384

Re: [rt-users] Issues on RT 3.8.1

2008-08-26 Thread rmp dmd
Hi, The info provided helped in adjusting the link. However, it leads me to the same weird scenario again. When I'm in either Bookmarked Tickets, 10 highest priority tickets I own, 10 newest unowned tickets then click any of Home, Simple Search, Tickets, Tools, Configuration, Preferences,

Re: [rt-users] Issues on RT 3.8.1

2008-08-26 Thread Ruslan Zakirov
On Tue, Aug 26, 2008 at 7:15 PM, rmp dmd [EMAIL PROTECTED] wrote: Hi, First, I'd like to say great job on putting up an excellent documentation that is easy to follow for upgrading 3.8.1. I'm newbie RT user/admin but was able to do the updagrade easily. I just have few minor issues on

Re: [rt-users] Issues on RT 3.8.1

2008-08-26 Thread Ruslan Zakirov
In 75% of cases people need only: $WebDomain and $WebPath On Tue, Aug 26, 2008 at 10:28 PM, Brian Buchanan [EMAIL PROTECTED] wrote: On Tue, 2008-08-26 at 11:15 -0400, rmp dmd wrote: Hi, First, I'd like to say great job on putting up an excellent documentation that is easy to follow for

Re: [rt-users] Issues on RT 3.8.1

2008-08-26 Thread Don Beethe
Tried deleting everything in sessions table, since this is just a test server and still see the trouble. My RT_SiteConfig.pm: Set($rtname, 'NCS'); Set($Timezone, 'US/Mountain'); Set($LogToSyslog, ''); Set($LogToFile, 'info'); Set($LogToDir, '/opt/rt3/var/log'); Set( $WebDomain,

[rt-users] Issues on RT 3.8.1

2008-08-26 Thread Carlos A. Alvarez
I am also having the same Logout/Login issues as described above. The are no errors reported on the debug.log or the access/error logs. This only happened after I upgraded from 3.8.0 to 3.8.1. It seems as one changes links from Home to Simple Search or Tools, the application will log you

Re: [rt-users] Issues on RT 3.8.1

2008-08-26 Thread Ruslan Zakirov
send us results of SHOW CREATE TABLE sessions; On Wed, Aug 27, 2008 at 4:05 AM, Carlos A. Alvarez [EMAIL PROTECTED] wrote: I am also having the same Logout/Login issues as described above. The are no errors reported on the debug.log or the access/error logs. This only happened after I