Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Nov 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PHP and phpMyAdmin help needed

    Please help with phpmyadmin

    I have been desperately trying to install PHPmyadmin for the last week but have failed miserably every time! I just want to install it on my local computer so that I can create databases etc etc locally.

    I have installed PHP successfully (which I have checked in my browser using a test page with the following php code: <?php phpinfo(); ?> )

    I have installed mysql successfully and have set a password. This seems to be working fine as well.

    I am working on Windows Vista 32-bit operating system, with IIS7 installed and have installed mysql 5, php 5.2.5 and am trying to install phpMyAdmin2.11.2.1.

    I have found some useful tutorials but then all of a sudden they don’t tell you exactly how to do something or refer to versions before 2.8 which had the config.inc.php file in the downloaded package. I even bought the book “Mastering phpMyAdmin 2.8” so that I could learn PHPmyadmin – the installation instructions in this book are not clear at all!

    Please please could someone help me:

    1. I have downloaded the .zip file and extracted all info to C:\inetpub\wwwroot\phpmyadmin.

    2. I have enabled these extensions in the php.ini file:
    ;extension=php_gd2.dll
    ;extension=php_mbstring.dll
    ;extension=php_mcrypt.dll
    ;extension=php_mysql.dll

    3. I then made a copy of config.sample.inc to config.inc.php

    4. I added these settings - my code now looks like this:

    <?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'] = 'SanDeRs55687'; /* 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'] = 'pma';
    $cfg['Servers'][$i]['controlpass'] = 'pmapass';

    /* 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'] = '';

    $cfg['docSQLDir'] = 'docsql';
    $cfg['ShowPhpInfo'] = true;
    $cfg['ShowChgPassword'] = true;
    $cfg['AllowArbitraryServer'] = false;
    $cfg['LoginCookieRecall'] = 'something';
    $cfg['LoginCookieValidity'] = 1800;
    $cfg['AllowAnywhereRecoding'] = true;
    $cfg['DefaultCharset'] = 'iso-8859-1';
    $cfg['RecodingEngine'] = 'iconv';
    $cfg['IconvExtraParams'] = '//TRANSLIT';
    $cfg['GD2Available'] = 'yes';

    ?>




    5. I then went to my browser and typed in http://localhost/phpmyadmin/index.php
    6. It comes up with this error message:

    phpMyAdmin - Error
    Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.


    7. I do not know where to find these log files and would not know how to read them either!
    8. Although my test file for PHP shows that it is installed and working, do you think I need to re-install it and if so what are the instructions for installing PHP on IIS7? (Because this is where I could have gone wrong…
    9. Pleeeeeease help this is driving me crazy…. Any step by step solutions would be greatly appreciated!

    Many Thanks
    Louise

  • #2
    Senior Coder timgolding's Avatar
    Join Date
    Aug 2006
    Location
    Southampton
    Posts
    1,517
    Thanks
    114
    Thanked 110 Times in 109 Posts
    Have you considered WAMP/ LAMP
    You can not say you know how to do something, until you can teach it to someone else.

  • #3
    New to the CF scene
    Join Date
    Nov 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thanks I think I need to install WAMP otherwise I might waste even more days trying to install everything correctly. What is the difference between WAMP and WINLAMP and what do you recommend?

  • #4
    Senior Coder CFMaBiSmAd's Avatar
    Join Date
    Oct 2006
    Location
    Denver, Colorado USA
    Posts
    2,961
    Thanks
    2
    Thanked 305 Times in 297 Posts
    First, I recommend using the mysql GUI tools instead of phpmyadmin - http://dev.mysql.com/downloads/gui-tools/5.0.html

    Next, do you specifically want to use the IIS web server at this time or does the Apache web server meet your needs?

    I believe under IIS, PHP errors are written to the Windows event log. You can also modify php.ini to create an error log in the location of your choice.

    Based on the session error message, either the default session save path folder does not exist or the windows user account PHP is running under does not have proper permissions for the folder that is getting used. The error log will provide more specific info.

    A common problem with php installations is that the php.ini that you are making changes to is not the one that php is using. In your phpinfo() output, there are a couple of lines in the first section that state if and what the actual php.ini is that is being used. At least for Win XP, you must stop and start the IIS service (or reboot your computer) to get changes made to php.ini to take effect. Just stopping and starting the web site under the management console won't get changes made to php.ini to be read (at least when php is running as an ISAPI module.)

    Also in the phpinfo() output, check if the extensions you enabled are getting loaded (as will checking the error log.) This will tell you if the php.ini that you have been making changes to is actually getting used, if the extensions folder path setting in php.ini is correct, and if the extension .dll files are present and are getting found.

    For the mysql extension there are a couple of auxiliary .dll files. The easiest way to get these to be found, per the current php.net installation instructions, is to add the php folder to the Windows path statement (you must either reboot your computer or log off and back on to get changes made to the Windows path to take effect.)
    If you are learning PHP, developing PHP code, or debugging PHP code, do yourself a favor and check your web server log for errors and/or turn on full PHP error reporting in php.ini or in a .htaccess file to get PHP to help you.

  • #5
    Senior Coder timgolding's Avatar
    Join Date
    Aug 2006
    Location
    Southampton
    Posts
    1,517
    Thanks
    114
    Thanked 110 Times in 109 Posts
    I usually just type WAMP in to google and click download.
    You can not say you know how to do something, until you can teach it to someone else.

  • #6
    Super Moderator Inigoesdr's Avatar
    Join Date
    Mar 2007
    Location
    Florida, USA
    Posts
    3,638
    Thanks
    2
    Thanked 404 Times in 396 Posts
    Quote Originally Posted by louisesanders View Post
    what do you recommend?
    I usually recommend XAMPP.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •