-
rtcary
- Posts: 140
- Joined: 2005/10/13 18:40:55
- Contact:
[Solved] What is the best way to install phpMyAdmin?
I am running PHP 7.4.4 that was installed from the REMI library. If I use
dnf install phpMyAdmin
I get
CentOS-8 — AppStream 4.7 kB/s | 4.3 kB 00:00
CentOS-8 — Base 21 kB/s | 3.8 kB 00:00
CentOS-8 — Extras 6.9 kB/s | 1.5 kB 00:00
Extra Packages for Enterprise Linux Modular 8 — x86_64 36 kB/s | 17 kB 00:00
Extra Packages for Enterprise Linux 8 — x86_64 45 kB/s | 17 kB 00:00
google-chrome 19 kB/s | 1.3 kB 00:00
Remi’s Modular repository for Enterprise Linux 8 — x86_64 3.4 kB/s | 3.5 kB 00:01
Safe Remi’s RPM repository for Enterprise Linux 8 — x86_64 3.6 kB/s | 3.0 kB 00:00
RPM Fusion for EL 8 — Free — Updates 4.5 kB/s | 3.7 kB 00:00
RPM Fusion for EL 8 — Nonfree — Updates 6.6 kB/s | 3.7 kB 00:00
No match for argument: phpMyAdmin
Error: Unable to find a match: phpMyAdmin
[root@localhost etc]#
I get the same for phpmyadmin.
Suggestions welcomed…
Last edited by rtcary on 2020/03/22 13:32:47, edited 1 time in total.
-
lightman47
- Posts: 1444
- Joined: 2014/05/21 20:16:00
- Location: Central New York, USA
Re: What is the best way to install phpMyAdmin?
Post
by lightman47 » 2020/03/21 16:55:21
Code: Select all
phpMyAdmin.noarch 5.0.2-1.el8.remi remi
I wonder why it doesn’t show up for you. However, when I try to install it I get:
Code: Select all
$ sudo dnf install phpMyAdmin
Last metadata expiration check: 0:33:35 ago on Sat 21 Mar 2020 12:36:17 PM EDT.
Error:
Problem: package phpMyAdmin-5.0.2-1.el8.remi.noarch requires php-composer(fedora/autoloader), but none of the providers can be installed
- cannot install the best candidate for the job
- package php-fedora-autoloader-1.0.0-5.el8.remi.noarch is excluded
- package php-fedora-autoloader-1.0.1-2.el8.remi.noarch is excluded
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
Sorry to be of no help.
-
remirepo
- Posts: 442
- Joined: 2014/09/21 09:07:12
- Location: France
- Contact:
Re: What is the best way to install phpMyAdmin?
Post
by remirepo » 2020/03/22 06:58:24
Better to ask on dedicated repository forum
BTW, if one of the php stream from remi-modular is enabled, phpMyAdmin can be installed from «remi» (non modular repo).
Code: Select all
# dnf module enable php:remi-7.4
# dnf --enablerepo=remi install phpMyAdmin
Official php stream (7.2, 7.3) have missing extension, and EPEL is blocked for now
See https://pagure.io/epel/issue/75
Answer by Alfredo Castaneda
Stack Overflow
Public questions & answers
,Thanks for contributing an answer to Stack Overflow!,
Stack Overflow for Teams
Where developers & technologists share private knowledge with coworkers
,
There is no phpmyadmin package available in the core CentOS repositories. You can find a package in the EPEL repository.
– larsks
Jan 5 ’20 at 13:30
You need to install epel repository to be accessible by yum
rpm -iUvh http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum -y update
yum -y install phpmyadmin
Answer by Charli Collins
phpMyAdmin is a portable web application written in PHP. It is released under GNU GPL v2.,In this post, we will see how to install phpMyAdmin with Apache on CentOS 8 / RHEL 8.,Import the create_tables.sql to create new tables for phpMyAdmin.,Install below PHP packages for phpMyAdmin to connect with the database.
Install PHP, MySQL support package for PHP, and other PHP packages on your system for phpMyAdmin to connect with the database.
dnf install -y wget php php-pdo php-pecl-zip php-json php-common php-fpm php-mbstring php-cli php-mysqlnd php-xml tar
Install below PHP packages for phpMyAdmin to connect with the database.
dnf install -y php-json php-mbstring
phpMyAdmin package is not yet available in the OS repository for CentOS 8 / RHEL 8. So, we need to download it from the official website.
wget https://files.phpmyadmin.net/phpMyAdmin/5.1.1/phpMyAdmin-5.1.1-all-languages.tar.gz
Install phpMyAdmin using the following command.
tar -zxvf phpMyAdmin-5.1.1-all-languages.tar.gz
Move the phpMyAdmin set up to your desired location.
mv phpMyAdmin-5.1.1-all-languages /usr/share/phpMyAdmin
Copy the sample configuration file.
cp -pr /usr/share/phpMyAdmin/config.sample.inc.php /usr/share/phpMyAdmin/config.inc.php
Edit the configuration file and add a blowfish secret.
vi /usr/share/phpMyAdmin/config.inc.php
$cfg['blowfish_secret'] = 'bo95yavJ;V,1PzSlxyFwtyMJ}WmG98-6'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
Import the create_tables.sql to create new tables for phpMyAdmin.
mysql < /usr/share/phpMyAdmin/sql/create_tables.sql -u root -p
Create an alias in the Apache webserver so that phpMyAdmin can be accessed with http://your-ip-add-dress/phpmyadmin.
vi /etc/httpd/conf.d/phpMyAdmin.conf
Copy and paste the below content to the above file.
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin
<Directory /usr/share/phpMyAdmin/>
AddDefaultCharset UTF-8
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
Require all granted
</RequireAny>
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</IfModule>
</Directory>
<Directory /usr/share/phpMyAdmin/setup/>
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
Require all granted
</RequireAny>
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</IfModule>
</Directory>
Create a tmp directory for phpMyAdmin and change the permission.
mkdir /usr/share/phpMyAdmin/tmp
chmod 777 /usr/share/phpMyAdmin/tmp
Set the ownership of phpMyAdmin as shown below.
chown -R apache:apache /usr/share/phpMyAdmin
Restart the service.
systemctl restart httpd
Create SELinux policies for phpMyAdmin to work correctly.
yum install -y policycoreutils-python-utils
semanage fcontext -a -t httpd_sys_rw_content_t '/usr/share/phpMyAdmin/'
semanage fcontext -a -t httpd_sys_rw_content_t "/usr/share/phpMyAdmin/tmp(/.*)?"
restorecon -Rv '/usr/share/phpMyAdmin/'
Create a firewall rule to allow HTTP requests from external networks.
firewall-cmd --permanent --add-service=http
firewall-cmd --reload
Answer by Jakobe Norris
the command sudo sudo yum install phpmyadmin is not working on centos7. It is not finding phpmyadmin. I can´t install phpmyadmin. ,https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-with-apache-on-a-centos-7-server,I would recommend following the steps from this step by step tutorial on how to install PHPMyAdmin on CentOS 7:,Yes, I did that. But “sudo yum install phpmyadmin” is not working even after “sudo yum install epel-release”
You would need to first add the epel repository by running this command:
sudo yum install epel-release
Answer by Annabelle Stafford
The current phpMyAdmin version is compatible with PHP 7.1 and newer and MySQL 5.5 and newer. This tutorial will help you with the installation and configuration of phpMyAdmin on the CentOS 8 Linux system.,All done. You have finished the setup with the phpMyAdmin on CentOS 8 Linux machine. Now access phpMyAdmin with the below IP., # dnf install php-xml,this site is the best tutorial site centos 8, all very easy to explain .. and functional without errors, congratulations to the author.
We are assuming you already have installed the MySQL server on CentOS 8 operating system. So just install the other required packages to run and access phpMyAdmin.
sudo dnf install httpd wget unzip
sudo dnf install php php-pdo php-pecl-zip php-json php-mbstring php-mysqlnd
Once the installation finished, enable and start httpd web server.
sudo systemctl enable httpd.service
sudo systemctl start httpd.service
After downloading extract archive and move to the proper location.
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.1/phpMyAdmin-5.0.1-all-languages.zip
unzip phpMyAdmin-5.0.1-all-languages.zip
mv phpMyAdmin-5.0.1-all-languages /usr/share/phpmyadmin
Then create tmp directory and set the proper permissions.
mkdir /usr/share/phpmyadmin/tmp
chown -R apache:apache /usr/share/phpmyadmin
chmod 777 /usr/share/phpmyadmin/tmp
Now, you need to configure web server to serve phpMyAdmin on network. Create Apache configuration file for phpMyAdmin and edit in text editor:
vi /etc/httpd/conf.d/phpmyadmin.conf
Save your file and close it. The systems with SELinux enabled needs to set proper permissions to allow SELinux policies
chcon -Rv --type=httpd_sys_content_t /usr/share/phpmyadmin/*
After making all the changes, make sure to start the Apache service to reload all settings.
systemctl restart httpd.service
The systems with enabled firewalls need to allow HTTP service from the firewall. Run the below commands to open a port for the webserver in the firewall.
sudo firewall-cmd --permanent --add-service=http
sudo firewall-cmd --reload
All done. You have finished the setup with the phpMyAdmin on CentOS 8 Linux machine. Now access phpMyAdmin with the below IP.
http://your-server-ip/phpmyadmin
Answer by Harley Harrington
8. Edit the line and enter the new php root password between the single-quotes, as follows:,7. Find the following line:,2. Find the following sections:,2. Enter the newly-defined admin username and password.
1. In a terminal window, enter the following command to download the phpMyAdmin file:
wget https://files.phpmyadmin.net/phpMyAdmin/4.9.4/phpMyAdmin-4.9.4-all-languages.zip
2. Extract the .zip file archive:
unzip phpMyAdmin-4.9.4-all-languages.zip
3. Move the extracted files to the /usr/share/phpmyadmin
directory:
sudo mv phpMyAdmin-4.9.4-all-languages.zip /usr/share/phpmyadmin
4. Change directories:
cd /usr/share/phpmyadmin
5. Rename the sample php configuration file:
sudo mv config.sample.inc.php config.inc.php
6. Open the php configuration file for editing:
sudo nano config.inc.php
7. Find the following line:
$cfg['blowfish_secret'] = '';
8. Edit the line and enter the new php root password between the single-quotes, as follows:
$cfg['blowfish_secret']='my_password';
10. Next, create and set permissions on a temporary phpMyAdmin directory:
mkdir /usr/share/phpmyadmin/tmp
mkdir /usr/share/phpmyadmin/tmp
chown -R apache:apache /usr/share/phpmyadmin
chown -R apache:apache /usr/share/phpmyadmin
chmod 777 /usr/share/phpmyadmin/tmp
1. Create an Apache configuration file:
sudo nano /etc/httpd/conf.d/phpmyadmin.conf
2. This creates a new, blank configuration file. Enter the following code:
Alias /phpmyadmin /usr/share/phpmyadmin
<Directory /usr/share/phpmyadmin/>
AddDefaultCharset UTF-8
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
Require all granted
</RequireAny>
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</IfModule>
</Directory>
<Directory /usr/share/phpmyadmin/setup/>
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
Require all granted
</RequireAny>
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</IfModule>
</Directory>
4. Finally, restart the Apache service to apply the changes made in the configuration file:
systemctl restart httpd
1. Start by installing the following software package:
yum –y install policycoreutils-python-utils
2. Next, enable access to the phpmyadmin directory with the following commands:
semanage fcontext –a –t httpd_sys_rw_content_t '/usr/share/phpmyadmin/'
semanage fcontext –a –t httpd_sys_rw_content_t '/usr/share/phpmyadmin/'
semanage fcontext –a –t httpd_sys_rw_content_t "usr/share/phpmyadmin/tmp(/.*)?"
semanage fcontext –a –t httpd_sys_rw_content_t "usr/share/phpmyadmin/tmp(/.*)?"
restorecon -Rv '/usr/share/phpmyadmin/'
1. Create a firewall rule to allow HTTP traffic with the command:
firewall–cmd ––permanent ––add-service=http
2. Make sure to reload the firewall after making these modifications:
firewall-cmd ––reload
1. Open a web browser, and navigate to the following URL:
localhost/phpmyadmin
2. To bypass this measure, open the MySQL shell and alter the root user:
mysql –u root –p
password
ALTER USER 'root'@'localhost' IDENTIFIED WITH myswl_native_password BY 'password';
1. Open the phpmyadmin.conf file in a text editor (we will be using nano):
sudo nano /etc/httpd/conf.d/phpmyadmin.conf
2. Find the following sections:
Require all granted
3. Replace these lines with the following:
Require ip your_system's_ip_address
Require ip ::1
1. Create a new authentication file. In a terminal window, enter the following:
mkdir /etc/phpmyadmin
mkdir /etc/phpmyadmin
htpasswd –c /etc/phpmyadmin/.htpasswd admin
3. Next, update Apache to use .htpasswd by editing /etc/httpd/conf.d/phpmyadmin.conf as follows:
nano /etc/httpd/conf.d/phpmyadmin.conf
4. Just underneath the line labeled AddDefaultCharset UTF-8
, add the following lines:
Options +FollowSymLinks +Multiviews +Indexes
AllowOverride None
AuthType basic
AuthName "Authentication Required"
AuthUserFile /etc/phpmyadmin/.htpasswd
Require valid-user
6. Finally, restart Apache:
systemctl restart httpd
Answer by Barrett Scott
That’s it, now you can log in! You have completed the phpMyAdmin install on CentOS 7.,Let’s run down the step-by-step process of how to install phpMyAdmin on CentOS 7:,Now that the EPEL repo is made available, we can proceed to install phpMyAdmin on CentOS 7.,You can see an example of the phpMyAdmin.conf file below:
The first prerequisite of phpMyAdmin is an Apache web server. Use the following command to install Apache on your CentOS 7 virtual private server:
yum install httpd -y
Next, check the status of apache with the command:
systemctl status httpd
phpMyAdmin comes in the EPEL repository (Extra Packages for Enterprise Linux). To access EPEL you need to install a special package – epel-release. Use the following command to install epel-release on your CentOS:
sudo yum install epel-release
Issue the following command:
sudo yum install phpmyadmin
The edit will make sure that you can access your phpMyAdmin client remotely. We’ll open the phpMyAdmin.conf file located in the directory /etc/httpd/conf.d/ using the vim editor:
vim /etc/httpd/conf.d/phpMyAdmin.conf
Next we’ll restart the Apache web server by entering the following command in the command line:
systemctl restart httpd
Open the file using the vim editor:
vim config.inc.php
Answer by Mario Brewer
Creating of phpMyAdmin configuration storage using dbconfig-common.,Configuration of a web server (works for Apache and lighttpd).,phpMyAdmin configuration storage
Zero configuration
Manual configuration
,Customizing configuration file using docker-compose
git clone https://github.com/phpmyadmin/phpmyadmin.git
Answer by Ariya Shannon
It seems my system is broken becasue apt-get install aptitude can’t be installed.
– user423047
Jan 1 ’17 at 3:45
,
Who was the last leader of a country to call himself a dictator, or the last regime that called itself a dictatorship?
,Connect and share knowledge within a single location that is structured and easy to search.,
i would suggest you use aptitude package manager as it will suggest easy solution to fix the unmet dependencies problem ,install via apt sudo apt-get install aptitude then install phpmyadmin sudo aptitude install phpmyadmin and choose a go solution suggest to fix your problem
– Arduino_Sentinel
Jan 1 ’17 at 3:33
If everything is okay,add this ppa
sudo add-apt-repository ppa:phpmyadmin/ppa
sudo apt-get update
then install phpmyadmin
sudo apt-get install phpmyadmin
1 2017-01-06 22:35:54
- olgaaa
- Редкий гость
- Неактивен
- Зарегистрирован: 2013-09-23
- Сообщений: 12
Тема: ошибка phpmyadmin — не работает Поиск в базе данных
Здравствуйте не работает Поиск в базе данных в phpmyadmin
скриншот http://joxi.ru/a2XxxJ4h1wEkg2
Fatal error: Uncaught exception ‘InvalidArgumentException’ with message ‘Select_string only accepts integers: 0’ in /usr/share/php/gettext/gettext.php:354 Stack trace: #0 /usr/share/php/gettext/gettext.php(388): gettext_reader->select_string(‘0’) #1 /usr/share/php/gettext/gettext.inc(293): gettext_reader->ngettext(‘%1$s match in <…’, ‘%1$s matches in…’, ‘0’) #2 /usr/share/phpMyAdmin/libraries/DbSearch.class.php(337): _ngettext(‘%1$s match in <…’, ‘%1$s matches in…’, ‘0’) #3 /usr/share/phpMyAdmin/libraries/DbSearch.class.php(289): PMA_DbSearch->_getResultsRow(‘blog_blog’, Array, true, ‘0’) #4 /usr/share/phpMyAdmin/db_search.php(46): PMA_DbSearch->getSearchResults() #5 {main} thrown in /usr/share/php/gettext/gettext.php on line 354
2 Ответ от Hanut 2017-01-07 14:11:01
- Hanut
- Модератор
- Неактивен
- Откуда: Рига, Латвия
- Зарегистрирован: 2006-07-02
- Сообщений: 9,723
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Уточните версию phpMyAdmin и формируемый SQL запрос.
3 Ответ от sas333 2017-01-25 06:50:19 (изменено: sas333, 2017-01-25 06:52:10)
- sas333
- Редкий гость
- Неактивен
- Зарегистрирован: 2017-01-25
- Сообщений: 7
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Здравствуйте. столкнулся с такой же проблемой не работает поиск выдаёт следующее. версия 4.4.15.9, обновлял до 4.4.15.10 не помогло стоит ISPmanager до этого работало всё нормально. что случилось не понятно. Ни чего вроде не делал. Через панель ISPmanager пробовал удалять phpMyAdmin и снова ставить не помогло. кто сталкивался с такой проблемой подскажите как это исправить
если картинку плохо видно вот ссылка http://rgho.st/7JbNNfn22
4 Ответ от Hanut 2017-01-25 10:25:59
- Hanut
- Модератор
- Неактивен
- Откуда: Рига, Латвия
- Зарегистрирован: 2006-07-02
- Сообщений: 9,723
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Посмотрите ошибки в журналах веб-сервера, возможно там будет понятнее указана причина ошибки.
5 Ответ от sas333 2017-01-25 11:08:06
- sas333
- Редкий гость
- Неактивен
- Зарегистрирован: 2017-01-25
- Сообщений: 7
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Hanut сказал:
Посмотрите ошибки в журналах веб-сервера, возможно там будет понятнее указана причина ошибки.
31.173.242.123 — — [25/Jan/2017:11:04:05 +0300] «GET /phpmyadmin/themes/pmahomme/img/logo_right.png HTTP/1.1» 200 4548 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:04:05 +0300] «GET /phpmyadmin/themes/dot.gif HTTP/1.1» 200 43 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:04:05 +0300] «GET /phpmyadmin/themes/pmahomme/img/sprites.png HTTP/1.1» 200 46795 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
141.8.132.30 — — [25/Jan/2017:11:04:19 +0300] «GET /armymsk27016/player.php?id=479 HTTP/1.1» 404 221 «-» «Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)»
141.8.184.29 — — [25/Jan/2017:11:04:35 +0300] «GET /army27015/player.php?id=141108 HTTP/1.1» 404 218 «-» «Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)»
141.8.184.4 — — [25/Jan/2017:11:04:37 +0300] «GET /army27015/player.php?id=142649 HTTP/1.1» 404 218 «-» «Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)»
141.8.184.29 — — [25/Jan/2017:11:04:44 +0300] «GET /Files/cstrike/maps/de_dust1x.txt HTTP/1.1» 404 230 «-» «Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)»
141.8.132.55 — — [25/Jan/2017:11:04:49 +0300] «GET /army27015/player.php?id=133892 HTTP/1.1» 404 218 «-» «Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)»
141.8.142.178 — — [25/Jan/2017:11:05:03 +0300] «GET /ps/player.php?id=1287&vsort=rank&vorder=desc HTTP/1.1» 200 24390 «-» «Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)»
141.8.132.30 — — [25/Jan/2017:11:05:03 +0300] «GET /ps/player.php?id=1287&vsort=rank&vorder=desc HTTP/1.1» 200 24390 «-» «Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)»
31.173.242.123 — — [25/Jan/2017:11:05:03 +0300] «GET /phpmyadmin/ HTTP/1.1» 200 3084 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:03 +0300] «GET /phpmyadmin/js/whitelist.php?lang=ru&db=&token=41afd2a689c6a4e3019295f7bacb9cde HTTP/1.1» 200 498 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:03 +0300] «GET /phpmyadmin/js/messages.php?lang=ru&db=&token=41afd2a689c6a4e3019295f7bacb9cde HTTP/1.1» 200 9764 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:28 +0300] «POST /phpmyadmin/index.php HTTP/1.1» 302 25 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:29 +0300] «GET /phpmyadmin/index.php?token=41afd2a689c6a4e3019295f7bacb9cde HTTP/1.1» 200 11026 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:30 +0300] «GET /phpmyadmin/phpmyadmin.css.php?nocache=5930655912ltr HTTP/1.1» 200 21402 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:30 +0300] «GET /phpmyadmin/themes/pmahomme/img/logo_left.png HTTP/1.1» 200 2327 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:31 +0300] «GET /phpmyadmin/themes/pmahomme/img/ajax_clock_small.gif HTTP/1.1» 200 1810 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:31 +0300] «GET /phpmyadmin/themes/pmahomme/img/s_collapseall.png HTTP/1.1» 200 170 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:30 +0300] «GET /phpmyadmin/js/get_scripts.js.php?scripts%5B%5D=common.js&scripts%5B%5D=codemirror/lib/codemirror.js&scripts%5B%5D=codemirror/mode/sql/sql.js&scripts%5B%5D=codemirror/addon/runmode/runmode.js&scripts%5B%5D=codemirror/addon/hint/show-hint.js&scripts%5B%5D=codemirror/addon/hint/sql-hint.js&scripts%5B%5D=console.js&scripts%5B%5D=config.js HTTP/1.1» 200 122700 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:32 +0300] «GET /phpmyadmin/themes/pmahomme/img/left_nav_bg.png HTTP/1.1» 200 297 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:32 +0300] «POST /phpmyadmin/db_structure.php?ajax_request=1&favorite_table=1&sync_favorite_tables=1&token=41afd2a689c6a4e3019295f7bacb9cde HTTP/1.1» 200 1527 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:32 +0300] «POST /phpmyadmin/version_check.php HTTP/1.1» 200 68 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:36 +0300] «GET /phpmyadmin/db_structure.php?server=1&db=rank27016&token=41afd2a689c6a4e3019295f7bacb9cde&ajax_request=true&ajax_page_request=true&menuHashes=b6e5d18d&_nocache=1485331533085924001 HTTP/1.1» 200 4091 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:37 +0300] «GET /phpmyadmin/js/get_scripts.js.php?scripts%5B%5D=db_structure.js&scripts%5B%5D=tbl_change.js&call_done=1 HTTP/1.1» 200 10796 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:37 +0300] «GET /phpmyadmin/themes/pmahomme/img/arrow_ltr.png HTTP/1.1» 200 139 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:37 +0300] «GET /phpmyadmin/navigation.php?ajax_request=1&token=41afd2a689c6a4e3019295f7bacb9cde&aPath=cm9vdA%3D%3D.cmFuazI3MDE2&vPath=cm9vdA%3D%3D.cmFuazI3MDE2&pos=0&pos2_name=&pos2_value=&searchClause=&searchClause2=&_nocache=1485331533667551803 HTTP/1.1» 200 1893 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:38 +0300] «GET /phpmyadmin/db_search.php?db=rank27016&token=41afd2a689c6a4e3019295f7bacb9cde&ajax_request=true&ajax_page_request=true&menuHashes=b6e5d18d-0bd88530&_nocache=1485331535460778914 HTTP/1.1» 200 2657 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:39 +0300] «GET /phpmyadmin/js/get_scripts.js.php?scripts%5B%5D=db_search.js&scripts%5B%5D=sql.js&scripts%5B%5D=makegrid.js&call_done=1 HTTP/1.1» 200 25135 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
31.173.242.123 — — [25/Jan/2017:11:05:43 +0300] «POST /phpmyadmin/db_search.php HTTP/1.1» 500 1578 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
Вот что в логах отображается но я в этом не силён подскажите видно тут проблему?
6 Ответ от sas333 2017-01-25 11:10:59
- sas333
- Редкий гость
- Неактивен
- Зарегистрирован: 2017-01-25
- Сообщений: 7
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Это в access.log а в error.log нет ни чего про phpmyadmin
7 Ответ от Hanut 2017-01-25 11:21:04
- Hanut
- Модератор
- Неактивен
- Откуда: Рига, Латвия
- Зарегистрирован: 2006-07-02
- Сообщений: 9,723
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Странно, что в error.log ничего нет. Судя по строке ошибка на стороне сервера, но причину так не определить, к сожалению.
«POST /phpmyadmin/db_search.php HTTP/1.1» 500
8 Ответ от sas333 2017-01-25 13:02:11
- sas333
- Редкий гость
- Неактивен
- Зарегистрирован: 2017-01-25
- Сообщений: 7
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Hanut сказал:
Странно, что в error.log ничего нет. Судя по строке ошибка на стороне сервера, но причину так не определить, к сожалению.
«POST /phpmyadmin/db_search.php HTTP/1.1» 500
Может хотя бы приблизительно подскажите в какую сторону капать. я уже что только не перепробовал логи подробные он почему то не как не хочет писать я даже в ISP легирование ставил на всю ну типа подробные логи чтобы былти и в настройках PHP. Кстати ещё было такое если в PHP включаю display_errors то этой красной ошибки не возникает но поиск не работает просто как бы сворачивается и всё. В логах появляется следующее
31.173.242.123 — — [25/Jan/2017:13:01:32 +0300] «GET /phpmyadmin/db_search.php?db=rank27015&token=41afd2a689c6a4e3019295f7bacb9cde&ajax_request=true&ajax_page_request=true&menuHashes=862d6d1c-f3101f73&_nocache=148533848891945887 HTTP/1.1» 200 2011 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
5.9.79.151 — — [25/Jan/2017:13:01:35 +0300] «GET /ps/login.php?ref=/ps/login.php%3Fref=/ps/login.php%253Fref=/ps/player.php%25253Fid=16011%252526ssort=headshotkills%252526sorder=desc HTTP/1.1» 200 6172 «-» «Mozilla/5.0 (compatible; MJ12bot/v1.4.7; http://mj12bot.com/)»
31.173.242.123 — — [25/Jan/2017:13:01:36 +0300] «POST /phpmyadmin/db_search.php HTTP/1.1» 200 1579 «-» «Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36»
9 Ответ от Hanut 2017-01-25 13:52:27
- Hanut
- Модератор
- Неактивен
- Откуда: Рига, Латвия
- Зарегистрирован: 2006-07-02
- Сообщений: 9,723
Re: ошибка phpmyadmin — не работает Поиск в базе данных
sas333 сказал:
В логах появляется следующее
Не могу сказать в чем причина. Вероятно какие-то проблемы на стороне сервера, но без ошибки даже не ясно куда смотреть.
10 Ответ от sas333 2017-01-25 17:17:29
- sas333
- Редкий гость
- Неактивен
- Зарегистрирован: 2017-01-25
- Сообщений: 7
Re: ошибка phpmyadmin — не работает Поиск в базе данных
это случайно не то
[Thu Jan 05 20:49:22.987130 2017] [:error] [pid 743] [client 184.75.215.4:39519] script ‘/usr/share/phpMyAdmin/main.php’ not found or unable to stat
[Thu Jan 05 20:50:00.157354 2017] [:error] [pid 1592] [client 184.75.215.6:40200] script ‘/usr/share/phpMyAdmin/main.php’ not found or unable to stat
11 Ответ от sas333 2017-01-25 19:37:30
- sas333
- Редкий гость
- Неактивен
- Зарегистрирован: 2017-01-25
- Сообщений: 7
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Fatal error: Uncaught exception ‘InvalidArgumentException’ with message ‘Select_string only accepts integers: 3’ in /usr/share/php/gettext/gettext.php:354 Stack trace: #0 /usr/share/php/gettext/gettext.php(388): gettext_reader->select_string(‘3’) #1 /usr/share/php/gettext/gettext.inc(293): gettext_reader->ngettext(‘%1$s match in <…’, ‘%1$s matches in…’, ‘3’) #2 /usr/share/phpMyAdmin/libraries/DbSearch.class.php(337): _ngettext(‘%1$s match in <…’, ‘%1$s matches in…’, ‘3’) #3 /usr/share/phpMyAdmin/libraries/DbSearch.class.php(289): PMA_DbSearch->_getResultsRow(‘csstats_players’, Array, true, ‘3’) #4 /usr/share/phpMyAdmin/db_search.php(46): PMA_DbSearch->getSearchResults() #5 {main} thrown in /usr/share/php/gettext/gettext.php on line 354
12 Ответ от Hanut 2017-01-25 22:40:59
- Hanut
- Модератор
- Неактивен
- Откуда: Рига, Латвия
- Зарегистрирован: 2006-07-02
- Сообщений: 9,723
Re: ошибка phpmyadmin — не работает Поиск в базе данных
Обновите phpMyAdmin до версии 4.6.6, где ошибка исправлена. Проблема в конфликте php-gettext версии 1.0.12.
https://github.com/phpmyadmin/phpmyadmin/issues/12881
13 Ответ от sas333 2017-01-25 23:26:29
- sas333
- Редкий гость
- Неактивен
- Зарегистрирован: 2017-01-25
- Сообщений: 7