Page 1 of 2 12 LastLast
Results 1 to 10 of 15
  1. #1
    Join Date
    Jul 2007
    Posts
    172
    Plugin Contributions
    0

    Default Can't connect to database during installation

    I'm in the process of installing zen-cart, and the installer keeps telling me that it can't connect to the database. I've double-checked that everything is typed in correctly (db name, password etc). One of the first questions that's asked is for a Store Identifier (Table Prefix). I'm leaving this field blank. Is this the cause of the failure? If so, what do I used for the prefix? I came across nothing about a prefix when I was creating the database. Thanks.

  2. #2
    Join Date
    Dec 2004
    Location
    The Internet
    Posts
    81
    Plugin Contributions
    0

    Default Re: Can't connect to database during installation

    Did you create a dbuser in your control panel ? if yes, did you make sure that the user was added to the database ? if you are using cPanel, the user has to be added to the database after you created it.

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Can't connect to database during installation

    The store-identifier, or "prefix", is entirely optional, and we recommend that you leave it blank.

    What details are being provided along with the "cannot connect" error?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  4. #4
    Join Date
    Jul 2007
    Posts
    172
    Plugin Contributions
    0

    Default Re: Can't connect to database during installation

    Araunah,
    When creating the database in Network Solutions, a user was created as well. If I look at the config of the database, it shows a dbuser, which I'm using when installing the zen cart.

    DrByte,
    Here is the rest of the error message:


    Connection to Database failed
    Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    A connection to the database could not be made. This can happen for a number of reasons.

    You may have given the wrong DB host name, or the user name or password may be incorrect.

    You may also have given the wrong database name (Does it exist? Did you create it? -- NOTE: Zen Cart™ does not create a database for you.).

    Please review all of the entries and ensure that they are correct.

  5. #5
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Can't connect to database during installation

    Quote Originally Posted by isaacr25 View Post
    Network Solutions
    buyer beware

    Quote Originally Posted by isaacr25 View Post
    Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    What are you entering for the "Database Host" setting?
    It is likely that your host isn't using "localhost" for the database, so you'll need to enter the correct address for the server where the database is located ... which is likely indicated in the same screen where you set up the database and user.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  6. #6
    Join Date
    Jul 2007
    Posts
    172
    Plugin Contributions
    0

    Default Re: Can't connect to database during installation

    I just tried using the domainname.com, as well as the ip address, and I still cannot connect to the db.

  7. #7
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Can't connect to database during installation

    Does your phpMyAdmin perhaps tell you the name/address of the database server?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Can't connect to database during installation

    Googling for Network Solutions support brings one to this page:
    http://customersupport.networksoluti...ory.php?id=125

    From there, they have several FAQs:

    Creating/locating database server settings:
    http://customersupport.networksoluti...cle.php?id=301
    http://customersupport.networksoluti...cle.php?id=394


    Connecting to database from an application:
    http://customersupport.networksoluti...cle.php?id=403
    excerpt:
    • MySQL Server Name equal to the IP address of your Network Solutions MySQL server.
    • User Name / Password equal to your MySQL database username / password.
    • Database equal to the name of your MySQL database.

    What is the IP address of your Network Solutions MySQL server ?
    Use that as your Database Host setting when installing Zen Cart.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  9. #9
    Join Date
    Jul 2007
    Posts
    172
    Plugin Contributions
    0

    Default Re: Can't connect to database during installation

    Here is what my phpadmin page shows:

    www.mwebdev.com/misc/dbadmin.jpg

  10. #10
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Can't connect to database during installation

    As an aside, it's worth noting that you'll most likely be unable to use SSL to protect your checkout area if you're using Network Solutions hosting in conjunction with Zen Cart and many other ecommerce applications.
    It's a known limitation that Network Solutions is apparently unwilling to fix.

    If you're just getting started, a different host would be advised.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v153 stalls at database setup during installation
    By timwkrause in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 13 Jul 2014, 02:53 AM
  2. During Zencart Installation, Can't connect to Database. WHy?
    By myjasonlee in forum Installing on a Linux/Unix Server
    Replies: 13
    Last Post: 21 Dec 2008, 04:16 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR