en:user_advanced:greenstone_databases
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
en:user_advanced:greenstone_databases [2017/09/08 08:37] – [Using Squirrel SQL Client to manage Relational Databases] anupama | en:user_advanced:greenstone_databases [2018/11/28 06:45] – [Using Squirrel SQL Client to manage Relational Databases] anupama | ||
---|---|---|---|
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 9: | ||
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. | ||
Line 13: | Line 15: | ||
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. Remember to [[http:// | ||
+ | |||
+ | |||
+ | 2. https:// |
en/user_advanced/greenstone_databases.txt · Last modified: 2023/03/13 01:46 by 127.0.0.1