So, I following the phpMyAdmin specifics from the php 5.3 to 5.5 thread (copied below) and I am unable to perform an expand-template (it fails with an error: ERROR: No templates were found for /etc/phpmyadm/config.inc.php.) and I get "Error #1045: Can not log in to My SQL Server". if I try to log in through the website.
What am I missing??
This is copied from the original thread:
To make phpMyAdmin usable:
1) Create a new ibay specifically for phpMyAdmin (I would suggest calling it phpmyadmin) and set it with the appropriate access permissions being sure to enable dynamic content (i.e. PHP). Then delete the index.html file from the html folder of this new ibay.
2) Load the complete phpMyAdmin file set you've just downloaded into the html folder of the new ibay. The root directory for phpMyAdmin should be the ibay's html folder so load the entire CONTENTS of the phpMyAdmin folder you've downloaded into it and not the phpMyAdmin folder itself.
3) Create a new folder in /etc called phpMyAdmin and set permissions on it to at least 775.
4) Create a folder in /etc/e-smith/templates-custom named phpMyAdmin and then inside that create a folder named config.inc.php
5) Inside the new /etc/e-smith/templates-custom/phpMyAdmin/config.inc.php folder create three files, an EMPTY file named template-begin, an EMPTY file named template-end and one other file (I used the "10config" name used by the smeserver-phpmyadmin contribution where this comes from) containing the following:
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.9.0.2 setup script by Michal Čihař <michal@cihar.com>
* Version: $Id: setup.php,v 1.36.2.3.2.1 2006/10/03 13:11:08 nijel Exp $
* Date: Thu, 12 Oct 2006 16:17:17 GMT
*/
/* Servers configuration */
$i = 0;
/* Server localhost (config:root) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '{
open (PW, "/etc/openldap/ldap.pw")
|| die "Could not read LDAP password.\n";
my $pw = <PW>;
chomp ($pw);
close PW;
$OUT .= "$pw";
}';
/* End of servers configuration */
?>
6) expand-template /etc/phpMyAdmin/config.inc.php
7) You should now have a config.inc.php inside the /etc/phpMyAdmin folder you created. If can figure out how to get your phpMyAdmin to directly access this file you are set to go. Otherwise, do like I did and just copy the password from the file and then log in to phpMyAdmin as root using this password. In that case the very first thing to do is create a new user with all privileges and a password you can remember to use for all future access to phpMyAdmin which you will access as
http://server_url/phpmyadmin_ibay_name/
4 Replies
1721 Views