Previous Next

Thread: phpmyadmin problems on IIS7

Last post 01-13-2008 3:44 PM by Cooooper. 13 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (14 items)

Sort Posts:

  • 05-30-2007, 2:12 PM

    • Tudy
    • Not Ranked
    • Joined on 05-10-2005, 7:13 PM
    • Cluj-Napoca, Romania
    • Posts 7
    • Tudy

    phpmyadmin problems on IIS7

    Hy everybody.

     I've just installed PHP and MySQL on an IIS7 on Longhorn. And now, phpmyadmin.

    The phpmyadmin has some errors, which I think, are from... IIS7 (well, i forgot to say that i'm not so good in iis... i'm just a beginner).

    I will write the errors down here:

    Can not load or save configuration

    Please create web server writable folder config in phpMyAdmin toplevel directory as described in documentation. Otherwise you will be only able to download or display it.

    Not secure connection

    You are not using secure connection, all data (including sensitive, like passwords) are transfered unencrypted! If your server is also configured to accept HTTPS request follow this link to use secure connection.
     
    and also some PHP warnings:
     
    Warning: Unknown: open(C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp\\sess_c1b762e199366266cf1a75ecf038523c, O_RDWR) failed: Permission denied (13) in Unknown on line 0

    Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0
     
     
    Can anybody help me with these? Thank you very much, 

     

     

     

  • 05-30-2007, 2:34 PM In reply to

    • bills
    • Top 10 Contributor
    • Joined on 02-03-2006, 5:33 PM
    • Redmond, WA
    • Posts 422
    • bills

    Re: phpmyadmin problems on IIS7

  • 05-30-2007, 4:11 PM In reply to

    • Tudy
    • Not Ranked
    • Joined on 05-10-2005, 7:13 PM
    • Cluj-Napoca, Romania
    • Posts 7
    • Tudy

    Re: phpmyadmin problems on IIS7

    I've made what there said but ... same errors ...:( 

  • 05-30-2007, 4:18 PM In reply to

    • Tudy
    • Not Ranked
    • Joined on 05-10-2005, 7:13 PM
    • Cluj-Napoca, Romania
    • Posts 7
    • Tudy

    Re: phpmyadmin problems on IIS7

    And... i made a folder 'config', in IIS Manager at Default Web Site, i've selected full permission for IIS User at phpmyadmin/config ... 

     And I have the same errors...
     

  • 05-31-2007, 10:51 PM In reply to

    • rickjames
    • Top 25 Contributor
    • Joined on 10-31-2006, 6:43 PM
    • Posts 193
    • rickjames

    Re: phpmyadmin problems on IIS7

    Hi Tudy,

    Here is what I did to get phpmyadmin working for me:

    0. php 5.2.3
    1. install mysql-essential-5.0.24a-win32.msi
    2. extract phpMyAdmin-2.8.2.2.zip to D:\inetpub\wwwroot\phpmyadmin
    3. start - run - inetmgr - default web site - right-click phpmyadmin - convert to application
    4. php.ini updates:
    extension_dir = "d:\php\ext"
    uncomment extensions: php_mbstring.dll, php_mysql.dll
    session.save_path = "D:\temp\phpsessions\phpmyadmin"
    5. create D:\temp\phpsessions\phpmyadmin, give "network service" full access
    6. update config: D:\inetpub\wwwroot\phpmyadmin>type config.inc.php
    <?php
    $cfg['blowfish_secret'] = 'ba17c1ec07d65003';  // use here a value of your choice

    $i=0;
    $i++;
    $cfg['Servers'][$i]['auth_type']     = 'cookie';
    ?>

    Cheerz,

    Rick.

  • 06-01-2007, 8:46 AM In reply to

    • Tudy
    • Not Ranked
    • Joined on 05-10-2005, 7:13 PM
    • Cluj-Napoca, Romania
    • Posts 7
    • Tudy

    Re: phpmyadmin problems on IIS7

    Thanks, Rick.

     Well... it's better now but I still have some errors after I type user and password in phpmyadmin:

     
    Warning: session_write_close() [function.session-write-close]: open(C:\inetpub\temp\sessions\sess_c1b762e199366266cf1a75ecf038523c, O_RDWR) failed: Permission denied (13) in C:\inetpub\wwwroot\phpmyadmin\libraries\common.lib.php on line 1065

    Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\inetpub\temp\sessions) in C:\inetpub\wwwroot\phpmyadmin\libraries\common.lib.php on line 1065

    #0  PMA_sendHeaderLocation(http://localhost/phpmyadmin/index.php?lang=en-utf-8&token=63ae255b172d0657bae2ef6621db26cd) called at [C:\inetpub\wwwroot\phpmyadmin\libraries\auth\cookie.auth.lib.php:488]
    #1 PMA_auth_set_user() called at [C:\inetpub\wwwroot\phpmyadmin\libraries\common.lib.php:3149]
    #2 require_once(C:\inetpub\wwwroot\phpmyadmin\libraries\common.lib.php) called at [C:\inetpub\wwwroot\phpmyadmin\index.php:36]

    Fatal error: PMA_sendHeaderLocation called when headers are already sent! in C:\inetpub\wwwroot\phpmyadmin\libraries\common.lib.php on line 1072


     

    What should I do now?

     

  • 06-01-2007, 8:48 AM In reply to

    • Tudy
    • Not Ranked
    • Joined on 05-10-2005, 7:13 PM
    • Cluj-Napoca, Romania
    • Posts 7
    • Tudy

    Re: phpmyadmin problems on IIS7

     Well.... I've put the session.save_path at the C:\inetpub\temp\sessions :)

     

    Thank you very much. 

  • 06-01-2007, 8:59 AM In reply to

    • Tudy
    • Not Ranked
    • Joined on 05-10-2005, 7:13 PM
    • Cluj-Napoca, Romania
    • Posts 7
    • Tudy

    Re: phpmyadmin problems on IIS7

    OMG! I've resolved this problem.... I think!

     Well, I've selected the C:\inetpub\temp\sessions folder and I gave full permissions for usrs IIS_IUSR, IUSR, IUSR_SERVER ... (something like this and now I can access the phpmyadmin :D)

     
    Thanks very much to all of you :)
     

  • 12-02-2007, 6:29 AM In reply to

    • abytes
    • Top 150 Contributor
    • Joined on 12-02-2007, 11:20 AM
    • Posts 22
    • abytes

    phpmyadmin problems on IIS7

    i have php and mysql running on iis7 vista ultimate i run databases in xampp for few my web sites on other machine thats running xampp.Would love to run all on iis.. i am having trouble getting phpmyadmin working being new to this iis thing when i go to open localhost/phpmhadmin/index.php or even localhost/phpmyadmin i get this on the page

    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.

    can some one help please
  • 12-02-2007, 12:38 PM In reply to

    • Tudy
    • Not Ranked
    • Joined on 05-10-2005, 7:13 PM
    • Cluj-Napoca, Romania
    • Posts 7
    • Tudy

    Re: phpmyadmin problems on IIS7

    Isn't the same think like mine? Go and check the php.ini session settings and give accesses to that folder.

     

  • 12-02-2007, 10:44 PM In reply to

    • abytes
    • Top 150 Contributor
    • Joined on 12-02-2007, 11:20 AM
    • Posts 22
    • abytes

    Re: phpmyadmin problems on IIS7

    ok i got it to open and loged in but when i go to open a datebase ion left side it does not open to right side like on xamp for could be cuasing this? and thank you tudy it worked just cant open my databases now any sugestions?

  • 12-03-2007, 3:37 PM In reply to

    • abytes
    • Top 150 Contributor
    • Joined on 12-02-2007, 11:20 AM
    • Posts 22
    • abytes

    Re: phpmyadmin problems on IIS7

    now im getting this error soe one please tell me how to fix it....

    Error

    MySQL said: Documentation

    #1045 - Access denied for user 'root'@'localhost' (using password: NO)

  • 12-06-2007, 4:06 AM In reply to

    • brashquido
    • Top 25 Contributor
    • Joined on 05-22-2006, 12:31 AM
    • Australia
    • Posts 153
    • IIS MVPs
    • brashquido

    Re: phpmyadmin problems on IIS7

    That is an authentication error. Double check your credentials and try again. If you are still having trouble you could try having a look at a guide I wrote on how to install and configure phpMyAdmin on IIS. It assumes you already have PHP and MySQL up and running, but should be of some use for the more common phpMyAdmin configuration directives.

    ----------------
    Dominic Ryan
    Microsoft IIS MVP
    www.iis-aid.com
    My IIS articles
    My PHP articles
    My How-to guides
  • 01-13-2008, 3:44 PM In reply to

    • Cooooper
    • Not Ranked
    • Joined on 01-13-2008, 3:37 PM
    • Posts 1
    • Cooooper

    Re: phpmyadmin problems on IIS7

    hi guys

    thanx 4 all the advice/help 2 date have followed all the instructions listed above, and manged 2 get IIS7, MYSQL 4.0.12, PHP 5.2.0 all 2 run on windows Vista Home Premium. My problem how ever comes in with phpmyadmin, i get most of it to work except when ever i try browse a database i get the following msg

    PHP has encountered an Access Violation at 036F656C //

    in top of screen and 5 or 6 random charatrer in the place were data should be listed....
     
    any ideas on why this is haoppening or better yet how 2fix it would be great
     
    Thanx
Page 1 of 1 (14 items)
Page view counter