Wednesday Oct 28, 2009

SilverStripe Installation in OpenSolaris


SilverStripe is a open source content management system(CMS) to create and
maintain website, it is currently published to the OpenSolaris /contib repository.


Installation of SilverStripe on OpenSolaris is straightforward by simply clicking
the installation button on the silverstrip's 'install.php' page,
however, the installation didn't work complaining with mysql query
execution failed:

"[User Error]  Couldn't run query: SELECT `SiteTree_Live`.\*,
`GhostPage_Live`.\*, `ErrorPage_Live`.\*, `RedirectorPage_Live`.\*,
`VirtualPage_Live`.\*, `SiteTree_Live`.ID,
if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS
RecordClassName FROM `SiteTree_Live` LEFT JOIN `GhostPage_Live` ON
`GhostPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live`
ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN
`RedirectorPage_Live` ON `RedirectorPage_Live`.ID =
`SiteTree_Live`.ID LEFT JOIN `VirtualPage_Live` ON
`VirtualPage_Live`.ID = `SiteTree_Live`.ID WHERE
(`SiteTree_Live`.`ParentID` = 1 AND `SiteTree_Live`.ID != 1 AND
ShowInMenus = 1) ORDER BY Sort Lost connection to MySQL server during
query


Running the same query within the MySQL client get the error of MySQL server
crash:


ERROR 2013 (HY000): Lost connection to MySQL server during query


It was caused by MySQL's bug: #44538 , the same problem as Joomlar! with MySQL explained
clearly in Georg's blog. To solve this problem, I enabled the 64-bit MySQL service
on OpenSolaris:


svccfg -s mysql:version_51 setprop mysql/enable_64bit=true
svcadm refresh mysql:version_51
svcadm restart mysql:version_51


The SilverStripe installation succeed without the problem after using the
64-bit MySQL 5.1.

Friday Jan 16, 2009

Optimized MySQL Database Application Performance with Solaris Dynamic Tracing






Check the blueprint document on how to use DTrace integrated with MySQL <br/> to fetch useful information that can not be obtained by other

Check the blueprint document on how to use DTrace integrated with MySQL to fetch useful information that can not be obtained by other means:
here

About

luojiac

Search

Top Tags
Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today