Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Open beta test of the new database

by Co-Rion (Monk)
on Sep 24, 2008 at 19:00 UTC ( #713488=monkdiscuss: print w/replies, xml ) Need Help??

After some trials and tribulations we're proud to announce the Beta Database. The database should be an exact copy of the production database running on a beefier machine.

Against the spirit of Google, beta means beta, and not "unsupported" or "don't sue us". It means that:

All changes on the Beta Database will be lost, as it is only temporary.

The database is a copy of PerlMonks as of the 24th of September. Please don't post real questions there and also don't post answers there. It will be wiped whenever a new copy of the real PerlMonks database is loaded into it.

As we're moving from MySQL 4 to MySQL 5, there are bound to be some queries and pages that don't work anymore. ambrus thankfully has already found two such instances (MySQL 5 is very picky about the order of implicit JOINs and LEFT JOINs). Please go there, check that everything is as you expect, and reply here with the pages you find that are not working.

The test program

For regression testing, I'm using the following program. It would be nice if your bug reports used a similar program to verify the bug or that the bug got fixed. Please also check that the bug does not also occur with the normal PerlMonks site :).

#!/opt/perl/bin/perl5.10.0 use strict; use Test::WWW::Mechanize; use Test::More; use vars qw($beta $production $login $pass); ($login,$pass) = @ARGV; my @tests = <DATA>; chomp @tests; plan tests => 4+ 2*@tests; my %mech = ( beta => { url => '', mech => Test::WWW::Mechanize->new(), }, production => { url => '', mech => Test::WWW::Mechanize->new(), }, ); for my $site (sort keys %mech) { my $m = $mech{$site}->{mech}; my $url = $mech{$site}->{url}; $m->get("${url}node=109"); $m->submit_form( with_fields => { user => $login, passwd => $pass, }, ); $m->content_like(qr!Hey\.\s*Glad you're back!i, "Logged in as '$lo +gin'") or $m->save_content(''); $m->content_unlike(qr!Oops!i, "Correct password") or $m->save_content(''); }; for my $url (@tests) { for my $site (sort keys %mech) { my $u = $mech{$site}->{url} . $url; my $m = $mech{$site}->{mech}; $m->get($u); $m->content_unlike( qr/Server Error\s*\(Error ID/, "[$site] No + error on $url" ); $m->save_content('log.html'); }; }; __DATA__ node=The+Monastery+Gates node=Message+Inbox node=Patch+lister node=Recently+Active+Threads;nnt-as-of=2008-08-21

Known bugs

  1. The linked /css/common.css is not found. This is because common.css does not live in the database and I don't want to mess with the global RewriteRules just for testing.
  2. The beta website isn't as responsive as it could be because it runs as a CGI instead of using mod_perl.
Thanks for helping us test,
Co-Rion for the gods

Update: Removed link to as Google found it and the script doesn't exist anymore.

Replies are listed 'Best First'.
Re: Open beta test of the new database
by hossman (Prior) on Sep 25, 2008 at 18:06 UTC

    Link to "The Monastery Gates" in upper right nav links results in 500 error. behavior is consistent when tested multiple times:

    Ditto for "PerlMonks Test Database" in the blue bar under the monk pictures:

Re: Open beta test of the new database
by Anonymous Monk on Sep 25, 2008 at 07:44 UTC
    My new user doesn't show up in NN or RAT (bogus email), neither can Anonymous Monk post to snippets (I knew I couldn't post reviews)

      New users only show up when they've confirmed their email address, this is identical to the production site, but understandably you didn't test that here.

      I'm not sure if Anonymous Monk can post to snippets here - I'll test that resp. check the code, thanks. I've just looked - Anonymous Monk isn't allowed to post snippets anymore, sorry.

        Thanks. It would be nice if he wasn't shown the form in that case (temptation).

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: monkdiscuss [id://713488]
Approved by kyle
Front-paged by Old_Gray_Bear
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2020-09-28 02:59 GMT
Find Nodes?
    Voting Booth?
    If at first I donít succeed, I Ö

    Results (143 votes). Check out past polls.