Q. I am not able to import facilities in the same manner that is demonstrated on the website, Manage_facility.pl --insert (file).csv produces line error 193. More specifically “can’t call method prepare on an undefined value at c:\shakecast\sc\bin\manage_facility.pl line 193.”
A. One likely possibility is that the header line includes fields not part of the table scheme.
Other common causes are incorrect data types and improper data length. I will be happy to take a look at your input file, just send me the first few lines of the file.
Q. We have a shakemap scenario for New Madrid, how do I inject that into Shakecast to run a scenario on it?
A. You place the product files of the ShakeMap into a directory with the same name as event id and place it under the "<shakecast>\sc\data" directory. From a DOS window, issue the following command:
<shakecast>\sc\bin\scfeed_local.pl -event <evid>
Q. Why does some scenarios send email notifications and some do not?
A. Notifications are created based on four requests for four different event types, actual, test, scenario, and heartbeat. Unexpected results may happen when you mixed notifications of different event types. I will need more detailed description of this problem if you could share.
Q. We installed all of the software according to the instructions, but when we navigate to the portal, we get a text file instead of the portal view.
A. If you are seeing a plain text instead of rendered web page, this is a clear sign that the setup of PHP is likely at fault. It could be either that, during the installation, you did not select the Apache conf directory (default at "c:\program files\apache group\apche2\conf") or the required extensions correctly. To fix this problem, rerun the PHP installer (under "<shakecast>\Installer" directory), then reboot the computer to force reload of Apache with PHP.
Q. I am getting about 8-10 a day of system error message, 106 1302 2009-09-04 10:03:57 did not find ShakeMap RSS feed element at C:/ShakeCast/sc/bin/../lib/SC/Server.pm line 688, line 5129.
A. This error message shows a connection problem between your server with the upstream USGS web server at the given time. This can happens since the hostname 'earthquake.usgs.gov' is a virtual server and you are receiving data from one of the four servers at random. The server which responded might have been updating its feed content, every two minutes. It is fine as long as the error does not persist over a period of time.
Q. I am not seeing any scenario results.
A. Scenarios are not actual earthquakes so that they don't show up in the xml data feed. You need to use the admin interface (under USGS ShakeMap) to pick them up.
Q. I'm hoping that you can help me determine the right specs for a laptop that I want to use to get Shakecast up and running.
A. ShakeCast should run fine on most modern hardware with P3 or above and Windows XP. We don't support Windows Vista officially and I had received user reports showing mixed results due to variations of the OS.
Q. We are unable to use Shakecast on our intranet PC's. I believe this is because the google API requires the Shakecast server to be able to access the internet. Can you verify this?
A. You are correct that in order for the Google Maps API to work, it needs to authenticate with the Google servers via the standard http (port 80) request. This also applies to the core functions of the ShakeCast system. If there is no Internet access from within your intranet, there is little chance that the application would work.
Q. We would like to keep the server in our intranet. Is there a way to do this? Can we open some firewall ports?
A. There are in general two solutions to the users I had helped with on Internet connectivity issues with ShakeCast. One is to include proxy authentication information into the ShakeCast config file, another is to add a server exclusion policy to the ShakeCast server and allows it for outbound Internet connection. The system initiates all outgoing Internet connections and no incoming connections from the Internet. Again, to open a firewall port will be TCP/UDP 80.
Q. Is there a license issue we should be worried about Google Maps API?
A. According to EULA on the Google Maps API page, it is free to use for non-commercial purposes.
Q. I encountered the following error when I try to load the facilities to Shakecast server using the Perl script. C:\ShakeCast\sc\bin>manage_facility.pl -verbose facilities.csv DBD::mysql::st execute failed: Data too long for column 'attribute_value' at row 1 at C:\ShakeCast\sc\bin\manage_facility.pl line 443, <GEN2> line 1233.
A. The error message shows that some attribute value fields are too long. This field holds up to 30 characters. I will suggest to concatenate supplemental facility attributes into the description field, which holds up to 255 characters. This way you also save the step of defining facility type specific attributes.
Q. Would you please let me know if the format for .csv files for facilities has to be exact format that you have given me in the tutorial attached or I can have as many fields as I like as long as I include those field names? And this goes as well for user and profile?
A. In the ShakeCast manual (available on the USGS web site), there is a list of acceptable keywords for facilities you can include in the csv file. The order/case of the fields does not matter but the keys must match. Extra definitions you want to associate with facility should be defined as attribute. The same rule applies to profile and user.
Q. We run ShakeCast in virutal environment and received http failure 400: authorization.
A. As for the RSS feed errors related to http failure 400: authorization, it might be solved by increasing memory allocation to the virtual server. From a user report, David (IT analyst) changed the memory configuration of server with /PAE /3GB option. Now, we have not had the same error for a while. You could use our case to troubleshoot other people using windows server (especially with virtual server). We will keep eyes on it for more days to assure this.
Q. How about http failure 500?
A. According to the official W3 documentation, response code 500 refers to “Internal Error 500”
The server encountered an unexpected condition which prevented it from fulfilling the request.
There should be no database involved in receiving RSS data feed via http request from the upstream USGS servers. The data feed xml is a plain file sitting on the web server and is refreshed frequently. I think this is a common error that even high availability web sites (yahoo, amazon alike) are not immune to it, as long as it does not happen too often. Keep in mind that you are actually receiving the data feed via L3, which makes it unlikely a frequent occurrence. I will pass on this information to our web group and will let you know if I receive any update on this issue.
The ShakeCast user report on 500 error I have received was fairly early in ShakeCast development and was regarding the dispatcher service. The error looks like the following,
This error turned out to be associated with the Apache and local gateway server.
Q. I have tried to install the application on a XP box with SP2 and IE6 on it, and also on a XP box with SP3 and IE8 on it. After trying more than dozen times, and confirm that to bring the ShakeCast website on line and functional, the shakecast always has to be installed twice, and need to select the REPAIR option to install at the second time. Do you have any idea why this is happening?
A. I am aware that when the environment path (for Perl and other programs) is not refreshed during installation, the post-installation configuration scripts will fail and rerun of the installer is needed to finish the configuration. It seems that within your environment this is a norm and I do not know why.
Q. After installation, I can not open the site HYPERLINK "http://localhost/index.php"http://localhost/index.php. The website always tells me that I have a 404 resource not found error. I am using Listen:8080 rather than 80 because 80 can not be started by Apache.
A. There is a ShakeCast configurable field inside the MySQL database for specifying the server port. This can usually be done via the administrative web interface. To change the field (default 80) from the command line (since you don't have web access), you will need to issue commands like the following,
Q. I tried to install ShakeCast on production PCs. Unfortunately the install is failing and I am unable to proceed. The install routine is failing when it attempts to download and start the install setup routine for “MySQL 5.0 Server”. The error that displays shows an “HTTP 1.404 File Not Found” message and as a result everything bogs down.
A. The main problem for installing ShakeCast is likely from a proxy server, or firewall which broke the automated installer. If this true, you will need to work out a process for manual installation.
Q. Is there a way to assign more than one HTML email address for an individual user in ShakeCast without creating a separate user profile?
A. You may edit the Text template to match the HTML version and assign it to delivery to users' second email address.
Q. Is there a way (or will there soon be a way) for ShakeCast to effectively query the facility database and filter based on an attribute field?
A. Currently in version 2 we are discouraging extensive use of attribute since it could slow the performance of the system. An alternative to polygon to enclose the response region and to use the facility type filter (you can define both in profile definition) to separate multiple facilities.
Q. When I deleted all the users, I accidentally deleted the “scadmin” itself and got kicked out of ShakeCast.
I was able to use the manage_use.pl to bring the users.csv file back to the system, but the new administrator, after logging in, could not see the administration panel on the left. Could you suggest how to fix the problem?
A. This is a very good reason to leave the "scadmin" account untouched.
Anyway, the equivalent command for loading user csv file is the "c:\shakecast\sc\bin\manage_user.pl." You open a DOS window and issue a command like this,
Just remember to give the administrative user the user type "ADMIN" instead of "USER." Only ADMIN user will be able to access the administrative interface.
Q. Was there a default username/password for the PHPmyadmin?
A. There could be two pairs of username/password for accessing the phpMyAdmin interface. If you have enable Apache authentication (a popup dialog), then the default pair is "sc/sc" for web page access. If you were asked for username/password in the phpMyAdmin web page, it is the same as you configured inside the "sc.conf" file for database connection. The default is also "sc/sc" or whatever you entered during initial ShakeCast installation.
Q. Is there a way to install Shakecast version 2.0 without internet access?
A. Yes, it is possible to install the application without Internet connection. You have to follow the steps described inside the "windows_install.txt" file inside the shakecast home directory. It contains the manual processes of the installer. For you convenience, I saved a copy of all needed programs and modules at the url below,
Q. Can this product be run on a UNIX machine? The sheet says just windows but if it is apache MySQL it seems like it would work on UNIX better than windows.
A. Yes, I am running it with RedHat ES4 at NEIC and there also are few UNIX ShakeCast users. Under the Caltrans project we only produce and support Windows version. Source code for the UNIX version is available upon request.
Q. Is there a way that we can either generate “What if” scenarios for ShakeCast? For example, if we are doing a study on the Oct. 15, 2006 Kiholo Bay, HI 6.7 earthquake and we would like to see what potential damage might occur if an 8.0 happened in the same place, how can we create or obtain a ShakeMap to use in such a case?
A. Producing ShakeMap requires significant resources and expertise in the fields of both seismology and information technology and is strongly discouraged for PDC. All scenario ShakeMaps on the USGS website have been reviewed before publishing. You will need to request one if there is no suitable ShakeMap in the scenario and the Atlas archives.
For a magnitude 8.0 event, you can not simply scale up the M6.7 quake. At this magnitude the dimensions of fault ruptures become critical and the tectonic settings in Hawaii may not be justified to an event of this scale at shallow depth. This means that you will need to be specific about the triggered fault zones in addition to the earthquake location. I will then pass around your request to our in-house experts for their opinion and get back to you on our decision.
The Atlas contains ~5500 significant earthquakes worldwide for the pass 35 years and the chance is good that you will find a representative one in the region you are interested in.
Q. How can I add the actual shakemap jpeg to our ShakeCast notification template?
A. You customize ShakeCast notifications by editing the notification template. In the case of Caltrans notification, this is based on a damage template, located under the directory "C:\ShakeCast\sc\templates\damage\email_html." To add a ShakeMap link, you can simply edit the header segment, such as the following lines to before the table section
<img src="http://%DNS_ADDRESS%/data/%SHAKEMAP_ID%-%SHAKEMAP_VERSION%/intensity.jpg" alt=""/>
Q. Are “HAZUS western US spectral shape factors”, “mid-magnitude ranges”, and “B-C soil amplification Factors” used/assumed for shaking and damage estimates for all regions in ShakeCast/ShakeMap or only regions within the Western US?
A. It correct that the current HAZUS fragility settings in ShakeCast is for Western US only. At this time regional implementation needs to adjust the default HAZUS values for the area*.* We haven't had a chance to implement these regional HAZUS fragilities and are hoping to incorporate them along the FEMA ROVER project.
Q. When I only use my computer name followed by /index.php my coworker can see it on their computer, but receive a “cannot display” page on their web browser after they enter their username and password.
The same happens using my credentials on their computer as well.
A. Your system is still tied with the default 'localhost' domain name. For the ShakeCast installation to be used in a shared environment, you will need to log into the system as administrator and enter the hostname information using the administrative interface. This means changes of two fields, the hostname field and the Google Maps API key for the hostname. Google requires each hostname to use an unique API key and you will need to visit their web site (a direct link from within the Admin interface) to request it.
After updating these two fields, you will switch the ShakeCast system from the default 'localhost' to your unique hostname.
Q. Can I assign more than 1 html email address to a user?
A. No, ideally only one entry will be used if multiple instances exist.
Q. When I inject a ShakeMap I see the following error message in the logs:
2009-05-28 08:55:33 notifyqueue : QUIT: DBD::mysql::st execute failed: %d line(s) were cut by GROUP_CONCAT() at C:\ShakeCast\sc\bin\notifyqueue.pl line 119
It should only be sent to 3 users and they all have valid email addresses.
A. This is a MySQL issue related to long text string. Add an undocumented config option to the end of the MySQL config file "C:\Program Files\MySQL\MySQL Server 5.0\my.ini"group_concat_max_len=4096Save the file then restart the MySQL service. From the command line,net stop mysqlnet start mysql
Q. Is there a quick way to change the table header to read "Inspection Priority" instead of "Damage Level" in the upper right table?
A. This is because that the table actually matches the database definition. To alter the name, you can edit the file "c:\shakecast\sc\docs\language\lang_english\lang_main.php" and replace the definition for "Damage_level" to matching "Damage_estimate."
Q. How can I run the ShakeCast Web UI over SSL?
A. Prior to installing ShakeCast the following proceedure would need to be used:
Prepare for running Apache with SSL enabled
1.) Download Apache with SSL
2.) Install Apache with SSL
3.) Create the following folders
- C:\Program Files\Apache Group\Apache2\conf\ssl.key
- C:\Program Files\Apache Group\Apache2\conf\ssl.crt
4.) Create a key and certificate signing request(CSR)
If neccessary send the CSR to a Certificate Authority to digitally sign the certificate.
5.) Install the key by copying it to the ssl.key folder
6.) Install ShakeCast but leave the Apache checkbox unchecked
7.) Login to the ShakeCast Admin Web UI and enable "Cookie Secure" settting.
- General Admin -> Configuration -> Cookie secure
- Set to enabled
- Save the changes.
8.) Log out of Web Admin UI.
9.) Install the certificate by copying it to the C:\Program Files\Apache Group\Apache2\conf\ssl.crt folder.
10.) Edit the Apache configuration, C:\Program Files\Apache Group\Apache2\conf\httpd.conf, and enable the SSL Module
- Remove the comment character '#' from the following line:
# LoadModule ssl_module modules/mod_ssl.so
- Such that it looks like the following:
LoadModule ssl_module modules/mod_ssl.so
- Save and close the file.
11.) Edit the Apache SSL configuration file, C:\Program Files\Apache Group\Apache2\conf\ssl.conf:
Remove or comment out "<IfDefineSSL>" directive and its closing tag "</IfDefineSSL>".
Before the closing Virtual Host tag, "</VirtualHost>", add the following line:
- Include "C:/ShakeCast\sc\conf\httpd-sc.conf"
Save and close the file.
12.) Restart Apache
Q. How do I transfer all my data from one running ShakeCast Server to another newly installed ShakeCast server?
A. This proceedure is for intermediate users and is the recommended way to migrate a system from an old installation to a new installation.
1. In the Web UI go to Admin Page -> General Admin -> Backup Database, Select Full backup (You can Gzip it if you have a lot of data in your application.) Once the backup is done shutdown Apache, and the ShakeCast Services.
2. In the file system on the old installation copy the folder "sc" from C:/Shakecast/ to a network folder, or the remote machine you are installing to, or a removable device. Include the backup database file.
3. Install ShakeCast on the new machine.
4. Replace the sc folder on the new machine in C:/Shakecast/ with the one from the old system/installation(If any services are running for ShakeCast you will need to shut them down. Go to Start -> All programs -> Administrative Tools -> Services to stop the ShakeCast services.)
5. In the Admin Web UI on the new installation restore the backup. Go to Admin Page -> General Admin -> Restore Database. Find the backup database file from the old system/installation and Start Restore. (Note: after the restore you may need to set the hostname correctly)
6. Restart the ShakeCast Services on the new system.
Q. I just installed my ShakeCast system after a significant event and want to see how ShakeCast would evaluate my facilities in regard to this event. How do I go about doing this?
A. This can be accomplished by first loading your facilities into the system then creating a "Test Event" using the event of interest. Once the "Test Event" has been created you can trigger it by clicking "Version 1" from the "Action" column. If no previously processed event is available you can select one from the "USGS ShakeMap" catalog by clicking on "Scenario Inject" from the "Action" column. This will download and process the event as a "Scenario Event". Its important to note however to continue to use the event for future testing it will still need to be added as a "Test Event" from the list of processed events.