phpMyAdmin installation

Discussion in 'Installation/Configuration' started by el-sid, Jul 30, 2008.

  1. el-sid

    el-sid New Member

    hi
    i was trying to install php my admin by following its install instructions by

    Code:
     tar -zxvf phpMyAdmin-2.11.7.1-english.tar.gz -C /var/www/html/
     mv phpMyAdmin-2.11.7.1-english/ phpadmin
     cp -p config.sample.inc.php config.inc.php
    
    on the config.inc.php
    my file looks like

    Code:
    <?php
    /* vim: set expandtab sw=4 ts=4 sts=4: */
    /**
     * phpMyAdmin sample configuration, you can use it as base for
     * manual configuration. For easier setup you can use scripts/setup.php
     *
     * All directives are explained in Documentation.html and on phpMyAdmin
     * wiki <http://wiki.cihar.com>.
     *
     * @version $Id: config.sample.inc.php 10142 2007-03-20 10:32:13Z cybot_tm $
     */
    
    /*
     * This is needed for cookie based authentication to encrypt password in
     * cookie
     */
    //$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
    
    /*
     * Servers configuration
     */
    $i = 0;
    
    /*
     * First server
     */
    $i++;
    /* Authentication type */
    //$cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysql';
    /* User for advanced features */
    $cfg['Servers'][$i]['controluser'] = 'mydb_username';
    $cfg['Servers'][$i]['controlpass'] = 'mydb_password';
    /* Advanced phpMyAdmin features */
    // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
    // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
    // $cfg['Servers'][$i]['relation'] = 'pma_relation';
    // $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
    // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
    // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
    // $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
    // $cfg['Servers'][$i]['history'] = 'pma_history';
    // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
    
    /*
     * End of servers configuration
     */
    
    /*
     * Directories for saving/loading files from server
     */
    $cfg['UploadDir'] = '';
    $cfg['SaveDir'] = '';
    
    ?>
    
    then i opened my browser and typed

    http://localhost/phpadmin

    but i get the document tree of the phpadmin directory

    when i use the second method-wizard installation
    i get the 404 apache error when i type http://localhost/phpadmin/scripts/setup.php

    anyone knows how to fix this please
    thanks in advance
     
    Last edited: Jul 30, 2008
  2. Ben

    Ben HowtoForge Supporter

    I always use the setup method.
    So at first you should check, why you get this 404 (acces_log / error_log of apache).
    Either the path seems to be wrong, you got a typo, or file is really missing. In the last case I'd suggest redownloading the phpMyAdmin-Version.
    On the other side you may redownload anyway, because it's already outdated ;)

    Please make sure when running setup, that the folder "config" is writable for the time you run setup.php
     
  3. el-sid

    el-sid New Member

    thanks alot. it worked.
    yes yes i downloaded an updated version:D

    however when i try to log in it gives me an error
    The configuration file now needs a secret passphrase (blowfish_secret).

    i tried modifying this through features-security
    but the error doesnt go away
     
  4. Ben

    Ben HowtoForge Supporter

    did you resave the config and copy it to the topdir of phpmyadmin and remove the config folder?

    In my case (just updated after posting here ;) ) it directly created the blowfish secret.

    Or just edit config.inc.php and look for
    $cfg['blowfish_secret']

    This line should look like this
    if you do not find this line, just add it and save.
     
  5. el-sid

    el-sid New Member

    i forgot that little detail. thanks alot. everything's workin smoothly
     

Share This Page