We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

[Resolved] [0.9.5.x Installation] Db connection problems

    • 15091
    • 5 Posts
    justG Reply #1, 20 years ago
    I did try a search of the forums before posting this, but was not able to find a solution. Forgive me if it has been addressed ad nauseam.

    I am trying to install MODx 0.9.5 beta5-rev1785.

    [table]
    [tr]
    [td]Web server:[/td]
    [td]Apache 1.3.37[/td]
    [/tr]
    [tr]
    [td]PHP version:[/td]
    [td]4.4.4[/td]
    [/tr]
    [tr]
    [td]MySQL version:[/td]
    [td]4.1.21[/td]
    [/tr]
    [tr]
    [td]Browser name and version:[/td]
    [td]Firefox 1.5.x (XP)[/td]
    [/tr]
    [tr]
    [td][/td]
    [td]Camino ver. 2006102101 (1.1a1+) (OS X)[/td]
    [/tr]
    [tr]
    [td]OS/version:[/td]
    [td]XP Pro SP2[/td]
    [/tr]
    [/table]

    The XP box is my local dev server. I first tried the installation without any preparation. When that didn’t work, I created database modx, created user admin, and granted admin all privileges on that db. No matter what I do, though, I am told that the connection to the host has failed. I’ve tried as "localhost" and I’ve also tried my internal and external IP addresses. I had no trouble with my Movable Type or WordPress installations, for both of which I also created a db beforehand.

    Another user experiencing this problem (there’s a post from back in Jan or Apr 2006) resolved the issue by installing PHP5, I think, but the reason I have MySQL 4.x, PHP 4.x, and Apache 1.3x is because I duplicated my host’s environment as closely as I could so that I wouldn’t get any nasty surprises when I went from dev to production. I would like to sort this without resorting to upgrading PHP (can both be installed in parallel?, I dunno), but will do so if that’s my only option.

    Thanks for your help!
      • 25663 MODX Staff
      • 12,272 Posts
      Ryan Thrash Reply #2, 20 years ago
      Try 127.0.0.1 for the DB connection (the loopback IP), as that’s what I’ve got to use on my localhost installs, although on OS X.
        Ryan Thrash, MODX Co-Founder
        Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
        • 15091
        • 5 Posts
        justG Reply #3, 20 years ago
        Thank you for the ridiculously fast response. =) Unfortunately, that didn’t work either. =(
          • 7923
          • 4,213 Posts
          doze Reply #4, 20 years ago
          Do you use the default port number in your mysql database server? If not, use 127.0.0.1:12345 as the database server address where 12345 is the correct port number. You could also try with small php script to see if it can connect:

          <?php
mysql_connect("127.0.0.1", "admin", "password") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("modx") or die(mysql_error());
echo "Connected to Database";
?>


            "He can have a lollipop any time he wants to. That's what it means to be a programmer."
            • 15091
            • 5 Posts
            justG Reply #5, 20 years ago
            Thanks for the help! I am indeed using the default port for MySQL. When I attempted to run the PHP script you provided, I got:

            "Client does not support authentication protocol requested by server; consider upgrading MySQL client."

            I read this article over at mysql.com, but I really don’t understand what it’s saying about updating the client binary. I’m using the "out of the box" versions of everything, and the default is already newer than v4.1, so... *scratches head*
              • 25663 MODX Staff
              • 12,272 Posts
              Ryan Thrash Reply #6, 20 years ago
              You might consider trying XAMPP rather than rolling your own under Windows. That can be very tricky.
                Ryan Thrash, MODX Co-Founder
                Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
                • 15091
                • 5 Posts
                justG Reply #7, 19 years, 11 months ago
                That’s not really a viable solution. I have a had a perfectly working dev environment for years, and it doesn’t really make sense to install a "boxed" solution just to try MODx. What I’m failing to understand is why MODx has a problem where my other stuff (Movable Type, WordPress) does not. Surely there is a way to get around this?
                  • 25663 MODX Staff
                  • 12,272 Posts
                  Ryan Thrash Reply #8, 19 years, 11 months ago
                  Actually, that particular version of MySQL has caused more than a few problems. I don’t have any other suggestions for you sadly, but I’m sure it’s a simple oversight in the install SQL files. You might dig through those to see if you can find the offending culprit.
                    Ryan Thrash, MODX Co-Founder
                    Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
                    • 15091
                    • 5 Posts
                    justG Reply #9, 19 years, 11 months ago
                    Solution:

                    - Start > Run > cmd
                    - At command prompt, type 
                    mysql -uroot -p

                    - Then, 
                    mysql> SET PASSWORD FOR 
        -> some_user@some_host = OLD_PASSWORD('newpwd');


                    These things are always so much simpler than they appear to be, eh? All is well now. Hope this helps another newbie down the road. =)

                    Thanks, Ryan and doze, for trying to help. I appreciate it!
                      • 7923
                      • 4,213 Posts
                      doze Reply #10, 19 years, 11 months ago
                      Great that you got it resolved.. What a weird error message from MySQL if it was just a password issue undecided


                        "He can have a lollipop any time he wants to. That's what it means to be a programmer."