Installation question: DBD::mysql::db do failed: SESSION variable 'max_allowed_packet'

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Installation question: DBD::mysql::db do failed: SESSION variable 'max_allowed_packet'

Hadianto, Victor
Installation question: DBD::mysql::db do failed: SESSION variable 'max_allowed_packet'

Hi,

Trying to install CodeStriker, I've followed all the instructions and using the following: MySql + Apache on a workstation.

When I ran install.pl it throws me the following error:

C:\Program Files\codestriker\codestriker-1.9.8\bin>
C:\Program Files\codestriker\codestriker-1.9.8\bin>install.pl
Checking for  LWP::UserAgent (any)     ok: found v5.814
Checking for             CGI (v2.56)   ok: found v3.41
Checking for       Net::SMTP (any)     ok: found v2.31
Checking for MIME::QuotedPrint (v2.14)   ok: found v3.07
Checking for             DBI (v1.13)   ok: found v1.607
Checking for        Template (v2.07)   ok: found v2.20
Checking for  HTML::Entities (any)     ok: found v1.35
Checking for      File::Temp (any)     ok: found v0.18
Checking for        XML::RSS (v1.05)    ok: not found, optional
Checking for    Encode::Byte (any)     ok: found v2.03
Checking for Encode::Unicode (any)     ok: found v2.05
Checking for      DBD::mysql (any)     ok: found v4.005
DBD::mysql::db do failed: SESSION variable 'max_allowed_packet' is read-only. Us
e SET GLOBAL to assign the value at C:\Program Files\codestriker\codestriker-1.9
.8/lib/Codestriker/DB/MySQL.pm line 59.
DBD::mysql::db do failed: SESSION variable 'max_allowed_packet' is read-only. Us
e SET GLOBAL to assign the value at C:\Program Files\codestriker\codestriker-1.9
.8/lib/Codestriker/DB/MySQL.pm line 59.

C:\Program Files\codestriker\codestriker-1.9.8\bin>


As you can probably guess, my Perl knowledge is zero to none :) Can someone please let me know what goes wrong here?

Thanks,
Victor


==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================



------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com 
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Reply | Threaded
Open this post in threaded view
|

Re: Installation question: DBD::mysql::db do failed: SESSION variable 'max_allowed_packet'

David Sitsky
Administrator
Hi Victor,

Nice to hear from you. :)

> DBD::mysql::db do failed: SESSION variable 'max_allowed_packet' is
> read-only. Us
> e SET GLOBAL to assign the value at C:\Program
> Files\codestriker\codestriker-1.9
> .8/lib/Codestriker/DB/MySQL.pm line 59.

This is the "culprit" line in lib/Codestriker/DB/MySQL.pm:

    $dbh->do("SET max_allowed_packet=128000000");

Just comment it out or delete the line.  It seems the latest versions
of MySQL doesn't permit this setting anymore.  It is there to allow
large topic sizes to be stored in the database, but I believe it has
now been super-seeded by a global setting in the MySQL config file.

Cheers,
David

------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com 
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Reply | Threaded
Open this post in threaded view
|

Re: Installation question: DBD::mysql::db do failed: SESSION variable 'max_allowed_packet'

Hadianto, Victor
Hi David,

Yes finally using CodeStriker again after all this time :)

Thanks that works. I have to watch out for this maximum allowed packet
in MySQL then.

Cheers,
Victor

-----Original Message-----
From: David Sitsky [mailto:[hidden email]]
Sent: 26 May 2009 00:17
To: Hadianto, Victor
Cc: [hidden email]
Subject: Re: [Codestriker-user] Installation question: DBD::mysql::db do
failed: SESSION variable 'max_allowed_packet'

Hi Victor,

Nice to hear from you. :)

> DBD::mysql::db do failed: SESSION variable 'max_allowed_packet' is
> read-only. Us e SET GLOBAL to assign the value at C:\Program
> Files\codestriker\codestriker-1.9
> .8/lib/Codestriker/DB/MySQL.pm line 59.

This is the "culprit" line in lib/Codestriker/DB/MySQL.pm:

    $dbh->do("SET max_allowed_packet=128000000");

Just comment it out or delete the line.  It seems the latest versions of
MySQL doesn't permit this setting anymore.  It is there to allow large
topic sizes to be stored in the database, but I believe it has now been
super-seeded by a global setting in the MySQL config file.

Cheers,
David

===============================================================================
 Please access the attached hyperlink for an important electronic communications disclaimer:
 http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html 
 ===============================================================================
 

------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com 
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user