Professional Web Applications Themes

#39509 [NEW]: mySQL without InnoDB - PHP Bugs

From: tinu at humbapa dot ch Operating system: Linux PHP version: 5CVS-2006-11-14 (CVS) PHP Bug Type: MySQL related Bug description: mySQL without InnoDB Description: ------------ my mysql-server is running without innodb (skip-innodb in my.cnf). with php 5.1.6 this worked fine. when I try the same with the latest php from cvs (or 5.2.0) I get an error message about innodb... do I always have to enable innodb with php >5.1.6 ? Reproduce code: --------------- <? mysql_connect('localhost', 'root', 'anypassword'); ?> Expected result: ---------------- connect to mysql or show at least some error messages... Actual result: -------------- the page wont't load. my ...

  1. #1

    Default #39509 [NEW]: mySQL without InnoDB

    From: tinu at humbapa dot ch
    Operating system: Linux
    PHP version: 5CVS-2006-11-14 (CVS)
    PHP Bug Type: MySQL related
    Bug description: mySQL without InnoDB

    Description:
    ------------
    my mysql-server is running without innodb (skip-innodb in my.cnf).

    with php 5.1.6 this worked fine.

    when I try the same with the latest php from cvs (or 5.2.0) I get an error
    message about innodb...

    do I always have to enable innodb with php >5.1.6 ?

    Reproduce code:
    ---------------
    <?
    mysql_connect('localhost', 'root', 'anypassword');
    ?>

    Expected result:
    ----------------
    connect to mysql or show at least some error messages...

    Actual result:
    --------------
    the page wont't load.
    my apache error-log contains:
    061114 13:27:57 [Warning] Can't create test file
    /var/lib/mysql/hostname.lower-test
    061114 13:27:57 InnoDB: Operating system error number 13 in a file
    operation.


    --
    Edit bug report at [url]http://bugs.php.net/?id=39509&edit=1[/url]
    --
    Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=39509&r=trysnapshot44[/url]
    Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=39509&r=trysnapshot52[/url]
    Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=39509&r=trysnapshot60[/url]
    Fixed in CVS: [url]http://bugs.php.net/fix.php?id=39509&r=fixedcvs[/url]
    Fixed in release: [url]http://bugs.php.net/fix.php?id=39509&r=alreadyfixed[/url]
    Need backtrace: [url]http://bugs.php.net/fix.php?id=39509&r=needtrace[/url]
    Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=39509&r=needscript[/url]
    Try newer version: [url]http://bugs.php.net/fix.php?id=39509&r=oldversion[/url]
    Not developer issue: [url]http://bugs.php.net/fix.php?id=39509&r=support[/url]
    Expected behavior: [url]http://bugs.php.net/fix.php?id=39509&r=notwrong[/url]
    Not enough info: [url]http://bugs.php.net/fix.php?id=39509&r=notenoughinfo[/url]
    Submitted twice: [url]http://bugs.php.net/fix.php?id=39509&r=submittedtwice[/url]
    register_globals: [url]http://bugs.php.net/fix.php?id=39509&r=globals[/url]
    PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=39509&r=php3[/url]
    Daylight Savings: [url]http://bugs.php.net/fix.php?id=39509&r=dst[/url]
    IIS Stability: [url]http://bugs.php.net/fix.php?id=39509&r=isapi[/url]
    Install GNU Sed: [url]http://bugs.php.net/fix.php?id=39509&r=gnused[/url]
    Floating point limitations: [url]http://bugs.php.net/fix.php?id=39509&r=float[/url]
    No Zend Extensions: [url]http://bugs.php.net/fix.php?id=39509&r=nozend[/url]
    MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=39509&r=mysqlcfg[/url]
    tinu at humbapa dot ch Guest

  2. #2

    Default #39509 [Opn->Bgs]: mySQL without InnoDB

    ID: 39509
    Updated by: [email]tony2001php.net[/email]
    Reported By: tinu at humbapa dot ch
    -Status: Open
    +Status: Bogus
    Bug Type: MySQL related
    Operating System: Linux
    PHP Version: 5CVS-2006-11-14 (CVS)
    New Comment:

    Sorry, but your problem does not imply a bug in PHP itself. For a
    list of more appropriate places to ask for help using PHP, please
    visit [url]http://www.php.net/support.php[/url] as this bug system is not the
    appropriate forum for asking support questions. Due to the volume
    of reports we can not explain in detail here why your report is not
    a bug. The support channels will be able to provide an explanation
    for you.

    Thank you for your interest in PHP.

    PHP provides just an interface, it doesn't require anything.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-11-14 12:46:07] tinu at humbapa dot ch

    Description:
    ------------
    my mysql-server is running without innodb (skip-innodb in my.cnf).

    with php 5.1.6 this worked fine.

    when I try the same with the latest php from cvs (or 5.2.0) I get an
    error message about innodb...

    do I always have to enable innodb with php >5.1.6 ?

    Reproduce code:
    ---------------
    <?
    mysql_connect('localhost', 'root', 'anypassword');
    ?>

    Expected result:
    ----------------
    connect to mysql or show at least some error messages...

    Actual result:
    --------------
    the page wont't load.
    my apache error-log contains:
    061114 13:27:57 [Warning] Can't create test file
    /var/lib/mysql/hostname.lower-test
    061114 13:27:57 InnoDB: Operating system error number 13 in a file
    operation.



    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=39509&edit=1[/url]
    tony2001@php.net Guest

  3. #3

    Default #39509 [Bgs]: mySQL without InnoDB

    ID: 39509
    User updated by: tinu at humbapa dot ch
    Reported By: tinu at humbapa dot ch
    Status: Bogus
    Bug Type: MySQL related
    Operating System: Linux
    PHP Version: 5CVS-2006-11-14 (CVS)
    New Comment:

    just in case someone else has the same problem... :-)

    I configured php with --enable-embedded-mysqli
    removing this option solved my problem.

    why mysql_connect() conflicts with this option I
    have no idea.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-11-14 12:58:24] [email]tony2001php.net[/email]

    Sorry, but your problem does not imply a bug in PHP itself. For a
    list of more appropriate places to ask for help using PHP, please
    visit [url]http://www.php.net/support.php[/url] as this bug system is not the
    appropriate forum for asking support questions. Due to the volume
    of reports we can not explain in detail here why your report is not
    a bug. The support channels will be able to provide an explanation
    for you.

    Thank you for your interest in PHP.

    PHP provides just an interface, it doesn't require anything.

    ------------------------------------------------------------------------

    [2006-11-14 12:46:07] tinu at humbapa dot ch

    Description:
    ------------
    my mysql-server is running without innodb (skip-innodb in my.cnf).

    with php 5.1.6 this worked fine.

    when I try the same with the latest php from cvs (or 5.2.0) I get an
    error message about innodb...

    do I always have to enable innodb with php >5.1.6 ?

    Reproduce code:
    ---------------
    <?
    mysql_connect('localhost', 'root', 'anypassword');
    ?>

    Expected result:
    ----------------
    connect to mysql or show at least some error messages...

    Actual result:
    --------------
    the page wont't load.
    my apache error-log contains:
    061114 13:27:57 [Warning] Can't create test file
    /var/lib/mysql/hostname.lower-test
    061114 13:27:57 InnoDB: Operating system error number 13 in a file
    operation.



    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=39509&edit=1[/url]
    tinu at humbapa dot ch Guest

Similar Threads

  1. Replies: 0
    Last Post: August 24th, 10:13 AM
  2. Is InnoDB dead?
    By howachen@gmail.com in forum MySQL
    Replies: 3
    Last Post: June 15th, 11:14 PM
  3. Question on MySQL 5 and innodb
    By JoeT in forum MySQL
    Replies: 0
    Last Post: May 9th, 11:17 PM
  4. Replies: 4
    Last Post: February 4th, 10:54 AM
  5. CFMX7 - MySQL 4.0 - INNODB table type
    By drmaves in forum Coldfusion Database Access
    Replies: 2
    Last Post: September 23rd, 04:26 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139