Dear Tom, Talk to your Network people to open the 7090 port for your private IP. That will work to connect. Sushant K Panigrahi ----- Original Message ----- From: koha-request@lists.katipo.co.nz Date: Sunday, June 17, 2012 5:32 am Subject: Koha Digest, Vol 80, Issue 23 To: koha@lists.katipo.co.nz
Send Koha mailing list submissions to koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."
Today's Topics:
1. Re: Z3950 fail to connect to external Database (Tom Obrien) 2. Net::Z3950::ZOOM via cpan (was Re: Installing Koha on CentOS+cPanel Hosting Server) (Andi Sugandi) 3. force install DBD::SQLite2 (Andi Sugandi) 4. Re: Z3950 fail to connect to external Database (David Nind) 5. Re: Net::Z3950::ZOOM via cpan (was Re: Installing Koha on CentOS+cPanel Hosting Server) (Bernardo Gonzalez Kriegel) 6. Re: force install DBD::SQLite2 (Bernardo Gonzalez Kriegel) 7. Koha Error (Sivakumar Gopal) 8. Re: Koha Error (David Nind)
----------------------------------------------------------------- -----
Message: 1 Date: Fri, 15 Jun 2012 22:59:50 -0700 From: Tom Obrien <tobrienu@gmail.com> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Z3950 fail to connect to external Database Message-ID: <CAE+4i9- xUTk2F10DVSgKOQ+imyHxrq1NNCng+gfu3nBUESj2nw@mail.gmail.com>Content-Type: text/plain; charset=ISO-8859-1
Hi, We are using Koha-3.6. When trying to import records from other catalogues- Library of congress,etc. (using ports 210, 7090, 9991,etc) but connection refuses.We are running behing a proxy server-quid. Kindly advice us how we can bypass the proxy server and access these databases . Thanks in advance,
T. Obrien Librarian, St. Judes Technical College
------------------------------
Message: 2 Date: Sat, 16 Jun 2012 14:48:20 +0700 From: Andi Sugandi <andisugandi@gmail.com> To: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Cc: koha <koha@lists.katipo.co.nz> Subject: [Koha] Net::Z3950::ZOOM via cpan (was Re: Installing Koha on CentOS+cPanel Hosting Server) Message-ID: <CAP9RdOCKPDNuRrr7bgN8_QeMXMHOfzCrkmJwS1pGFi+_O0Qn6w@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Hi all,
On Wed, Jun 6, 2012 at 7:49 AM, Andi Sugandi <andisugandi@gmail.com> wrote:
On Mon, Jun 4, 2012 at 7:07 PM, Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> wrote:
In a situation like yours, I have downloaded and compiled Perl (on /usr/local, 5.14), then I installed all the required modules from CPAN (a long long work) Then Koha. It works.
My advice would be not to touch anything in the system. Only install what is needed by Koha in /usr/local
Yes, I understand now, your advices are very valuable, and this issue now is solved.
Actually, I find another issue on installing Net::Z3950::ZOOM Perl Module via cpan on this machine: http://paste.koha-community.org/455
This also happened before it's upgraded in to newer version (5.16.0), and did:
force install Net::Z3950::ZOOM
But, I'm afraid it will produce another issue like this one(?): http://lists.katipo.co.nz/pipermail/koha/2012-June/033118.html
So I ask it first in the list before again doing "force install".
I already filled bug on cpan's: https://rt.cpan.org/Public/Bug/Display.html?id=77861
Any help will be very much appreciated.
Thanks in advance and have nice weekend! :)
Best regards, -- Andi Sugandi.
------------------------------
Message: 3 Date: Sat, 16 Jun 2012 15:09:33 +0700 From: Andi Sugandi <andisugandi@gmail.com> To: koha <koha@lists.katipo.co.nz> Subject: [Koha] force install DBD::SQLite2 Message-ID: <CAP9RdODHpquW7id7HYPn_QG-mza- 6nYPG5z9mvPaZy7eu+ezcQ@mail.gmail.com>Content-Type: text/plain; charset=ISO-8859-1
Hi all,
Is it safe to 'force install DBD::SQLite2' in cpan according to the failed 'make test'[1] on my VDS (CentOS 6.2, x86_64) machine (btw, this is another issue[2] on the same machine):
[1] http://paste.koha-community.org/456 [2] http://lists.katipo.co.nz/pipermail/koha/2012-June/033159.html
As we know, DBD::SQLite2 is one of the required Perl modules that should be installed before running Koha Web Installer.
Any help would be appreciated.
Thanks and have nice weekend.
Best regards, -- Andi Sugandi.
------------------------------
Message: 4 Date: Sun, 17 Jun 2012 00:18:45 +1200 From: David Nind <david.nind@gmail.com> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Z3950 fail to connect to external Database Message-ID: <CAK5OMPdSpxFV9aSSF+JJ- Yp6AHPPzomvjhYsuLLmJKPuGOPG4A@mail.gmail.com>Content-Type: text/plain; charset=ISO-8859-1
Hi Tom.
I think that you will have to contact the people who look after your proxy server/firewall.
Depending on how these are setup for your organisation they will probablyneed to enable access to these ports/services. Not sure how difficult this will in your organisation though....
Regards.
David Nind | david.nind@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098
On 16 June 2012 17:59, Tom Obrien <tobrienu@gmail.com> wrote:
Hi, We are using Koha-3.6. When trying to import records from other catalogues- Library of congress, etc. (using ports 210, 7090, 9991,etc) but connection refuses. We are running behing a proxy server-quid. Kindly advice us how we can bypass the proxy server and access these databases . Thanks in advance,
T. Obrien Librarian, St. Judes Technical College _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Message: 5 Date: Sat, 16 Jun 2012 09:25:33 -0300 From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> To: Andi Sugandi <andisugandi@gmail.com> Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Net::Z3950::ZOOM via cpan (was Re: Installing Koha on CentOS+cPanel Hosting Server) Message-ID: <CADF4kvTF64Df4mxaYFERHKLY4kn=sstv90U_bsOO3N5Y7=2UNw@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
Andy,
1) Warnings at compile time: your are trying to compile the last version of Net::Z3950::ZOOM with an old version of yaz. I installed yaz-4.2.25 on /usr/local
2) Failed tests: I have the same messages, no problem, do a force install.
Bernardo
-- Bernardo Gonzalez Kriegel bgkriegel@gmail.com
On Sat, Jun 16, 2012 at 4:48 AM, Andi Sugandi <andisugandi@gmail.com> wrote:
Hi all,
On Wed, Jun 6, 2012 at 7:49 AM, Andi Sugandi <andisugandi@gmail.com>> wrote:
On Mon, Jun 4, 2012 at 7:07 PM, Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> wrote:
In a situation like yours, I have downloaded and compiled Perl (on /usr/local, 5.14), then I installed all the required modules from CPAN (a long long work) Then Koha. It works.
My advice would be not to touch anything in the system. Only install what is needed by Koha in /usr/local
Yes, I understand now, your advices are very valuable, and this issue now is solved.
Actually, I find another issue on installing Net::Z3950::ZOOM Perl Module via cpan on this machine: http://paste.koha-community.org/455
This also happened before it's upgraded in to newer version (5.16.0), and did:
force install Net::Z3950::ZOOM
But, I'm afraid it will produce another issue like this one(?): http://lists.katipo.co.nz/pipermail/koha/2012-June/033118.html
So I ask it first in the list before again doing "force install".
I already filled bug on cpan's: https://rt.cpan.org/Public/Bug/Display.html?id=77861
Any help will be very much appreciated.
Thanks in advance and have nice weekend! :)
Best regards, -- Andi Sugandi.
------------------------------
Message: 6 Date: Sat, 16 Jun 2012 09:34:02 -0300 From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> To: Andi Sugandi <andisugandi@gmail.com> Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] force install DBD::SQLite2 Message-ID: <CADF4kvR2H9ufU_AJjSPFoMABk-Vh+T51jrbPR- KBez4YUCb+vA@mail.gmail.com>Content-Type: text/plain; charset=UTF-8
Andy, it's required, but only to create the database for offline circulation.Do a force install, I have the same failed tests.
Bernardo -- Bernardo Gonzalez Kriegel bgkriegel@gmail.com
On Sat, Jun 16, 2012 at 5:09 AM, Andi Sugandi <andisugandi@gmail.com> wrote:
Hi all,
Is it safe to 'force install DBD::SQLite2' in cpan according to the failed 'make test'[1] on my VDS (CentOS 6.2, x86_64) machine (btw, this is another issue[2] on the same machine):
[1] http://paste.koha-community.org/456 [2] http://lists.katipo.co.nz/pipermail/koha/2012-June/033159.html
As we know, DBD::SQLite2 is one of the required Perl modules that should be installed before running Koha Web Installer.
Any help would be appreciated.
Thanks and have nice weekend.
Best regards, -- Andi Sugandi. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Message: 7 Date: Sat, 16 Jun 2012 14:50:52 +0530 From: Sivakumar Gopal <alphacelibrarian@gmail.com> To: Koha@lists.katipo.co.nz Subject: [Koha] Koha Error Message-ID: <CAPBCkxAgovfbUngh7S4jDezb=F1q6RAffxVQab_O+QV21+STMw@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Good day everyone!
I am currently experiencing following Koha error
The following fatal error has occurred when i opened koha.
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 692.
Thanks with regards -- Librarian Alpha College of Engineering Thirumazhisai Chennai - 600 124
------------------------------
Message: 8 Date: Sun, 17 Jun 2012 10:30:27 +1200 From: David Nind <david.nind@gmail.com> To: Koha@lists.katipo.co.nz Subject: Re: [Koha] Koha Error Message-ID: <CAK5OMPfTSedR8jznZ+r4swvQJxOftSXcqf6i7Cr8XVyzXYoVxg@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Hi.
It looks like something to do with your MySql server (the database used by Koha).
Can you connect to your MySql server from the command line e.g. mysql -u root -p whateveryourmysqlrootpasswordis ?
Also, what version of Koha are you using? And what Linux operating system are you running on? (If Debian, did you install manually or by using packages?)
David Nind | david.nind@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098
On 16 June 2012 21:20, Sivakumar Gopal <alphacelibrarian@gmail.com> wrote:
Good day everyone!
I am currently experiencing following Koha error
The following fatal error has occurred when i opened koha.
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 692.
Thanks with regards -- Librarian Alpha College of Engineering Thirumazhisai Chennai - 600 124 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 80, Issue 23 ************************************