Menu

PDO/MySQL is not installed

Help
2009-10-10
2013-05-30
  • Liam Congleton

    Liam Congleton - 2009-10-10

    I just installed the files downloaded and installed latest PHP looks like it's install of the PDO dat, however when I went  to my browser to continue the installation I get "PPDO/MySQL is not installed" In one of the forums they dicussed the possibility of adding 1 line to the php.ini file? I'm trying to run this on Windows 2003 Server.

     
  • Greg Roach

    Greg Roach - 2009-10-10

    These are the entries in my php.ini file.  The exact name of the DLL to load varies, and will depend on your installation.

    extension=php_pdo.dll
    extension=php_pdo_mysql_libmysql.dll
    extension=php_pdo_sqlite.dll

     
  • Liam Congleton

    Liam Congleton - 2009-10-10

    Windows 2003 Server; php-5.2.11; MySQL Server 5.0
    I added the above still have same error.

     
  • Greg Roach

    Greg Roach - 2009-10-10

    <<I added the above still have same error>>

    I didn't tell you to add these lines.  I told you that these were the lines in my file, and that yours would be *similar*.  The name of the DLL file is different on different installations.  I can't tell you what it is, but will probably start with php_pdo and probably end in .dll and probably have mysql somewhere in the middle.

    It is quite possible that your distribution doesn''t have the PDO/MySQL library.  Do you have MySQL?

     
  • Liam Congleton

    Liam Congleton - 2009-10-10

    Yes, MySQL Server 5.0

     
  • Greg Roach

    Greg Roach - 2009-10-10

    I've had a private email on this subject from a user who is unable to create a SF account.

    I am unfortunately unable to reply to him directly, as his mail-server is rejecting incoming mail from gmail.com.

    So, Lew, in case you are still reading the forum, here's what I tried to send to you.  Excuse the formatting.  Life is too short to reverse-engineer this forums markup language…..

    > I applied twice for a Sourceforge signon and haven't heard back so I am
    > unable to request support through normal means.

    It is several years since I applied for my SF account, but SF does
    appear to be struggling at the moment.  Performance of the forums,
    the SVN server, etc. is pretty lousy.

    If there was a better (free) alternative, we'd probably have moved
    the project already.

    > Server Data
    > cPanel 11.24.5-RELEASE 38506
    > PHP version 5.2.8
    > MySQL version 5.0.81-community
    >
    > I have two other products already running on the domain, both use MySQL
    > (Gallery and Wordpress).
    >
    > I don't know why it is giving me errors about MySQL when I haven't even had
    > a chance to give it my dB information?

    PHP applications talk to databases using an interface layer.  These
    provide varying levels of abstraction, so that applications don't need
    to know all the details about each different database.

    Until 4.2.1, used the Pear::DB interface.  This is widely distributed,
    and pretty much any host will have it installed by default.

    Gallery and Wordpress are either using Pear:DB (or possibly
    using their own custom interface layers).

    But Pear::DB is old, unsupported, doesn't support sqlite3 (which severely
    limits the types of database queries we can make). It is also slow,
    doesn't support prepared queries, etc., etc.

    So, this year we switched to PDO.  PDO is a native part of PHP.

    Now, during the installation process, there are two errors.  The
    first is when PDO is not installed.  You are not getting this error,
    so I can presume you have it.  However, you also need a separate
    library/module for each database you have installed.  PGV uses
    MySQL by default, but if you don't have MySQL, but do have another
    interface, it will switch to that instead.  It is common to have
    PDO/SQLITE or PDO/PostGres installed but not PDO/MySQL.
    PGV will work happily in these situations.

    So, I presume you have PDO, but no specific database libraries.

    Installing it is generally as simple as adding a line to your php.ini file.
    (As I said in an earlier post today).

    If your host allows you to specify php.ini settings (via .htaccess files),
    then you can do this yourself.  Otherwise, you will need to ask your
    tech-support to do this for you.

    If they can't/won't, then you should be able to use PGV version 4.2.1

    Hope this helps,

    Greg

     
  • Greg Roach

    Greg Roach - 2009-10-10

    PS: Lew, your mail was rejected because your server is using a "black-list" service (chinanet.blackholes.us), which has listed googlemail.com as a "bad host".

    I guess you aren't receiving any mail from gmail addresses.  If you are unhappy with this, complain to your host.

     
  • Anonymous

    Anonymous - 2009-10-14

    Thanks for your help…let me leave a tip here for anyone who might encounter my problem

    Server is a cPanel configuration

    To add PDO, you can run EasyApache if you own/run the server.

    There is a choice towards the end where you enable PDO and PDO/MySQL.

    However, somehow my initial configuration was lost (there is a work around for this) and the server ended up defaulting to PHP4 which broke most if not all PHP scripts plus programs like Gallery and B2.

    Got the default PHP changed to 5 and life was wonderful, but now I have a new problem.  Thanks again Greg..

     

Log in to post a comment.