Re: [Koha] Koha mysql DBMS fix

> > Here is a problem that someone here in this community might come across > or > > know to share how to solve this problem; I talked with my ICT > administrator > > to solve this issue to have access to the koha mysql but was unable to do > > so to fix the DBMS auto

Re: [Koha] Koha mysql DBMS fix

re is a problem that someone here in this community might come across or know to share how to solve this problem; I talked with my ICT administrator to solve this issue to have access to the koha mysql but was unable to do so to fix the DBMS auto increment problem. The issue of the "unknown v

[Koha] Koha mysql DBMS fix

Dear Koha Community, Here is a problem that someone here in this community might come across or know to share how to solve this problem; I talked with my ICT administrator to solve this issue to have access to the koha mysql but was unable to do so to fix the DBMS auto increment problem. The

Re: [Koha] Another DBI Exception for foreign key constraint in upgrade to Koha - mysql vs. mariadb

Hi, Please see solution for your problem under this link at (14:41 ashimema | gk_) http://irc.koha-community.org/koha/2022-10-07 *With Regards,* *Gopalakrishna* *Librarian, B.M.S Institute of Technology,Avalahalli, Doddaballapur Main Road,Yelahanka, Bangalore-64Mob.: 861 853 1385* *

Re: [Koha] Another DBI Exception for foreign key constraint in upgrade to Koha - mysql vs. mariadb

Hi, on my system using mysql I had the same error. Comment 34 for Bug 31086 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31086#c34 helps. It seems that KOHA with mariadb is better tested than KOHA with mysql. Is there a way to exchange the underlying database mysql by mariadb?

Re: [Koha] MySql errors

Adding more RAM to the VM will not automatically increase the MySql numbers. You must also increase the configured buffer pool. Make sure to set the *right* buffer pool: there should be separate options for the innodb buffer pool from the normal buffer pool, and it's the innodb pool that matters fo

Re: [Koha] MySql errors

They are all VM's so adding RAM is pretty trivial. They are all running with (sheepishly said) 2gig. Would simply doubling the amount of VM RAM automatically translate to more RAM being available for MySql, or would I need to allocate more RAM specifically in the my.cnf sql config file.sor

Re: [Koha] MySql errors

The important part of that log is here: 201201 14:04:22 InnoDB: Fatal error: cannot allocate memory for the buffer pool This means there's not enough memory. But I also see this: 01201 14:04:22 InnoDB: Initializing buffer pool, size = 128.0M 128MB is the default for MySql, but it's ridiculous

Re: [Koha] MySql errors

Hi Scott Log shows a lack of memory for InnoDB... 201201 14:04:22 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(135987200 bytes) failed; errno 12 201201 14:04:22 InnoDB: Completed initialization of buffer pool 201201 14:04:22 InnoDB: Fatal error: cannot allocate memory for the buff

Re: [Koha] MySql errors

Nothing that jumps out at me ??? 201201 14:04:21 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 201201 14:04:21 [Note] Plugin 'FEDERATED' is disabled. 201201 14:04:21 In

Re: [Koha] MySql errors

Hi Scott, Have you any error/warning on your mysql log that might give you a clue? Might it be that mysql runs out of allowed connections or memory? See this: https://tecadmin.net/check-update-max-connections-value-mysql https://www.percona.com/blog/2018/06/28/what-to-do-when-mysql-runs-out-of-m

[Koha] MySql errors

Hi All, I have been getting some random errors for the last couple of months on all of my Koha boxes: Software error: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/DBIx/Cla

Re: [Koha] MySql keeps crashing

Hi Monica, Is there anything useful in /var/log/mysql/error.log ? Just a suggestion. Best Regards, Chris Brown On Wed, May 22, 2019 at 4:21 PM Monica Benavides wrote: > Our IT recently updated our virtual computer from Debian 6 to 9, and > updated Koha from 3.18 to 18.11. However, it seems

[Koha] MySql keeps crashing

Our IT recently updated our virtual computer from Debian 6 to 9, and updated Koha from 3.18 to 18.11. However, it seems on a daily basis, the mysql server keeps crashing and either we have to restart the computer or IT does some other magic. Has anyone encountered this error before? Does it have an

Re: [Koha] MySQL EOL

Thank you, Chris. Guess it will be up to individual support companies to make their own determinations on when to upgrade. Cheers, Cab On Sun, Jun 17, 2018 at 5:05 PM, Chris Cormack wrote: > Hi Cab > > The latest version of Koha works fine with 5.6 and 5.7 (and the latest > mariadb releases) s

Re: [Koha] MySQL EOL

Hi Cab The latest version of Koha works fine with 5.6 and 5.7 (and the latest mariadb releases) so shouldn't be an issue *fingers crossed* :) Chris * Cab Vinton (bibli...@gmail.com) wrote: According to https://endoflife.software/applications/databases/mysql, end of life date for MySQL ver 5.5

