Table of Contents
Troubleshooting
Random Magic Spells
Checking for Errors
Troubleshooting
Random Magic Spells
Table of Contents
Troubleshooting: Random Magic Spells
Check Evergreen version via srfsh
Check Evergreen version via http
Unable to login through the web interface or staff client after a successful install? Try Dan Scott's tip for resetting your password
See long-running database queries
Find unicode characters in a file
Stored procedures to find and eliminate bad (truncated) UTF-8 characters in postgres
Quick way to audit in-db circ rules for a particular org unit
Cancel Query/Report
List Reporter Folders with Bad Sharing Depths
Listing users with permissions by work_ou
Comparing permissions between multiple permission groups
Comparing permissions between multiple permission groups (variant: uses complete permission list)
Finding mis-matched depths with org units and org unit types
Checking Circ/Hold Flags on an Item
Where is my workstation registration ws_info file?
Performance
Preload Your database into RAM
Utility
Regularly Scheduled Report Output Purging
Use srfsh to search the OPAC
Copying permissions from one group to another
Transcoding a flat file from MARC8 to UTF-8
Magical command line for creating loader SQL
Dan Scott asked for a web service that can turn MARC into XML ... well, here it is
How to turn the freshmeat (new bib) feed into a JSPAC result page
Perl URL Encode & Decode String
Bib-work
Get MARC field for a record
How to generate metarecords for a newly loaded bib batch
How to include a specific MARC field with a specific search class.
Sync the 001 field of your serials records to the linked bibliographic record ID
How to prune a tag under the hood
Reingesting Bib and Authority Records (2.0 and later)
Find missing or mismatched 901$c
Generating a SQL report with natural titles
Statistics
To find the worst queries for the day, in the logger Pg logs
Generate counts for normalized query strings from activity.log
Example of generating monthly search counts from the activity log
Counting number of copies held by a library by LC call number range
Counting titles that match a list of ISBNs owned by a given library
Show statistic usage on reports
Development
Generating the release ChangeLog from Git
Flags to use for custom builds of postgres
Custom Dojo Build
Creating a Custom Build
URL Format for "browse indexes"
I18N build spell
SQL Tips & Tricks
SQL for System Administrators
Using SQL to Generate SQL
Using LIMIT to check your results
Listing disabled triggers
Getting a hierarchically-ordered list of org units
Cstore/json_query tips and tricks
order_by using expressions
EG Behavior
Override Receipt Templates Globally
Clear the added content cache (book covers, etc) from the command line
Clear cached catalog search results
Clear cached catalog search results for a single term
Checking for Errors
Table of Contents
Troubleshooting: Checking for Errors
Step 1: Stop all the OpenSRF services, as well as Apache
Stopping Apache
Stopping OpenSRF
Step 2: Delete or archive the existing log files
Step 3: Check that jabber and memcached are running
Step 4: Change the Log Levels in your config files
Step 5: Start the OpenSRF router and check for errors
Step 6: Start the OpenSRF perl services and check for errors
Step 7: Start the OpenSRF C services and check for errors
Step 8: Smoke test with autogen.sh
Step 9: Try to authenticate with the srfsh command-line OpenSRF client
Step 10: Start Apache and check for errors
Step 11: Try to authenticate with the staff client
Step 12: Try to authenticate with the OPAC
Bonus Step: Checking Ejabberd Account Credentials