Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » problem with connecting to DB. help please
 
Thread actions
Print this page
  • Print all pages

    • problem with connecting to DB. help please

    Posted by pgage posts: 4

    I have tikiwiki installed and the mysql database setup as well, but when I try to access any page, I get the "cannot connect to database" error

    its looking for the write db name (pgage_tiki) but under localhost, not how I set it up under db/tiki-db.php

    my settings are :

    $host_tiki = '207.44.196.22';
    $user_tiki = 'pgage_sql';
    $pass_tiki = 'mypassword';
    $dbs_tiki = 'pgage_tiki';

    the error I get:

    Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in C:\hshome\pgage\acautionarytale.com\tiki\lib\adodb\drivers\adodb-mysql.inc.php on line 318

    Unable to login to the MySQL database 'pgage_tiki' on 'localhost' as user 'MjpwZXRlOjUzMTkzMDFiNzM2NDg4MDkzMDcwY2Q1MjA1MDc0OWRiOjEwOjowOjA6MDowOkthcHV0OjQwOTY='
    Go here to begin the installation process, if you haven't done so already.

    Can't connect to MySQL server on 'localhost' (10061)


    It seems to be ignoring my "$host_tiki = '207.44.196.22';" line.

    Any ideas?

    Pete

    Reads: 1072
    Posted by Damian Parker posts: 2881 United Kingdom

    Hi!

    I believe that with the abstraction work in 1.8 the settings need to go into the file local.php instead
    along with 2 new values. Its probably best to run tiki-install.php allow it to reset the database connection and then feed in the new values.

    Damian


    Posted by pgage posts: 4

    ah - that did the trick! I fixed the local file and we are good to go.

    Thanks,
    Pete


    Posted by plamping posts: 30
    That worked for me, too. The local.php file is located in db/ directory, just to clarify. 🎅