This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
informatica:servidor_internet_2009_debian_10_part_2 [2022/08/09 16:39] miquel created |
informatica:servidor_internet_2009_debian_10_part_2 [2022/08/10 14:43] (current) miquel [Fix Bumblebee problems] |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Servidor web/dades ====== | ||
+ | |||
===== Actualització a Debian 10.12 " | ===== Actualització a Debian 10.12 " | ||
Line 114: | Line 116: | ||
</ | </ | ||
+ | ==== Fix Bumblebee problems ==== | ||
+ | |||
+ | El programa Bumblebee (servidor de reserves) dóna diversos errors. | ||
+ | |||
+ | < | ||
+ | # tail / | ||
+ | [Sun Aug 07 12: | ||
+ | / | ||
+ | [Sun Aug 07 12: | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | Una consulta a Google indica que [[https:// | ||
+ | |||
+ | < | ||
+ | # apt search php5* | grep mbstring | ||
+ | |||
+ | WARNING: apt does not have a stable CLI interface. Use with caution in scripts. | ||
+ | |||
+ | php-mbstring/ | ||
+ | php5.6-mbstring/ | ||
+ | php5.6-mbstring-dbgsym/ | ||
+ | debug symbols for php5.6-mbstring | ||
+ | ... | ||
+ | |||
+ | # apt install php5.6-mbstring | ||
+ | Reading package lists... Done | ||
+ | Building dependency tree | ||
+ | Reading state information... Done | ||
+ | The following NEW packages will be installed: | ||
+ | php5.6-mbstring | ||
+ | 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. | ||
+ | Need to get 468 kB of archives. | ||
+ | After this operation, 1,514 kB of additional disk space will be used. | ||
+ | Get:1 https:// | ||
+ | Fetched 468 kB in 0s (2,757 kB/s) | ||
+ | Selecting previously unselected package php5.6-mbstring. | ||
+ | (Reading database ... 226308 files and directories currently installed.) | ||
+ | Preparing to unpack .../ | ||
+ | Unpacking php5.6-mbstring (5.6.40-60+0~20220627.67+debian10~1.gbp1f7ffd) ... | ||
+ | Setting up php5.6-mbstring (5.6.40-60+0~20220627.67+debian10~1.gbp1f7ffd) ... | ||
+ | |||
+ | Creating config file / | ||
+ | Processing triggers for libapache2-mod-php5.6 (5.6.40-60+0~20220627.67+debian10~1.gbp1f7ffd) ... | ||
+ | Processing triggers for php5.6-cli (5.6.40-60+0~20220627.67+debian10~1.gbp1f7ffd) ... | ||
+ | |||
+ | # apache2ctl restart | ||
+ | </ | ||
+ | |||
+ | i el problema sembla haver-se resolt, però quan intento crear una reserva surt un nou missatge d' | ||
+ | |||
+ | < | ||
+ | 2022-08-07 11:47:50 15798 [Warning] Aborted connection 15798 to db: ' | ||
+ | </ | ||
+ | |||
+ | Una cerca a Google indica que [[https:// | ||
+ | |||
+ | La solució és assignar un nou valor a aquesta variable a la secció '' | ||
+ | |||
+ | < | ||
+ | # / | ||
+ | # cp 50-server.cnf 50-server.cnf.BKUP-20220807 | ||
+ | # vi 50-server.cnf | ||
+ | </ | ||
+ | |||
+ | i afegir les línies | ||
+ | |||
+ | <code diff> | ||
+ | # diff 50-server.cnf 50-server.cnf.BKUP-20220807 | ||
+ | 45,53d44 | ||
+ | < # * Local Tuning - MCE - 20220807 | ||
+ | < # | ||
+ | < # MySQL Got timeout reading communication packets when reading federated table | ||
+ | < # https:// | ||
+ | < # | ||
+ | < wait_timeout=3600 | ||
+ | < | ||
+ | < | ||
+ | < # | ||
+ | 73,77c64,68 | ||
+ | < slow_query_log_file | ||
+ | < long_query_time | ||
+ | < log_slow_rate_limit | ||
+ | < log_slow_verbosity | ||
+ | < log-queries-not-using-indexes | ||
+ | --- | ||
+ | > # | ||
+ | > # | ||
+ | > # | ||
+ | > # | ||
+ | > # | ||
+ | </ | ||
+ | |||
+ | Referències: | ||
+ | |||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | Amb aquest canvi, desapareix aquest error, però llavors apareix un de nou, | ||
+ | |||
+ | < | ||
+ | [Sun Aug 07 16: | ||
+ | / | ||
+ | [Sun Aug 07 16: | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | que sembla indicar que hi ha un problema d' | ||
+ | |||
+ | < | ||
+ | # mariadb bmbdb117 -u sermnadmin -p | ||
+ | Enter password: | ||
+ | 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. | ||
+ | Your MariaDB connection id is 670 | ||
+ | Server version: 10.3.34-MariaDB-0+deb10u1 Debian 10 | ||
+ | |||
+ | Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. | ||
+ | |||
+ | Type ' | ||
+ | |||
+ | MariaDB [bmbdb117]> | ||
+ | +---------------------------+ | ||
+ | | Tables_in_bmbdb117 | ||
+ | +---------------------------+ | ||
+ | | ACTIVE_USERS | ||
+ | | bookings | ||
+ | | consumables | ||
+ | | consumables_use | ||
+ | | costs | | ||
+ | | groups | ||
+ | | instrumentclass | ||
+ | | instruments | ||
+ | | permissions | ||
+ | | permissions.BKUP-20210517 | | ||
+ | | permissions.BKUP-20210607 | | ||
+ | | permissions.BKUP-20211215 | | ||
+ | | projectgroups | ||
+ | | projectrates | ||
+ | | projects | ||
+ | | roleusers | ||
+ | | userclass | ||
+ | | usergroups | ||
+ | | userprojects | ||
+ | | users | | ||
+ | | users.BKUP-20210914 | ||
+ | +---------------------------+ | ||
+ | 21 rows in set (0.000 sec) | ||
+ | |||
+ | MariaDB [bmbdb117]> | ||
+ | +------------+----------------------+------+-----+---------+----------------+ | ||
+ | | Field | Type | Null | Key | Default | Extra | | ||
+ | +------------+----------------------+------+-----+---------+----------------+ | ||
+ | | id | int(10) unsigned | ||
+ | | bookwhen | ||
+ | | duration | ||
+ | | instrument | smallint(5) unsigned | NO | ||
+ | | bookedby | ||
+ | | userid | ||
+ | | projectid | ||
+ | | discount | ||
+ | | ip | char(16) | ||
+ | | comments | ||
+ | | log | text | YES | | NULL | | | ||
+ | | deleted | ||
+ | +------------+----------------------+------+-----+---------+----------------+ | ||
+ | 12 rows in set (0.001 sec) | ||
+ | |||
+ | MariaDB [bmbdb117]> | ||
+ | Bye | ||
+ | </ | ||
+ | |||
+ | Per eliminar l' | ||
+ | |||
+ | <code diff> | ||
+ | # diff db.php db.php.BKUP-20220807 | ||
+ | 46c46 | ||
+ | < | ||
+ | tabase subsystem.</ | ||
+ | --- | ||
+ | > | ||
+ | database subsystem.</ | ||
+ | </ | ||
+ | |||
+ | intento crear una reserva sense èxit, i comprovo el missatge d' | ||
+ | |||
+ | < | ||
+ | 2022-08-07 18:36:08 590 [Warning] Aborted connection 590 to db: ' | ||
+ | </ | ||
+ | |||
+ | Una consulta a Google indica que [[https:// | ||
+ | |||
+ | Per intentar resoldre l' | ||
+ | |||
+ | <code diff> | ||
+ | # diff 50-server.cnf 50-server.cnf.BKUP-20220807 | ||
+ | 34c34 | ||
+ | < max_allowed_packet | ||
+ | --- | ||
+ | > # | ||
+ | 45,53d44 | ||
+ | < # * Local Tuning - MCE - 20220807 | ||
+ | < # | ||
+ | < # MySQL Got timeout reading communication packets when reading federated table | ||
+ | < # https:// | ||
+ | < # | ||
+ | < wait_timeout=3600 | ||
+ | < | ||
+ | < | ||
+ | < # | ||
+ | 73,77c64,68 | ||
+ | < slow_query_log_file | ||
+ | < long_query_time | ||
+ | < log_slow_rate_limit | ||
+ | < log_slow_verbosity | ||
+ | < log-queries-not-using-indexes | ||
+ | --- | ||
+ | > # | ||
+ | > # | ||
+ | > # | ||
+ | > # | ||
+ | > # | ||
+ | </ | ||
+ | |||
+ | Però el problema persisteix. | ||
+ | |||
+ | Finalment, després d' | ||
+ | |||
+ | <code php> | ||
+ | [error_handling] | ||
+ | ; Browser error stream: | ||
+ | ; Set these to 0 for production systems, 1 for development/ | ||
+ | ; Show all SQL statements in the browser | ||
+ | ; VerboseSQL = 0 | ||
+ | VerboseSQL = 1 | ||
+ | ; Show all PHP warnings (such as uninitialised variables) | ||
+ | AllWarnings = 1 | ||
+ | ; Show a warning if install folder still is in the server location | ||
+ | ignore_installer = 1 | ||
+ | ; Show all GET and POST data provided by the browser | ||
+ | ; VerboseData = 0 | ||
+ | VerboseData = 0 | ||
+ | ; Use the dBug class from http:// | ||
+ | ; and debug output (designed for developer use only; you need to put dBug.php | ||
+ | ; somewhere in your include path for this to work). | ||
+ | UseDBug = 0 | ||
+ | </ | ||
+ | |||
+ | aconsegueixo veure que l' | ||
+ | |||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | trobo que la forma més fàcil de resoldre **provisionalment** el problema, és fer ús de l' | ||
+ | |||
+ | < | ||
+ | Normally INSERT stops and rolls back when it encounters an error. | ||
+ | |||
+ | By using the IGNORE keyword all errors are converted to warnings, which will not stop inserts of additional rows. | ||
+ | |||
+ | The IGNORE and DELAYED options are ignored when you use ON DUPLICATE KEY UPDATE. | ||
+ | |||
+ | Prior to MySQL and MariaDB 5.5.28, no warnings were issued for duplicate key errors when using IGNORE. You can get the old behavior if you set OLD_MODE to NO_DUP_KEY_WARNINGS_WITH_IGNORE. | ||
+ | < | ||
+ | ([[https:// | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | Per això cal modificar el fitxer ''/ | ||
+ | |||
+ | <code diff> | ||
+ | # diff dbrow.php dbrow.php.BKUP-20220807 | ||
+ | 252c252 | ||
+ | < $q = ' | ||
+ | --- | ||
+ | > $q = ' | ||
+ | </ | ||
+ | |||
+ | Després de fer el canvi, comprovo que es poden crear reserves i un nou compte d' | ||
+ | <WRAP box > | ||
+ | **Continuació: | ||
+ | </ |