[Koha] Web Installer: authorities_normal_marc21 incorrect integer value & mysql 5.6 warning message on password

[Galen Charlton]

Hi,

On Wed, Aug 14, 2013 at 10:55 AM, Victor Pang <victorp at netmedia.com.sg>wrote:

> I just ran through Step 3 of Web Installer and I encountered this error in
> authorities_normal_marc21.sql:
>
> ERROR 1366 (HY000) at line 272: Incorrect integer value: '' for column
> 'linkid' at row 1
>
> and peeking into that file is this error SQL statement line:
>
> INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`,
> `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`,
> `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`,
> `linkid`,
> `kohafield`, `frameworkcode`) VALUES
>
> How do I correct this error? I am using MySQL 5.6.13 on Mac OS X 10.8.3.
>

It looks like MySQL on OS X ships with SQL_MODE set to include
STRICT_TRANS_TABLES.  Unfortunately -- and this is a problem -- Koha
currently doesn't support that mode.

As a workaround, I suggest using the procedure described in the following
blog post to set SQL_MODE to a more lenient level:

http://stanlemon.net/2013/03/23/mysql-strict-mode-on-os-x/


> Also, MySQL 5.6.x now warns users when you enter your password on the
> command line via "-p<password>" or "-p" and prompted:
>
> Warning: Using a password on the command line interface can be insecure.
>
> So I got all these warnings for every SQL files imported. In fact, when the
> Web Installer imports the database structure, it ended with the warning
> message and I couldn't continue without starting from Step 1 again.
> Luckily,
> the Web Installer knows when it stops and let me continue to set the basic
> default settings.
>

That should be cleaned up as well.  Would you mind filing a bug?

Regards,

Galen
-- 
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org