Proxy Error after MariaDB upgrade to 10.2.14
Hello everyone, i just ran into a Problem with my Koha System. After upgrading the MariaDB from 10.0 to 10.2.14 I have no access to the Server. I can not provide the Version of Koha, but for Apache: ####################################################### Server version: Apache/2.4.18 (Ubuntu) Server built: 2018-04-18T14:53:04 ? apache2.service - LSB: Apache2 web server Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled) Drop-In: /lib/systemd/system/apache2.service.d +-apache2-systemd.conf Active: active (running) since Fri 2018-05-11 00:05:38 CEST; 5 days ago Docs: man:systemd-sysv-generator(8) Process: 62250 ExecReload=/etc/init.d/apache2 reload (code=exited, status=0/SU CGroup: /system.slice/apache2.service +-47224 /usr/sbin/apache2 -k start +-48517 /usr/sbin/apache2 -k start +-48520 /usr/sbin/apache2 -k start +-61991 /usr/sbin/apache2 -k start +-61996 /usr/sbin/apache2 -k start +-62305 /usr/sbin/apache2 -k start +-62307 /usr/sbin/apache2 -k start +-62310 /usr/sbin/apache2 -k start +-62312 /usr/sbin/apache2 -k start +-62313 /usr/sbin/apache2 -k start May 16 09:00:18 www2 systemd[1]: Reloading LSB: Apache2 web server. May 16 09:00:18 www2 apache2[62250]: * Reloading Apache httpd web server apache May 16 09:00:19 www2 apache2[62250]: * May 16 09:00:19 www2 systemd[1]: Reloaded LSB: Apache2 web server. ####################################################### Memcached und Plack is active. user@www2:~$ sudo koha-plack --start library * Error: Plack already running for library [fail] ####################################################### If I try to access the Website it takes about 10 Minutes until this error-page appears: Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET /index.html. Reason: Error reading from remote server Apache/2.4.18 (Ubuntu) Server at www2.testothek.uni-hamburg.de Port 443 Maybe someone can help me out here. Thanks Jan -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
I'm forced to use "sudo dpkg --configure -a" before I can run apt-get update / upgrade commands. It shows: "E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem." and if run "sudo dpkg --configre -a" I only get: "Upgrading database schema for library" with no feedback for hours! After a few I get a server disconnect message, which I do not have at the moment. Maybe this has something to do with it? Kind regards Jan -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Is there a way to test the database connection via Console? -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi Jan Am 29.05.2018 um 10:21 schrieb JanM:
Is there a way to test the database connection via Console?
If Mysqld is running you should be able to see something listening on default port 3306 at all: # telnet localhost 3306 Trying ::1... Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. S 5.5.60-0+deb8u1�-Q6Y?l%p&!�kgCYt]Ur^`F{mysql_native_password ... Disconnect with CTRL+R+] ... However, you should also be able to connect via SQL command line to get the mysql prompt: $ mysql -uUSER -pPASSWORD DATABASENAME Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11765 Server version: 5.5.60-0+deb8u1 (Debian) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> Hope this helps. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Thanks Michael, but i forgot to mention that the mariadb server is hosted by our computing center and i only have access to the phpmyadmin page, but not to the console of this server. This is due to our privacy policies... the Koha server is hosted on a local server in the network. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Jan, Do you have console access to the *Koha* server? If so, log in there, and assuming that you are running a package install of Koha, you can run sudo koha-list This will tell you which instances of koha are installed (unless you've gotten fancy, there will only be one) Then you can run sudo koha-mysql instance-name Where instance-name is the output from koha-list. The script koha-mysql will read the username, password, database name, server name and port number from koha-conf.xml, and will connect to the database if it is up and running. If you can't connect, 1) check the settings in koha-conf.xml 2) have your IT department check that the port is open in the firewall. 3) have them restart mysql. On Tue, May 29, 2018, 06:17 JanM <jan.michael.mueck@uni-hamburg.de> wrote:
Thanks Michael, but i forgot to mention that the mariadb server is hosted by our computing center and i only have access to the phpmyadmin page, but not to the console of this server. This is due to our privacy policies... the Koha server is hosted on a local server in the network.
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Barton, this work perfect. user@www2:~$ user@www2:~$ sudo koha-list -bash: user@www2:~$: command not found user@www2:~$ [sudo] password for user: -bash: [sudo]: command not found user@www2:~$ library -bash: library: command not found user@www2:~$ sudo koha-mysql library Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 1174405 Server version: 10.2.14-MariaDB-log openSUSE package Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [testothek2]> ####################################################### Currently running the "Upgrading database schema for library" again, these are the errors so far after a few hours: Upgrading database schema for library DBD::mysql::db do failed: Lost connection to MySQL server during query [for Statement " SELECT * FROM systempreferences WHERE 1 = 0 "] at /usr/share/koha/lib/Koha/Database.pm line 109. DBD::mysql::st execute failed: Lost connection to MySQL server during query [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='version'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Has anyone a idea how to fix it? It is still not working and I'm out of ideas.. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi Jan, can you describe the problem again? I think for people just reading the emails it's not clear what you are asking about. Katrin On 17.07.2018 11:34, JanM wrote:
Has anyone a idea how to fix it? It is still not working and I'm out of ideas..
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Barton Chittenden -
JanM -
Katrin Fischer -
Michael Kuhn