[Koha] MySQL EOL

According to https://endoflife.software/applications/databases/mysql, end of life date for MySQL ver 5.5 is December 2018 -- not too far off. Wondering what the roadmap for Koha looks like w/ respect to MySQL. Versions 5.6 & 5.7 have several years still to go, and EOL for 8.0 is presumably way ou

[Koha] MySQL query for serials late issues

Hi, Below is my updated version of serials query for finding late issues based on the already existing query in koha sql reports library. Hope is it useful for other members. SELECT @kp:=@kp+1 as S_No,serial.serialseq, DATE_FORMAT(serial.planneddate, "%d %b %Y" ) as Planneddate, DATE_FORMAT(subsc

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

nit 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: > C

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

#x27;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 fou

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

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

Re: [Koha] MySQL database server, dedicated vs virtual

Hi to all, Il 05/12/2016 18:18, Jonathan Druart ha scritto: On a side note, we lack testers. Patches are in the queue to support new versions of MySQL (out of the box, because you can still use MariaDB or tweak the MySQL config to make it works). in fact if you want try Koha on Ubuntu 16 LTS t

Re: [Koha] MySQL database server, dedicated vs virtual

At 04:56 PM 12/5/2016 +, Jonathan Druart wrote: Paul, Hum sounds like I already answered you the same things a few months ago... I'll reply off-list to Jonathan as it could possibly only create on-list noise... P. ___ Koha mailing list http

Re: [Koha] MySQL database server, dedicated vs virtual

t wasn't clear, let me state that our analysis of > search speed is *not* any sort of recommendation. > > Best regards -- Paul > > > > >Marcel > > > > > > > >Van: Koha namens Paul A > > > >Verzonden: vrijda

Re: [Koha] MySQL database server, dedicated vs virtual

peed is *not* any sort of recommendation. Best regards -- Paul Marcel Van: Koha namens Paul A Verzonden: vrijdag 2 december 2016 21:53 Aan: koha Onderwerp: Re: [Koha] MySQL database server, dedicated vs virtual Roger, We also looked into the "search performance" last

Re: [Koha] MySQL database server, dedicated vs virtual

Onderwerp: Re: [Koha] MySQL database server, dedicated vs virtual Roger, We also looked into the "search performance" last year. We are not a lending library, so cataloguing and OPAC are our primary concerns. Please see <http://navalmarinearchive.com/z_koha/> for the detailed t

Re: [Koha] MySQL database server, dedicated vs virtual

Roger, We also looked into the "search performance" last year. We are not a lending library, so cataloguing and OPAC are our primary concerns. Please see for the detailed tech analysis and conclusions. You mention below that "Koha does not benefit a lo

Re: [Koha] MySQL database server, dedicated vs virtual

This all depends on what kind of virtual resources you're able to bring to bear. If you've got a $100,000 server, you can virtualize quite a few separate large instances of Koha. If you've got a $700 server as your virtual host that shares time as a file server and general web server, it may strugg

Re: [Koha] MySQL database server, dedicated vs virtual

Hi Tobias, a few month ago we did comparisons measuring the Koha-OPAC-Search performance with plack and memcached enabled using version 3.22. Our tests were not scientifically organised. We wanted to gather experience running Koha in different environments. We used the same MySQL database and

[Koha] MySQL database server, dedicated vs virtual

Hi! I'm currently working with a Koha implementation in a public library in southern Sweden. Our installation (it's not live yet) is currently on a virtual machine running Ubuntu Server 14.04 LTS and the version of Koha is 3.22. The MySQL database also resides on the same virtual server. I'v

[Koha] mysql query xml extract value, runtime parameters and lookup of authorized values

Hi all, I have the following mysql query below to get biblio details based on target audience/course 521$a which has authorized/pre-defined values TARGET. Some records has more than one Target audience hence the ExtractValue( b.marcxml, '//datafield[@tag="521"]/subfield[@code="a"][2]') and so on. T

[Koha] mysql not stable keeps changing on new day.

Hello all, pls kindly help. I noticed that the database in one of my koha installations keeps changing. Once the day change to the following day some operations on koha will disappear and at other time it will appear. I checked the date of the system it was correct, but cant still figure it out

Re: [Koha] Mysql problem

Hi Ahmad when i want to restore koha sql file using this command mysql -uroot -ppasswd databaseName Maybe you've got some SQL insert statements that are bigger than the allowed maximum size (maybe you are loading picture data?). You will find the parameter "max_allowed_packet" in section "my

Re: [Koha] Mysql problem

Hi, You have not mentioned anything about the versions of software involved here - OS, Koha, MySQL server. Without these information, it is difficult to attempt any help. cheers -indranil On Mon, Jul 27, 2015 at 3:21 PM, ahmnas wrote: > when i want to restore koha sql file using this comm

