Project

General

Profile

Edit History

Database Setup After Webserver initialization Shared » History » Version 1

Anchi Cheng, 03/04/2011 04:17 PM

1 1 Anchi Cheng 
h1. Additional Setup After Webserver initialization
2 





    3
    
    
    
If your webserver installation is successful, a number of tables will be propagated in the databases.  If you are using the more secured privilege settings we recommended in [[Database Server Installation]], you should expand the privileges of these three tables at this point:





    4
    
    
    





    5
    
    
    
<pre>





    6
    
    
    
GRANT DELETE ON leginondb.ViewerImageStatus TO usr_object@'localhost';





    7
    
    
    
GRANT DELETE ON leginondb.ImageStatusData TO usr_object@'localhost';





    8
    
    
    
GRANT DELETE ON projectdb.processingdb TO usr_object@'localhost';





    9
    
    
    
</pre>





    10
    
    
    





    11
    
    
    
If you use Leginon to do robotic grid screening, you will also need to do the following to grant delete privileges to the these tables at the mysql prompt:





    12
    
    
    
<pre>





    13
    
    
    
GRANT DELETE ON projectdb.gridboxes TO usr_object@'localhost';





    14
    
    
    
GRANT DELETE ON projectdb.grids TO usr_object@'localhost';





    15
    
    
    
GRANT DELETE ON projectdb.gridlocations TO usr_object@'localhost';





    16
    
    
    
</pre>