en:user_advanced:greenstone_databases
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
en:user_advanced:greenstone_databases [2017/09/08 08:36] – created anupama | en:user_advanced:greenstone_databases [2023/03/13 01:46] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | |||
+ | |||
+ | |||
+ | ====== Information about the databases Greenstone uses ====== | ||
+ | |||
Greenstone comes with several database systems included: [[http:// | Greenstone comes with several database systems included: [[http:// | ||
Line 7: | Line 12: | ||
Note that Greenstone databases with gdb and jdb extensions are flat databases, not relational DBs. So that's Greenstone' | Note that Greenstone databases with gdb and jdb extensions are flat databases, not relational DBs. So that's Greenstone' | ||
- | === Using Squirrel SQL Client to manage Relational Databases === | + | ===== Using Squirrel SQL Client to manage Relational Databases |
- | If you wanted an application with a friendly interface to manage any relational databases that Greenstone creates, then try Squirrel SQL Client, which is for relational databases: | + | If you wanted an application with a friendly interface to manage any relational databases that Greenstone creates, then try Squirrel SQL Client, which is for relational databases. |
+ | |||
+ | The following instructions on using Squirrel SQL Client are written from a Unix perspective, | ||
1. Download the " | 1. Download the " | ||
+ | |||
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/ | 4. Copy derbyclient.jar from your Greenstone3/ | ||
- | 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' | 6. Use a text editor to open your GS3 installation' | ||
connectionURL=" | connectionURL=" | ||
+ | | ||
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: | ||
./ | ./ | ||
+ | | ||
8. Click on the " | 8. Click on the " | ||
+ | |||
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, | For further information on using Squirrel SQL, consult its documentation, | ||
+ | |||
+ | |||
+ | ==== Using Squirrel SQL Client to load a MySQL DB ==== | ||
+ | On Windows: | ||
+ | |||
+ | 1. Download JDBC driver for MySQL from https:// | ||
+ | * Under //Select Operating System//, choose //Platform Independent// | ||
+ | See https:// | ||
+ | |||
+ | 2. Unzip and copy the top level jar file, '' | ||
+ | |||
+ | 3. Follow the instructions at https:// | ||
+ | |||
+ | 4. Make sure to [[http:// | ||
+ | |||
+ | 5. Connect the Squirrel Client to it. https:// |
en/user_advanced/greenstone_databases.txt · Last modified: 2023/03/13 01:46 by 127.0.0.1