- Главная Список форумов Ошибки Open Server
- Поиск
-
- Текущее время: 18 фев 2025, 13:50
- Часовой пояс: UTC+03:00
Чтобы сохранять настройки в PMA, то нужно отредактировать конфиг PMA соответствующим образом и залить соответствующие таблицы, которые будут эти настройки хранить.Ali писал(а): ↑30 мар 2020, 14:06 не сохраняется кодировка, которую я хочу указать по умолчанию, в phpMyAdmin "Сопоставление кодировки соединения",
сбрасывает значение на utf8mb4_unicode_ci
OpenServer 5.3.5
настройки дефолтные (кроме HTTPS, поменял на 444)
в настройках open server указана кодировка utf8_general_ci
Если бы не стартовал на Windows 10, то можно было бы предположить это: viewtopic.php?p=27106#p27106Dreamer0x01 писал(а): ↑30 мар 2020, 19:58 В логах openServer стандарный набор сообщений о том, что сервер успшно запущен.
Я, конечно, могу еще раз его снести и переустановить, и скорее всего снова все заработает, но хотелось бы как-то выяснть, что ломается при обновлении винды и как это починить.
2020-03-31 00:20:13 --------------------------------------------
2020-03-31 00:20:13 Начало процедуры запуска сервера
2020-03-31 00:20:13 Обновление Hosts файла
2020-03-31 00:20:13 Обновление конфигурации MySQL-5.7-x64
2020-03-31 00:20:13 Обновление конфигурации Sendmail
2020-03-31 00:20:13 Обновление конфигурации PHP_7.2-x64
2020-03-31 00:20:13 Обновление конфигурации PHPMyAdmin
2020-03-31 00:20:13 Обновление конфигурации Apache_2.4-PHP_7.2-7.3-x64
2020-03-31 00:20:13 Запуск MySQL-5.7-x64
2020-03-31 00:20:13 Запуск Apache_2.4-PHP_7.2-7.3-x64
2020-03-31 00:20:14 Проверка состояния сервера
2020-03-31 00:20:17 Cервер успешно запущен за 4,516 секунд!
===
adminer: 127.0.0.1 [31/Mar/2020:00:20:40 +0300] "GET / HTTP/1.1" 200 4722 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
adminer: 127.0.0.1 [31/Mar/2020:00:20:40 +0300] "GET /?file=functions.js&version=4.7.6 HTTP/1.1" 200 27515 "http://adminer/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:20:54 +0300] "GET /openserver/phpmyadmin/index.php HTTP/1.1" 200 3739 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:20:57 +0300] "GET /openserver/phpmyadmin/themes/original/jquery/jquery-ui.css HTTP/1.1" 200 36566 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:20:57 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery.min.js?v=4.9.0.1 HTTP/1.1" 200 86927 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:20:57 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery-migrate.js?v=4.9.0.1 HTTP/1.1" 200 17813 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:20:57 +0300] "GET /openserver/phpmyadmin/js/ajax.js?v=4.9.0.1 HTTP/1.1" 200 31246 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:20:57 +0300] "GET /openserver/phpmyadmin/phpmyadmin.css.php?nocache=4704932257ltr&server=1 HTTP/1.1" 200 20070 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
adminer: 127.0.0.1 [31/Mar/2020:00:21:00 +0300] "GET /?file=functions.js&version=4.7.6 HTTP/1.1" 200 27515 "http://adminer/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:16 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery.event.drag-2.2.js?v=4.9.0.1 HTTP/1.1" 200 12826 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:20:57 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery-ui.min.js?v=4.9.0.1 HTTP/1.1" 200 253681 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:16 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery-ui-timepicker-addon.js?v=4.9.0.1 HTTP/1.1" 200 78475 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:16 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.9.0.1 HTTP/1.1" 200 16522 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:16 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery.validate.js?v=4.9.0.1 HTTP/1.1" 200 48696 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:16 +0300] "GET /openserver/phpmyadmin/js/rte.js?v=4.9.0.1 HTTP/1.1" 200 47688 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:17 +0300] "GET /openserver/phpmyadmin/js/vendor/tracekit.js?v=4.9.0.1 HTTP/1.1" 200 45389 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
adminer: 127.0.0.1 [31/Mar/2020:00:21:20 +0300] "GET /?file=functions.js&version=4.7.6 HTTP/1.1" 200 27515 "http://adminer/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:35 +0300] "GET /openserver/phpmyadmin/js/error_report.js?v=4.9.0.1 HTTP/1.1" 200 10837 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:35 +0300] "GET /openserver/phpmyadmin/js/messages.php?l=ru&v=4.9.0.1 HTTP/1.1" 200 11652 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:35 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.9.0.1 HTTP/1.1" 200 16522 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:35 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery-ui-timepicker-addon.js?v=4.9.0.1 HTTP/1.1" 200 78475 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:35 +0300] "GET /openserver/phpmyadmin/js/config.js?v=4.9.0.1 HTTP/1.1" 200 27526 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:36 +0300] "GET /openserver/phpmyadmin/js/doclinks.js?v=4.9.0.1 HTTP/1.1" 200 20643 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
adminer: 127.0.0.1 [31/Mar/2020:00:21:40 +0300] "GET /?file=functions.js&version=4.7.6 HTTP/1.1" 200 27515 "http://adminer/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:54 +0300] "GET /openserver/phpmyadmin/js/functions.js?v=4.9.0.1 HTTP/1.1" 200 175177 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:54 +0300] "GET /openserver/phpmyadmin/js/indexes.js?v=4.9.0.1 HTTP/1.1" 200 27654 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:54 +0300] "GET /openserver/phpmyadmin/js/navigation.js?v=4.9.0.1 HTTP/1.1" 200 59988 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:54 +0300] "GET /openserver/phpmyadmin/js/common.js?v=4.9.0.1 HTTP/1.1" 200 19196 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:55 +0300] "GET /openserver/phpmyadmin/js/vendor/codemirror/mode/sql/sql.js?v=4.9.0.1 HTTP/1.1" 200 45323 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
adminer: 127.0.0.1 [31/Mar/2020:00:21:59 +0300] "GET /?file=functions.js&version=4.7.6 HTTP/1.1" 200 27515 "http://adminer/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:22:13 +0300] "GET /openserver/phpmyadmin/js/console.js?v=4.9.0.1 HTTP/1.1" 200 57280 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:22:13 +0300] "GET /openserver/phpmyadmin/js/vendor/codemirror/addon/hint/show-hint.js?v=4.9.0.1 HTTP/1.1" 200 15909 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:22:13 +0300] "GET /openserver/phpmyadmin/themes/original/jquery/jquery-ui.css HTTP/1.1" 200 36566 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:21:55 +0300] "GET /openserver/phpmyadmin/js/vendor/codemirror/lib/codemirror.js?v=4.9.0.1 HTTP/1.1" 200 373234 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:22:14 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery.min.js?v=4.9.0.1 HTTP/1.1" 200 86927 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:22:14 +0300] "GET /openserver/phpmyadmin/js/vendor/jquery/jquery-migrate.js?v=4.9.0.1 HTTP/1.1" 200 17813 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
default: 127.0.0.1 [31/Mar/2020:00:22:15 +0300] "GET /openserver/phpmyadmin/js/ajax.js?v=4.9.0.1 HTTP/1.1" 200 31246 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
adminer: 127.0.0.1 [31/Mar/2020:00:22:19 +0300] "GET /?file=functions.js&version=4.7.6 HTTP/1.1" 200 27515 "http://adminer/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0"
===
[Tue Mar 31 00:20:16.725675 2020] [ssl:warn] [pid 3624:tid 516] AH01909: ai:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:16.727675 2020] [ssl:warn] [pid 3624:tid 516] AH01909: adminer:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:16.729850 2020] [ssl:warn] [pid 3624:tid 516] AH01909: default:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:16.880401 2020] [ssl:warn] [pid 3624:tid 516] AH01909: ai:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:16.883398 2020] [ssl:warn] [pid 3624:tid 516] AH01909: adminer:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:16.886399 2020] [ssl:warn] [pid 3624:tid 516] AH01909: default:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:18.579564 2020] [mpm_winnt:notice] [pid 3624:tid 516] AH00455: Apache/2.4.41 (Win64) OpenSSL/1.1.1c configured -- resuming normal operations
[Tue Mar 31 00:20:18.579564 2020] [mpm_winnt:notice] [pid 3624:tid 516] AH00456: Apache Lounge VC15 Server built: Aug 11 2019 12:20:04
[Tue Mar 31 00:20:18.579564 2020] [core:notice] [pid 3624:tid 516] AH00094: Command line: 'D:\\ospanel\\modules\\http\\Apache_2.4-PHP_7.2-7.3-x64\\bin\\httpd.exe -d D:/OSPanel/modules/http/Apache_2.4-PHP_7.2-7.3-x64 -f d:\\ospanel\\modules\\http\\Apache_2.4-PHP_7.2-7.3-x64\\conf\\httpd.conf'
[Tue Mar 31 00:20:18.610566 2020] [mpm_winnt:notice] [pid 3624:tid 516] AH00418: Parent: Created child process 3916
[Tue Mar 31 00:20:19.600558 2020] [ssl:warn] [pid 3916:tid 588] AH01909: ai:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:19.608570 2020] [ssl:warn] [pid 3916:tid 588] AH01909: adminer:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:19.609563 2020] [ssl:warn] [pid 3916:tid 588] AH01909: default:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:19.715561 2020] [ssl:warn] [pid 3916:tid 588] AH01909: ai:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:19.717562 2020] [ssl:warn] [pid 3916:tid 588] AH01909: adminer:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:19.718560 2020] [ssl:warn] [pid 3916:tid 588] AH01909: default:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 00:20:19.809564 2020] [mpm_winnt:notice] [pid 3916:tid 588] AH00354: Child: Starting 150 worker threads.
===
d:\ospanel\modules\database\MySQL-5.7-x64\bin\mysqld.exe, Version: 5.7.25-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
====
2020-03-30T21:20:15.284789Z 0 [Note] d:\ospanel\modules\database\MySQL-5.7-x64\bin\mysqld.exe (mysqld 5.7.25-log) starting as process 3592 ...
2020-03-30T21:20:15.296216Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-30T21:20:15.296356Z 0 [Note] InnoDB: Uses event mutexes
2020-03-30T21:20:15.296397Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2020-03-30T21:20:15.296435Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-30T21:20:15.297007Z 0 [Note] InnoDB: Number of pools: 1
2020-03-30T21:20:15.297256Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-03-30T21:20:15.300821Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-30T21:20:15.313783Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-30T21:20:15.415102Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-30T21:20:15.811192Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-30T21:20:15.811986Z 0 [Note] InnoDB: Setting file 'd:\ospanel\userdata\MySQL-5.7-x64\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-30T21:20:16.018018Z 0 [Note] InnoDB: File 'd:\ospanel\userdata\MySQL-5.7-x64\ibtmp1' size is now 12 MB.
2020-03-30T21:20:16.021789Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-30T21:20:16.021846Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-30T21:20:16.022548Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-30T21:20:16.085487Z 0 [Note] InnoDB: 5.7.25 started; log sequence number 15369265
2020-03-30T21:20:16.086716Z 0 [Note] InnoDB: Loading buffer pool(s) from d:\ospanel\userdata\MySQL-5.7-x64\ib_buffer_pool
2020-03-30T21:20:16.086811Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-30T21:20:16.256740Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-03-30T21:20:16.260397Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-03-30T21:20:16.261030Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-30T21:20:16.458195Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200331 0:20:16
2020-03-30T21:20:17.869720Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-30T21:20:17.870413Z 0 [Note] d:\ospanel\modules\database\MySQL-5.7-x64\bin\mysqld.exe: ready for connections.
Version: '5.7.25-log' socket: '' port: 3306 MySQL Community Server (GPL)