Database Help

Discussion in 'Installation' started by cjscrofani, Oct 22, 2010.

  1. cjscrofani

    cjscrofani New Member

    Joined:
    Sep 30, 2010
    Messages:
    8
    I'm getting this error when I try to use my database hosted with GoDaddy Shared hosting. Am I doing something wrong?

    [​IMG]
    cjscrofani, Oct 22, 2010
    #1
  2. 04venom

    04venom New Member

    Joined:
    Oct 22, 2010
    Messages:
    7
    Hello CJ, is your DB on the same server or remote?
    04venom, Oct 22, 2010
    #2
  3. cjscrofani

    cjscrofani New Member

    Joined:
    Sep 30, 2010
    Messages:
    8
    Remote... On another server.
    cjscrofani, Oct 22, 2010
    #3
  4. 04venom

    04venom New Member

    Joined:
    Oct 22, 2010
    Messages:
    7
    Nice.... I have the same problem. However, my installation looks locally. Are you using the IP or hostname of the remote server?
    04venom, Oct 22, 2010
    #4
  5. cjscrofani

    cjscrofani New Member

    Joined:
    Sep 30, 2010
    Messages:
    8
    I'm using the host name -- apcamemeber.db.6633624.hostedresource.com
    cjscrofani, Oct 22, 2010
    #5
  6. 04venom

    04venom New Member

    Joined:
    Oct 22, 2010
    Messages:
    7
    Well I can tell you that your hostname resolves to:

    apcamemeber.db.6633624.hostedresource.com = 97.74.31.111

    The error you're seeing is from 12.68.137.179. Is this IP the IP on where you're running the installation from? If yes, you have the exact same problem I'm seeing. Except I get a totally different message.

    I get:

    Cannot select database 'DBNAME'(Access denied for user 'ohio'@'IPADDRESS' to database 'DBNAME')
    04venom, Oct 22, 2010
    #6
  7. cjscrofani

    cjscrofani New Member

    Joined:
    Sep 30, 2010
    Messages:
    8
    Yup. That's the IP address of where the aMember files are. Any clue what we're doing wrong?
    cjscrofani, Oct 22, 2010
    #7
  8. 04venom

    04venom New Member

    Joined:
    Oct 22, 2010
    Messages:
    7
    Not a clue. I'm hoping that someone more experienced would chime in and help out.
    04venom, Oct 22, 2010
    #8
  9. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    Do you have any other scripts that are using the remote dB from this web server? Wondering if there are any routing or firewall rules preventing connection to the dB.
    skippybosco, Oct 22, 2010
    #9
  10. 04venom

    04venom New Member

    Joined:
    Oct 22, 2010
    Messages:
    7
    Yeap, two; Vbulletin and WordPress.
    04venom, Oct 22, 2010
    #10
  11. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    Couple of things come to mind:

    1) I notice that in your hostname amember is mis-spelled (apcamemeber as opposed to apcamember) is this intentional and are you entering correctly for db and user?

    2) I'm used to seeing GoDaddy MySQL hostnames being something like mysql157.secureserver.net. Are you sure about the hostname? Can you check your Web Hosting Manager on GoDaddy.
    skippybosco, Oct 23, 2010
    #11
  12. cjscrofani

    cjscrofani New Member

    Joined:
    Sep 30, 2010
    Messages:
    8
    Everything from my end is correct.

    [​IMG]
    cjscrofani, Oct 23, 2010
    #12
  13. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    Strange. Have you contacted GoDaddy directly to see if they offer any suggestions?

    I have a number of sites running a remote dB, but none on GoDaddy.

    In doing some Google Searches for hostedresource.com mysql "access denied" it seems there are a lot of folks having that same issue with GoDaddy across various scripts (including vBulletin and Wordpress). A few suggestions that have worked for them are:

    1) making sure the user has the correct privileges. (apparently by default users do not have any access unless you specifically define it)

    2) deleting and recreating the dB. Apparently there are issues during creation that prevent the dB from being usable (http://forum.opencart.com/viewtopic.php?f=20&t=12324&start=0)

    3) some are listing @ {IP} in their username exampleapcamemeber@97.74.31.111 (http://forums.mysql.com/read.php?39,357204,366583)
    skippybosco, Oct 23, 2010
    #13

Share This Page