Greenstone Wiki

User Tools

Site Tools

You are here: index » en » user_advanced » greenstone_databases
en:user_advanced:greenstone_databases

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
en:user_advanced:greenstone_databases [2017/09/08 08:37] – [Using Squirrel SQL Client to manage Relational Databases] anupamaen:user_advanced:greenstone_databases [2017/09/08 08:39] – [Using Squirrel SQL Client to manage Relational Databases] anupama
Line 13: Line 13:
  
 1. Download the "optional" (or "standard") zipped version from https://sourceforge.net/projects/squirrel-sql/files/1-stable/3.7.1-plainzip/ 1. Download the "optional" (or "standard") zipped version from https://sourceforge.net/projects/squirrel-sql/files/1-stable/3.7.1-plainzip/
 +
 2. Extract the zip 2. Extract the zip
 +
 3. Give execute permissions to the squirrel-sql.sh in the top level of the extracted folder: 3. Give execute permissions to the squirrel-sql.sh in the top level of the extracted folder:
     chmod u+x squirrel-sql.sh     chmod u+x squirrel-sql.sh
 +    
 4. Copy derbyclient.jar from your Greenstone3/web/WEB-INF/lib to your Squirrel SQL installation folder's lib subfolder. 4. Copy derbyclient.jar from your Greenstone3/web/WEB-INF/lib to your Squirrel SQL installation folder's lib subfolder.
  
-If you want to connect to the GS3 UserDB:+ 
 +//If you want to connect to the GS3 UserDB:// 
 5. Run the GS3 server, this runs the derby network server for the userDB 5. Run the GS3 server, this runs the derby network server for the userDB
 +
 6. Use a text editor to open your GS3 installation's packages/tomcat/conf/Catalina/localhost/greenstone3.xml file. Copy the line in there that looks like 6. Use a text editor to open your GS3 installation's packages/tomcat/conf/Catalina/localhost/greenstone3.xml file. Copy the line in there that looks like
     connectionURL="jdbc:derby://localhost:1527//.../web/etc/usersDB"     connectionURL="jdbc:derby://localhost:1527//.../web/etc/usersDB"
 +    
 7. Run the squirrel-sql application from a terminal where you've navigated into the Squirrel SQL installation folder: 7. Run the squirrel-sql application from a terminal where you've navigated into the Squirrel SQL installation folder:
     ./squirrel-sql.sh     ./squirrel-sql.sh
 +    
 8. Click on the "Drivers" tab, leftmost in the interface. (The word Drivers is vertically positioned) 8. Click on the "Drivers" tab, leftmost in the interface. (The word Drivers is vertically positioned)
 +
 9. Select Apache Derby Client and rightclick > Modify Driver. In the 2nd field, paste the text you copied in step 6 above. Then click OK to close the Modify Driver dialog. 9. Select Apache Derby Client and rightclick > Modify Driver. In the 2nd field, paste the text you copied in step 6 above. Then click OK to close the Modify Driver dialog.
 +
 10. Click the Aliases tab, again leftmost in the interface and above the Drivers tab. 10. Click the Aliases tab, again leftmost in the interface and above the Drivers tab.
 +
 11. Press the + button to add a new Alias. Give it a name like GSusersDB. Ensure that Apache Derby Client is the selected driver. Ensure the URL field contains what you pasted in step 9, else paste it here too. Click OK to finish the dialog. 11. Press the + button to add a new Alias. Give it a name like GSusersDB. Ensure that Apache Derby Client is the selected driver. Ensure the URL field contains what you pasted in step 9, else paste it here too. Click OK to finish the dialog.
 +
 12. A new Alias will have been created with the name you provided, e.g. GSusersDB. Select and rightclick on it > Connect. Type in your GS3 admin username and pwd. And press connect. It will load the contents of your DB. 12. A new Alias will have been created with the name you provided, e.g. GSusersDB. Select and rightclick on it > Connect. Type in your GS3 admin username and pwd. And press connect. It will load the contents of your DB.
 +
 For further information on using Squirrel SQL, consult its documentation, which can be found off http://squirrel-sql.sourceforge.net/. For further information on using Squirrel SQL, consult its documentation, which can be found off http://squirrel-sql.sourceforge.net/.
en/user_advanced/greenstone_databases.txt · Last modified: 2023/03/13 01:46 by 127.0.0.1