[rt-users] Problems after Postgresql -> MySQL move

[Jesse Vincent]

On Fri, Oct 29, 2004 at 02:16:29PM +0100, Tim Bishop wrote:
> I moved from Postgresql to MySQL yesterday, which appeared to have
> worked. But this morning I noticed problems with users being
> auto-created.
> 
> I'm using MySQL 4.1.7 with RT 3.0.12. I gave RT 3.2.2 a quick go, but it
> didn't help, so I've stuck with 3.0.12 so I don't have other problems to
> deal with at the same time.

Why don't you back down to MySQL 4.0.x.  4.1.7 was just declared stable
by mysql inc and hasn't had that much field testng.


> This is what I'm getting in my webserver logs:
> 
> DBD::mysql::st execute failed: Unknown MySQL error at /usr/local/packages/perl-5.8.5/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 481.
> DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/packages/perl-5.8.5/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 981.
> DBD::mysql::st execute failed: Unknown MySQL error at /usr/local/packages/perl-5.8.5/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 481.
> DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/packages/perl-5.8.5/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 981.  
> 
> And in my RT logs:
> 
> [Fri Oct 29 13:04:08 2004] [debug]: Guessed encoding: ascii (/usr/local/packages/rt-3.0.12/lib/RT/I18N.pm:357)
> [Fri Oct 29 13:04:08 2004] [debug]: Guessed encoding: ascii (/usr/local/packages/rt-3.0.12/lib/RT/I18N.pm:357)
> [Fri Oct 29 13:04:08 2004] [debug]: Converting 'ascii' to 'utf-8' for text/plain - testing (/usr/local/packages/rt-3.0.12/lib/RT/I18N.pm:200)
> [Fri Oct 29 13:04:08 2004] [err]: Couldn't load  from the users database.  (/usr/local/packages/rt-3.0.12/lib/RT/CurrentUser.pm:111)
> [Fri Oct 29 13:04:08 2004] [crit]: User creation failed in mailgateway: No permission to create users (/usr/local/packages/rt-3.0.12/lib/RT/Interface/Email.pm:224)
> [Fri Oct 29 13:04:09 2004] [warning]: Couldn't load user 'tim.bishop at gmail.com'.giving up (/usr/local/packages/rt-3.0.12/lib/RT/Interface/Email.pm:239)
> [Fri Oct 29 13:04:09 2004] [crit]: User  'tim.bishop at gmail.com' could not be loaded in the mail gateway (/usr/local/packages/rt-3.0.12/lib/RT/Interface/Email.pm:240)
> [Fri Oct 29 13:04:09 2004] [error]: RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for this email (tim.bishop at gmail.com).
> 
> You might need to grant 'Everyone' the right 'CreateTicket' for the
> queue cs-syshelp.
> 
>  (/usr/local/packages/rt-3.0.12/lib/RT/Interface/Email.pm:552)
> [Fri Oct 29 13:04:09 2004] [error]: RT could not load a valid user, and RT's configuration does not allow for the creation of a new user for your email.
> 
>  (/usr/local/packages/rt-3.0.12/lib/RT/Interface/Email.pm:565)
> 
> I definately have CreateTicket permissions set for Everyone - I even
> took it off and put it back for good measure. This configuration also
> used to work prior to the Postgresql to MySQL move.
> 
> I'm pretty stuck now... I've checked everything I can check such as the
> database permissions, and I'm not sure what else there is I can do.
> 
> There's no errors in the MySQL logs either, for what it's worth,
> despsite the messages above.
> 
> Cheers,
> Tim.
> 
> -- 
> Tim Bishop
> http://www.bishnet.net/tim
> PGP Key: 0x5AE7D984
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
> 

--