[Live-demo] [OSGeo] #969: mySQL and Ushahidi: db permission problems

[OSGeo]

#969: mySQL and Ushahidi: db permission problems
----------------------------------+-----------------------------------------
 Reporter:  hamish                |        Owner:  live-demo@…              
     Type:  defect                |       Status:  reopened                 
 Priority:  critical              |    Milestone:  OSGeoLive6.0RC1          
Component:  LiveDVD               |   Resolution:                           
 Keywords:  6.0, mysql, ushahidi  |  
----------------------------------+-----------------------------------------

Comment(by hamish):

 I've committed a script in app-conf/ushahidi/rc.go_mysql to run at boot
 time, to set the credentials and create the ushahidi db if needed. It
 would be better to get the diversions working in the chroot environment,
 but I fear we are too close to release to test that properly. Another idea
 promoted by kalxas would be to install mysql-server on the chroot's host
 (it's an identical platform on his build platform), but interactions and
 change targets are unknown without testing, which we don't really have
 time for.

 the /etc/rc2.d/S99rc.go_mysql startup script work around has been tested
 in test build r9066 and seems to work well for me. I've got concerns about
 the db setup being vulnerable to a race condition with mysql startup up
 just a few seconds before, but hopefully I built enough of a delay into it
 so that is rare, if at all.


  * summary: ushahidi is working on the iso now with an ugly work-around,
 problem was trying to run mysql in a chroot.


 Hamish

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/969#comment:27>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.