[Koha] Mysql problem

when i want to restore koha sql file using this command mysql -uroot -ppasswd databaseName http://koha.1045719.n5.nabble.com/Mysql-problem-tp5848326.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-com

Re: [Koha] MYSQL to SQL Sever

You could set-up the MySQL server containing coha as a linked server in MS SQL Server. You could then perform queries against it from within the MS SQL Server environment, update it - strongly NOT advisable - and/or copy its contents to a local (MSSQLSRV) DB. On Sunday, December 7, 2014, Sina Stew

Re: [Koha] MYSQL to SQL Sever

Sina Stewart schreef op ma 08-12-2014 om 06:46 [+0200]: > Yes i know that the only supported database is MySQL , i asking about > if i can transfer data to oracle or SQL server directly, like install > a tool on koha server to do trnsfer to another machine .. You can transfer data there, though y

Re: [Koha] MYSQL to SQL Sever

Thank you at all all i want to transfer data daily like backup to Oracle database on another machine , i don't want to running koha on Oracle , but transfer data automaticlly to Oracle server to be as Oracle datadase , just read from oracle server Thank You Subject: Re: [Koha]

Re: [Koha] MYSQL to SQL Sever

AM, Sina Stewart > wrote: > >> hi David >> >> Yes i know that the only supported database is MySQL , i asking about if >> i can transfer data to oracle or SQL server directly, like install a tool >> on koha server to do trnsfer to another machine .. >>

Re: [Koha] MYSQL to SQL Sever

hi David > > Yes i know that the only supported database is MySQL , i asking about if i > can transfer data to oracle or SQL server directly, like install a tool on > koha server to do trnsfer to another machine .. > Thank You > > Date: Mon, 8 Dec 2014 08:18:29 +1300 > Sub

Re: [Koha] MYSQL to SQL Sever

08:18:29 +1300 >Subject: Re: [Koha] MYSQL to SQL Sever >From: david.n...@gmail.com >To: sina_sina1...@live.com >CC: koha@lists.katipo.co.nz > >Hi Sina. > >The only supported database for Koha is MySQL. > >On 7 December 2014 at 18:12, Sina Stewart >wrote: >Dear

Re: [Koha] MYSQL to SQL Sever

to do trnsfer to another machine .. > Thank You > > Date: Mon, 8 Dec 2014 08:18:29 +1300 > Subject: Re: [Koha] MYSQL to SQL Sever > From: david.n...@gmail.com > To: sina_sina1...@live.com > CC: koha@lists.katipo.co.nz > > Hi Sina. > > The only supported databas

Re: [Koha] MYSQL to SQL Sever

hi David Yes i know that the only supported database is MySQL , i asking about if i can transfer data to oracle or SQL server directly, like install a tool on koha server to do trnsfer to another machine .. Thank You Date: Mon, 8 Dec 2014 08:18:29 +1300 Subject: Re: [Koha] MYSQL to SQL

Re: [Koha] MYSQL to SQL Sever

Hi Sina. The only supported database for Koha is MySQL. On 7 December 2014 at 18:12, Sina Stewart wrote: > Dear All i have a question about if possible to transfer the data stored > in koha database to another SQL server or Oracle database in another > machine up to date and automatically , to

[Koha] MYSQL to SQL Sever

Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL

Re: [Koha] Mysql high cpu usage

Here more info - SO Debian wheezy1 (not Squeezy, sorry) - MySQL version 5.5.38-0 - Koha is installed as package I found strange too many connections of user kobli mysql> show processlist; +--+---+---+---+-+--+---+--+ | Id | User | H

Re: [Koha] Mysql high cpu usage

Hi, ...and reading here http://forums.cpanel.net/f402/mysql-high-cpu-usage-374152.html I think have a look at MySQL logs as well, or better paste ~200 lines here http://paste.koha-community.org/ as well. Arslan On Mon, Sep 29, 2014 at 3:14 PM, Arslan Farooq wrote: > Hi, > > What are your basic

Re: [Koha] Mysql high cpu usage

Hi, What are your basic hardware specs: RAM, Processor for example. And what is your MySQL version? How was Koha installed: package or source tarball? Someone more knowledgeable in performance related stuff may require the above information to help you. Arslan On Mon, Sep 29, 2014 at 3:05 PM,

[Koha] Mysql high cpu usage

Hello everyone, in a Debian Squeeze installation Koha works slow and I can see cpu usage is mysql is 100%. Recently the site was down for too many connections and I change max_connections=500 and OK. Now there are 20 connections (sleep) from same kobli user to DB. How could I reduce this cpu usag

[Koha] MySQL - Strict checking

Are there any recommendations regarding the use of strict checking and Koha? I'm upgrading from 3.06 to 3.14 and as part of that I'm moving to MySQL 5.6, which turns strict checking on by default. A lot of database upgrade errors are coming up related to data values which are in the database

