Loading...
 
Architecture / Installation

Architecture / Installation

Forum List Topic List

 
Thread actions
PDF Print this page
  • Print all pages

    • Tiki on XP : MySQL problem

    Posted by arthur posts: 4

    frown
    I am new to Tiki and I have encountered some installation problems on XP Home platform (SP2). Some fo them I could solve, but now I'm stuck. I hope someone can help me out.

    I installed EasyPHP for Windows and followed excatly the installation guidelines. Everything went smoothly until I changed the directories from EasyPHP1-7 to EasyPHP and tikiwiki-1.7.5 to tiki. Of course the *.ini files were already build using the previous directory structures, so I managed to change them manually (My.ini; php.ini etc) accordingly. So far so good. Apache is running and so is MySQL. This could be added to the installation guide about changing these directories though! I won't work anymore if you do.

    By the way: I don't understand what is meant in step 5 by :"(* needs to changed to 6 needed perms) " - but that's maybe not relevant to my problem here. I checked all priveledges.


    However I do not succeed to get access to the tiki DB. I have created it but can't get a connection. I have also tried to run tiki.sql.
    Running the installer gives me the message : "Tiki cannot find a database connection Please enter your database connection info". However when I fill out everything acc. to the install guide (ie: tikiadmin, password, localhost, tiki) nothing happens when running the 'submit query'. I've tried dropping the tiki DB, re-create it, create the tables with tiki.sql, deleting them again etc etc.
    Need more than 20 minutes anyway to install.

    Once I ended up at the tiki-install.php with a different screen having the choice between 'Create' and 'Update', but neither of them would work. Everytime I get error messages like these:

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

    DB Error: connect failed

    Somehow my user doesn't exist, but when I verify the 'Priveledges' it does.

    perhaps interesting to add that I had MySQL installed previous to my EasyPHP installation. MySQL was installed as service and on C:\MySQL. I believe the configuratio is using this installation since it creates the tiki database here (C:\mysql\data\)and not under \program files\EasyPHP\mysqldata.

    So basically I need HELP to get acces to this DB. I am sure it is just some parameter setting somewhere. Question is WHERE?

    Thanks!!



    Reads: 1161
    Link
    Posted by arthur posts: 4

    frownPerhaps (most likely!) a stupid question, but how do I chekc that PHP has the mysql extension properly loaded?
    I disabled the SP2 firewall. When I go to http://127.0.0.1/tiki/ now I get the following message :
    Warning: MYSQL error: DB Error: no database selected in query:
    select value from tiki_preferences where name='siteTitle'
    in c:\program files\easyphp\www\tiki\lib\tikilib.php on line 101

    Any suggestions? Thanks for your help.

    Link

    Posted by arthur posts: 4

    Perhaps (most likely!) a stupid question, but how do I chekc that PHP has the mysql extension properly loaded?
    I disabled the SP2 firewall. When I go to http://127.0.0.1/tiki/ now I get the following message :
    Warning: MYSQL error: DB Error: no database selected in query:
    select value from tiki_preferences where name='siteTitle'
    in c:\program files\easyphp\www\tiki\lib\tikilib.php on line 101

    Any suggestions? Thanks for your help.

    Link