en:user_advanced:greenstonesqlplugs
Differences
This shows you the differences between two versions of the page.
en:user_advanced:greenstonesqlplugs [2019/06/07 09:59] – [The short version: Usage instructions] anupama | en:user_advanced:greenstonesqlplugs [2023/03/13 01:46] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | |||
+ | |||
+ | |||
====== Editing archives metadata and/or fulltext using a MySQL database ====== | ====== Editing archives metadata and/or fulltext using a MySQL database ====== | ||
Like the GreenstoneMETSPlugin, | Like the GreenstoneMETSPlugin, | ||
Line 7: | Line 10: | ||
**Important Notes:** | **Important Notes:** | ||
- | * None of this has been tested with Greenstone 2, only Greenstone 3. But it should in theory work with Greenstone 2 as well. Greenstone 2 users are invited to email the mailing list if there are any issues. UPDATE: Some testing for GS2 performed after fixing issues, as identified on mailing list. User seemed to succeed in using the GS SQL Plugs with an GS2 nightly binary. | + | * None of this has been tested with Greenstone 2, only Greenstone 3. But it should in theory work with Greenstone 2 as well. Greenstone 2 users are invited to email the mailing list if there are any issues. UPDATE: Some testing for GS2 performed after fixing issues, as identified on mailing list. User seemed to succeed in using the GS SQL Plugs with a GS2 nightly binary. |
* GreenstoneSQLPlugin and GreenstoneSQLPlugout rely on the **DBI** and DBD::mysql perl packages. | * GreenstoneSQLPlugin and GreenstoneSQLPlugout rely on the **DBI** and DBD::mysql perl packages. | ||
* We've so far tested the GreenstoneSQLPlugs on Ubuntu Linux, Windows 7 64 bit and MacOS v.10.13/ | * We've so far tested the GreenstoneSQLPlugs on Ubuntu Linux, Windows 7 64 bit and MacOS v.10.13/ | ||
Line 13: | Line 16: | ||
* For Windows binaries, we provide you with a Strawberry Perl that has the correct versions of DBI and DBD::mysql. If you're working with Greenstone source distributions or source code from svn on Windows, you can grab Strawberry Perl 5.22 [[http:// | * For Windows binaries, we provide you with a Strawberry Perl that has the correct versions of DBI and DBD::mysql. If you're working with Greenstone source distributions or source code from svn on Windows, you can grab Strawberry Perl 5.22 [[http:// | ||
* For newer versions of Mac, your pre-installed DBI package may be fine, but you may be missing DBD::mysql. Or perhaps you have an older version of DBD::mysql. In that case, refer to the Mac instructions at [[http:// | * For newer versions of Mac, your pre-installed DBI package may be fine, but you may be missing DBD::mysql. Or perhaps you have an older version of DBD::mysql. In that case, refer to the Mac instructions at [[http:// | ||
- | * **UPDATE:** If you're on Linux or on a Mac High Sierra machine, and you don't have DBI or DBD, also refer to the instructions at [[http:// | + | * **UPDATE:** If you're on Linux or on a Mac High Sierra machine, and you don't have DBI or DBD, also refer to the instructions at [[http:// |
You can check you have the DBI and DBD::mysql packages installed as part of your perl in whatever OS you're working on. To test you have DBI and DBD::mysql installed and also find their versions, run the following command in perl: | You can check you have the DBI and DBD::mysql packages installed as part of your perl in whatever OS you're working on. To test you have DBI and DBD::mysql installed and also find their versions, run the following command in perl: | ||
Line 67: | Line 70: | ||
* Once the collectionConfiguration.xml file has been correctly setup, you can run GLI, open the hand configured collection in there, and then run build in there.\\ Alternatively, | * Once the collectionConfiguration.xml file has been correctly setup, you can run GLI, open the hand configured collection in there, and then run build in there.\\ Alternatively, | ||
- | OR: incremental-import.pl -incremental | + | buildcol.pl -activate |
- | * I can't remember if these flags need to be passed in.</ | + | incremental-buildcol.pl -activate -site < |
* Start your GS3 server if you haven' | * Start your GS3 server if you haven' | ||
- | * You can now at any time [[# | + | * You can now at any time [[# |
* But **once you log into MySQL client, always first set the connection to use the '' | * But **once you log into MySQL client, always first set the connection to use the '' | ||
- | * The GreenstoneSQLPlugs create a **database** called ''< | + | * The GreenstoneSQLPlugs create a **database** called ''< |
* Up to 2 **tables** are created for each collection: ''< | * Up to 2 **tables** are created for each collection: ''< | ||
en/user_advanced/greenstonesqlplugs.txt · Last modified: 2023/03/13 01:46 by 127.0.0.1