[Koha] MYSQL

Im looking for the report to count number of items that is falls between specific callnumber, eg Call No Total ItemH-HA 101 HB-HD112etc ... tq -- View this message in context: http://koha.1045719.n5.nabble.com/MYSQL-tp5788462.html Sent from the Koha-general mailing list archive at Nab

Re: [Koha] MySQL password at Koha Live DVD

Greetings, Having read those instructions, I would like to make two comments. Let's start with the positive: The MySQL portion is fine. Then the real reason for this reply: NEVER ASSUME A LINE TO CHANGE IS A FIXED LINE NUMBER! Someone may have enabled a biblio or authority server and edited th

[Koha] MySQL password at Koha Live DVD

Hi, After install Koha Live DVD from http://sourceforge.net/projects/kohalivedvd/ successfully, I added Traditional Chinese po files. I changed user password at koha and ubuntu successfully. But, how to change the password at MySQL? Could someone give me a hint? -- Wishing you all the best.

Re: [Koha] Mysql query

Why not first select those biblios with item.price >= XX SELECT ...what you need... FROM ( SELECT sum(price) as totalprice, biblionumber FROM items WHERE price >= XX GROUP BY biblionumber ) as biblio_price LEFT JOIN biblioitems on (biblio_price.biblionumber=**biblio items.biblionumber) LEF

[Koha] Mysql query

I'm looking, please, for some expertise in writing MySQL queries (Koha "reports".) I have a good "report" for listing high value items in our collections (a requirement for our insurers), but need to add the "special case" of multi volume biblios. Example: a set of Britannicas (14th ed.) is a

Re: [Koha] MySQL and year published

...@lists.katipo.co.nz] Namens Paul Verzonden: zondag 9 december 2012 23:40 Aan: koha@lists.katipo.co.nz Onderwerp: [Koha] MySQL and year published In all our frameworks we use 260$c for "date of publication" (mandatory -- even to the point of "not known / n.k." so the

[Koha] MySQL and year published

In all our frameworks we use 260$c for "date of publication" (mandatory -- even to the point of "not known / n.k." so the field cannot be NULL.) However, 260$c appears to be saved EITHER as biblioitems.publicationyear OR as biblio.copyrightdate and we do not have any records at all that include

Re: [Koha] MySQL to update dateaccessioned

Apologies - solved. One of those days that the KISS principle didn't kick in. The REPLACE in line 2 is not needed and the line should read: SET items.dateaccessioned='2010-12-31' Paul At 06:03 PM 11/22/2012 -0500, I wrote: I am trying to update a bunch of various dates to 31 Dec. The following

Re: [Koha] MySQL to update dateaccessioned

On Thu, Nov 22, 2012 at 8:03 PM, Paul wrote: > I am trying to update a bunch of various dates to 31 Dec. The following > appears to be syntactically OK, finds all 1302 to be changed, but does not > change them to 31 Dec. > > mysql> UPDATE items > -> SET items.dateaccessioned=REPLACE(**items.datea

[Koha] MySQL to update dateaccessioned

I am trying to update a bunch of various dates to 31 Dec. The following appears to be syntactically OK, finds all 1302 to be changed, but does not change them to 31 Dec. mysql> UPDATE items -> SET items.dateaccessioned=REPLACE(items.dateaccessioned,'%','2011-12-31') -> WHERE blah blah blah; Que

Re: [Koha] MySQL Database Restoring Problem from 3.4.x to 3.8.0

Hi Mason, On Thu, May 17, 2012 at 11:20 AM, Mason James wrote: Thanks for nice hints, afaik it must be created one empty database right after it was deleted. So: > $ mysql my_koha -e 'DROP DATABASE my_koha;' mysql> CREATE DATABASE my_koha; > $ mysql my_koha < koha.sql Best regards, -- Andi

[Koha] MySQL Database Restoring Problem from 3.4.x to 3.8.0

Hi all, The Koha 3.8.0 installation has no problem: http://goo.gl/WPBSC , but when restoring MySQL database from Koha 3.4.x to 3.8.0 I have an error message: ERROR 1005 (HY000) at line 2273: Can't create table 'kohadb.letter' (errno: 150) Any clue? Thanks in advance. Best regards, -- Andi Suga

Re: [Koha] MySQL Server on separate machine

On 6/4/2011 4:36 PM, Abdul Vali wrote: hi alll i am going to install koha on production server. is it possible to install koha by using mysql database installed on a separate machine? all databases of my company on a separate server machine and my IT manager is not allowing me to install my

[Koha] MySQL Server on separate machine

hi alll i am going to install koha on production server. is it possible to install koha by using mysql database installed on a separate machine? all databases of my company on a separate server machine and my IT manager is not allowing me to install mysql and koha on the same server. can someon