MoonPoint Support Logo


Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals

Advanced Search
Sun Mon Tue Wed Thu Fri Sat

Sun, Aug 08, 2010 8:12 pm

Determining Who Voted for Which Option in an SMF Poll

If you are using polls in a Simple Machines Forum (SMF) forum, it is possible to determine who voted for which option in a poll by using phpMyAdmin or by entering MySQL commands.

[More Info ]

[/network/web/forums/smf] permanent link

Sun, Aug 08, 2010 5:36 pm

Installing phpMyAdmin on a CentOS System Running Apache

To install phpMyAdmin on a CentOS system running an Apache webserver, login as root and issue the command yum install phpmyadmin from a command prompt.

Note: you may have to install the Remi Repository or the RPMForge Repository to be able to locate and install phpMyAdmin. Instructions for configuring yum to use one of those repositories can be found via the links below.

Remi Repository
RPMForge Repository

After installing the software you will need to restart Apache, which you can do with apachectl restart or service httpd restart . You can then try accessing phpMyAdmin by substituting your domain name or IP address for

If you receive a "403 Forbidden" error with the message "You don't have permission to access /phpmyadmin on this server.", it is likely because you are attempting to access the software from outside of the server itself. The orginal phpmyadmin.conf file contains the lines below:

#  Web application to manage MySQL

<Directory "/usr/share/phpmyadmin">
  Order Deny,Allow
  Deny from all
  Allow from

Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin

The Deny from all line states that the default behavior is to prevent any IP address from accessing phpMyAdmin. The next line, Allow from provides for the exception of accessing the software from the server itself, i.e., the "localhost" address You could change the "deny from all" to "allow from all" to allow access from anywhere or put a "#" at the beginning of the line to comment it out. Or, you could add additional IP addresses or FQDN's after the to allow access to phpMyAdmin from other systems. E.g. you could change the line to Allow from 192.168 to also allow access from any IP address beginning with 192.168. Restart Apache again.

If you then try accessing phpMyAdmin, e.g., you might use, if was your webserver's IP address, but get the error message The configuration file now needs a secret passphrase (blowfish_secret). then you need to edit /usr/share/phpmyadmin/ Look for the following lines:

 * This is needed for cookie based authentication to encrypt password in
 * cookie
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Place a password between the two single quotes, e.g., you could have a password of SomeGoodPassword with the following:

$cfg['blowfish_secret'] = 'SomeGoodPassword';

If you refresh the webpage, you should then see a phpMyAdmin login window where you are prompted to enter a username and password, which should be the mysql root account and it's password.

For further information on phpMyAdmin and MySQL, there is a book by Marc Delisle, Mastering phpMyAdmin for Effective MySQL Management.


  1. phpMyAdmin
  2. RPMForge Packages and Yum Priorites
    Date: May 3, 2008
    MoonPoint Support
  3. Remi Repository
    Antoine Solutions Development A Free PHP IDE built on Open Source Software
  4. Quick 'n' Easy LAMP Server For CentOS/RHEL
    By: olddocks
    Date: May 28, 2008
    HowtoForge - Linux Howtos and Tutorials

[/network/web/tools/phpmyadmin] permanent link

Sun, Aug 08, 2010 1:45 pm

Restricting Access to an Apache Virtual Host

To restrict access to an Apache Virtual Host by IP address, you will need to have the mod_authz_host module loaded in the Apache configuration file httpd.conf, which can usually be found at /etc/httpd/conf/httpd.conf on a Linux system. To determine if it is loaded, look for a line similar to the following in the configuration file:

LoadModule authz_host_module modules/

You can restrict access to a website that is set up as a virtual host by including information on what IP addresses should have access to documents on the website in a directory section Directory as shown below.

<VirtualHost *:80>
    DocumentRoot /home/www/example
    ErrorLog /home/www/example/logs/error.log
    CustomLog /home/www/example/logs/transfer.log common
    <Directory /home/www/example>
      Order Deny,Allow
      Deny from all
      Allow from 192.168

In the case above, access to the document root of the website, i.e., all documents on the website, is restricted to allow access only from IP addresses beginning with 192.168 and, which is the "localhost" address, meaning the address of the server itself. Anyone trying to access from any other IP address would see the default webpage for the server, if any, not the website.


  1. Access Control
    The Apache HTTP Server Project
  2. Apache Module mod_authz_host
    The Apache HTTP Server Project
  3. Learn how to configure Apache
    Date: September 29, 2003
    TechRepublic Articles

[/network/web/server/apache] permanent link

Once You Know, You Newegg AliExpress by

Shop Amazon Local - Subscribe to Deals in Your Neighborhood

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo