InstallationFAQ

Various MySQL? installations use different hash formats for the login passwords. Make sure the admin password in 'reg_master' is set to the proper password() format

1.3 : A PropertyDAO? error happens after initial install

Part of the installation process is setting up the default properties for an event. There is a known bug that occasionally one property isn't set up right on the very first startup. The error message is:

 java.lang.NullPointerException?
	com.stonekeep.congo.dao.PropertyDAO?.getProperty(PropertyDAO?.java:187)
	com.stonekeep.congo.coconut.Login.execute(Login.java:77)

The way to fix this is to log into the MySQL? database instance for this event and change one column value:

 update config_properties set prop_scope='Global' where prop_name='Administrator' ;

 Caused By: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its
 declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

 set GLOBAL log_bin_trust_function_creators=1

1.2 : Cannot log in after initialization

Various MySQL? installations use different hash formats for the login passwords. Make sure the admin password in 'reg_master' is set to the proper password() format

1.1 : Error during Initialization

1. Error during Initialization

Error during Initialization

"Error during Initialization'' The following text appears when setting up the database for the first time:

 Caused By: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Answer: MySQL? 5.1 changed a requirement for stored procedures. The quick solution is to change the global setting:

 set GLOBAL log_bin_trust_function_creators=1