271
Technical Help / Re: PHPMyAdmin - Can't Login As root User
« on: November 10, 2014, 10:29:07 pm »
I updated my previous response with a command you can run to enable logging in as the root user in PHPMyAdmin.
EHCP Force Edition can be downloaded from GitHub
https://github.com/earnolmartin/EHCP-Force-Edition
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
It would be possible to add a really robust fail2ban configuration that already comes in the default installation of EHCP FORCE and also integrate DKIM configuration to postfix?
Thanxs
After doing the most recent update root password no longer works in phpmyadmin could you please lookin to fixing this as i have gone to zpanel for till this problem can be fixed
sudo -i
sed -i "s#^include_once 'rootip_whitelist_functions.php';#include_once '/usr/share/phpmyadmin/rootip_whitelist_functions.php';#g" "/etc/phpmyadmin/config.inc.php"
sed -i "s#^include 'rootip_whitelist.php';#include '/usr/share/phpmyadmin/rootip_whitelist.php';#g" "/etc/phpmyadmin/config.inc.php"
cd /usr/share/phpmyadmin/
nano rootip_whitelist.php
// IP Addresses that are allowed to login via the root MySQL account through PHPMyAdmin
$allowedIPs = array("127.0.0.1");
// IP Addresses that are allowed to login via the root MySQL account through PHPMyAdmin
$allowedIPs = array("127.0.0.1", "1.1.1.1");
sudo sh -c "echo \"<?php \\\$cfg['Servers'][1]['AllowRoot'] = TRUE; ?>\" >/usr/share/phpmyadmin/rootip_whitelist.php"
sudo sh -c ">/usr/share/phpmyadmin/rootip_whitelist.php"
if I remember correctly, the server did not receive the mail, so I was looking and looking .. the only option was to compile the package pop-before-smtp (although that point had already installed Ubuntu 12.04 again)
I have a new install of ubuntu 14.04 and fresh installation of EhcpForce and i have this error:
Apr 27 13:11:16 server1 postfix/smtpd[3324]: connect from h.xxxxx.com[94.23.xxx.xxx]
Apr 27 13:11:17 server1 postfix/smtpd[3324]: warning: hash:/var/lib/pop-before-smtp/hosts is unavailable. open database /var/lib/pop-before-smtp/hosts.db: Invalid argument
Apr 27 13:11:17 server1 postfix/smtpd[3324]: warning: hash:/var/lib/pop-before-smtp/hosts: table lookup problem
Apr 27 13:11:17 server1 postfix/smtpd[3324]: NOQUEUE: reject: RCPT from h.xxxxx.com[94.23.xxx.xxx]: 451 4.3.5 <h.xxxxx.com[94.23.xxx.xxx]>: Client host rejected: Server configuration error; from=<bounce1-xxxxx=xxxxx.com.ar@xxxxxxx.org> to=<xxxx@xxxx.com.ar> proto=ESMTP helo=<h.xxxxx.com>
Apr 27 13:11:17 server1 postfix/smtpd[3324]: disconnect from h.xxxxx.com[94.23.xxx.xxx]
Try in ubuntu 12.04?
No i did not configure it to my knowledge I am new to Linux bin on windows for way to long.
I have enabled RD with root access as asked and sent you a email back with pass word
Again thank you for your help Brittany