Professional Web Applications Themes

CFMX 6.1 and MySQL 5.0.27 JDBC issues - Coldfusion Database Access

Removed by Administrator...

  1. Moderated Post

    Default CFMX 6.1 and MySQL 5.0.27 JDBC issues

    Removed by Administrator
    carlosmojo Guest
    Moderated Post

  2. #2

    Default Re: CFMX 6.1 and MySQL 5.0.27 JDBC issues

    ok, I somewhat got this working. Here is what was happening.

    It turned out CF was trying to read the databases in a /usr/local/
    mysql5/data, when I had them installed in /var/lib/mysql. I find this
    weird, because other clients I used (mysql command line, Query Browser
    and Adminsitrator), had no problems connecting to the same exact
    databases. I created symbolic links to each of the databases from /
    usr/local/mysql5/data to /var/lib/mysql and it started working. I
    have a theory right now that it has to do with the /tmp/mysql.sock
    file and i change it to use /tmp/mysql5.sock, but i don't care testing
    this at the moment.

    Anyway, this was 2 days ago. Today I started running into long running
    query problems that were timing out my scripts. This actually happened
    yesterday too, but they went away after I shut off query cache and
    innodb. I couldn't figure out what was wrong today, so I decided to
    revert back to an older driver mysql-connector-java-3.0.17-ga-bin.jar
    and now everything seems to be running ok again. I'm going to try
    using the 3.1 drivers when there is less traffic on the servers
    tonight, and hopefully they will be fine.


    cvazquez Guest

  3. #3

    Default Re: CFMX 6.1 and MySQL 5.0.27 JDBC issues

    I figured out what was happening, but I'm still not sure why.

    It turned out CF was trying to read the databases in /usr/local/mysql5/data,
    when I had them installed in /var/lib/mysql. I find this weird, because other
    clients I used (mysql command line, Query Browser and Adminsitrator), had no
    problems connecting to the same exact databases. I created symbolic links to
    each of the databases from /usr/local/mysql5/data to /var/lib/mysql and it
    started working. I have a theory right now that it has to do with the
    /tmp/mysql.sock file, because i change it to use /tmp/mysql5.sock and i think
    CF is trying to use the former, but i don't care testing this at the moment.

    Anyway, this was 2 days ago. Today I started running into long running query
    problems that were timing out my scripts. This actually happened yesterday too,
    but they went away after I shut off query cache and innodb. I couldn't figure
    out what was wrong today, so I decided to revert back to an older driver
    mysql-connector-java-3.0.17-ga-bin.jar and now everything seems to be running
    ok again.

    I'm going to try using the 3.1 drivers when there is less traffic on the
    servers tonight, and hopefully they will be fine. Then i'll try turning the
    other stuff back on i turned off in mysql.

    I wish I had some more luck with the 5.0.4 drivers. I'll try to followup
    later on with my findings.

    carlosmojo Guest

Similar Threads

  1. jTDS JDBC drivers with CFMX 7 Enterprise
    By MARMC WebMaster in forum Coldfusion Database Access
    Replies: 4
    Last Post: April 12th, 05:27 PM
  2. Informix 10 & CFMX 6.1 & JDBC
    By cfperson in forum Coldfusion Database Access
    Replies: 8
    Last Post: January 4th, 05:06 PM
  3. jdbc pool fail on cfmx 6.1 with jrun
    By EOIN HICKEY in forum Coldfusion Database Access
    Replies: 1
    Last Post: September 13th, 05:22 PM
  4. Installing DB2 JDBC Driver on CFMX 6.1 Standard
    By chuckjody in forum Coldfusion Server Administration
    Replies: 5
    Last Post: March 16th, 07:49 PM
  5. JDBC driver problem w/ CFMX 7
    By Steve Grosz in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 22nd, 05:06 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