Re: [Koha] Koha 17.11 - koha-mysql command - Error: Unknown Variable

[Craig Butosi]

Hi everyone,

Just a follow-up here for the community:

I had a syntax error in my MariaDB mysql.cnf file, which is found in
/etc/mysql/conf.d directory. After changing "[mysql]" to "[mysqld]" (
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix), ensuring
that the init file pathway was correct, and then restarting mysql, I was
able to get into the sql shell using $koha-mysql [instancename].

Thanks again, Tomas.

All best,

Craig Butosi, MA, MLIS, B Mus (Hons)
Library: library.craigbutosi.ca

On Sat, Dec 30, 2017 at 12:57 PM, Tomas Cohen Arazi 
wrote:

> Comment out that line of the file doesn't exist.
> Beware the autoincrement issue that file was the for.
>
> El sáb., 30 de dic. de 2017 2:21 p. m., Craig Butosi 
> escribió:
>
>> Hi all,
>>
>> Koha 17.11 on Ubuntu 16.04
>>
>> This is probably more of a MariaDB question, but I thought I'd ask anyway
>> since it's Koha-related too. I tried to run the $ koha-mysql [instance
>> name] Debian command and the following error was thrown:
>>
>> "mysql: unknown variable 'init-file=/var/lib/mysql/
>> init-file_library2.sql'
>>
>> I locating the file and I found it in the directory as shown. But I do not
>> know how to get past this error. I'm having trouble diagnosing. The init
>> file pathway is defined under the [mysql] section of
>> /etc/mysql/conf.d/mycnf.sql
>>
>> Any SQL/MARIADB gurus out there who can assist?
>>
>> Many thanks,
>>
>> Craig Butosi, MA, MLIS, B Mus (Hons)
>> Library: library.craigbutosi.ca
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> --
> Tomás Cohen Arazi
> Theke Solutions (https://theke.io )
> ✆ +54 9351 3513384 <+54%209%20351%20351-3384>
> GPG: B2F3C15F
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 17.11 - koha-mysql command - Error: Unknown Variable

[Tomas Cohen Arazi]

Comment out that line of the file doesn't exist.
Beware the autoincrement issue that file was the for.

El sáb., 30 de dic. de 2017 2:21 p. m., Craig Butosi 
escribió:

> Hi all,
>
> Koha 17.11 on Ubuntu 16.04
>
> This is probably more of a MariaDB question, but I thought I'd ask anyway
> since it's Koha-related too. I tried to run the $ koha-mysql [instance
> name] Debian command and the following error was thrown:
>
> "mysql: unknown variable 'init-file=/var/lib/mysql/init-file_library2.sql'
>
> I locating the file and I found it in the directory as shown. But I do not
> know how to get past this error. I'm having trouble diagnosing. The init
> file pathway is defined under the [mysql] section of
> /etc/mysql/conf.d/mycnf.sql
>
> Any SQL/MARIADB gurus out there who can assist?
>
> Many thanks,
>
> Craig Butosi, MA, MLIS, B Mus (Hons)
> Library: library.craigbutosi.ca
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha 17.11 - koha-mysql command - Error: Unknown Variable

[Craig Butosi]

Hi all,

Koha 17.11 on Ubuntu 16.04

This is probably more of a MariaDB question, but I thought I'd ask anyway
since it's Koha-related too. I tried to run the $ koha-mysql [instance
name] Debian command and the following error was thrown:

"mysql: unknown variable 'init-file=/var/lib/mysql/init-file_library2.sql'

I locating the file and I found it in the directory as shown. But I do not
know how to get past this error. I'm having trouble diagnosing. The init
file pathway is defined under the [mysql] section of
/etc/mysql/conf.d/mycnf.sql

Any SQL/MARIADB gurus out there who can assist?

Many thanks,

Craig Butosi, MA, MLIS, B Mus (Hons)
Library: library.craigbutosi.ca
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha