Project

General

Profile

Edit History

Database Setup After Webserver initialization Shared » History » Version 4

Amber Herold, 04/27/2011 02:36 PM

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





    3
    2
    Amber Herold
    
If your webserver installation is successful, a number of tables will be propagated in the databases. There were several options for setting up databse user privileges recommended in [[Database Server Installation]]. The following additional steps should be taken, depending on which option you previously used.





    4
    1
    Anchi Cheng
    





    5
    3
    Amber Herold
    
* *Option 1: More secure - Restrict Drop and Delete priviledges*





    6
    
    
    
 





    7
    2
    Amber Herold
    
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:





    8
    3
    Amber Herold
    
 





    9
    1
    Anchi Cheng
    
<pre>





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





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





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





    13
    
    
    
</pre>





    14
    
    
    
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:





    15
    
    
    
<pre>





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





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





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





    19
    
    
    
</pre>





    20
    2
    Amber Herold
    





    21
    3
    Amber Herold
    
* *Option 2: Less secure - Allow all privileges*





    22
    
    
    
&nbsp;





    23
    2
    Amber Herold
    
If you are allowing all privileges, no further steps need to be taken.





    24
    
    
    





    25
    3
    Amber Herold
    
* *Option 3: Allows access from all computers in the domain*





    26
    
    
    
&nbsp;





    27
    2
    Amber Herold
    
You may choose to assign a domain to your commands and use a wildcard to allow access from all computers in the domain.





    28
    3
    Amber Herold
    
&nbsp;





    29
    2
    Amber Herold
    
<pre>





    30
    
    
    
GRANT DELETE ON leginondb.ViewerImageStatus TO usr_object@'%.mydomain.edu';





    31
    
    
    
GRANT DELETE ON leginondb.ImageStatusData TO usr_object@'%.mydomain.edu';





    32
    
    
    
GRANT DELETE ON projectdb.processingdb TO usr_object@'%.mydomain.edu';





    33
    
    
    
</pre>





    34
    
    
    
Again, if you use Leginon to do robotic grid screening, you may want to grant delete privileges to the these tables at the mysql prompt:





    35
    
    
    
<pre>





    36
    
    
    
GRANT DELETE ON projectdb.gridboxes TO usr_object@'%.mydomain.edu';





    37
    
    
    
GRANT DELETE ON projectdb.grids TO usr_object@'%.mydomain.edu';





    38
    
    
    
GRANT DELETE ON projectdb.gridlocations TO usr_object@'%.mydomain.edu';





    39
    
    
    
</pre>