Loading...
 
Architecture / Installation

Architecture / Installation

Forum List Topic List

 
Thread actions
PDF Print this page
  • Print all pages

    • Data recovery

    Posted by TikiET posts: 2

    I have managed to recover data from a 'dead' HDD, including my personal wiki. IIRC it was created under Eta Carinae (1.7.n) in 2003Q4. I am now using Win2000, Apache 2.0.52, PHP 4.3.9, and MySQL 4.1.15nt. I first attempted to upgrade the system to 1.8.6 and from there to 1.9.2, following the instructions and database upgrade procedures in the respective Upgrade Notes.

    TikiWiki failed to run as a client unless I told MySQL to use its old_password format. However it still will not let me login.

    If I use MySQL clients I can see the data, eg Tiki_pages, having logged on as the above userNm.

    Have I left out a vital step?
    Is it possible to recover such aged data?
    NB I have full control/it is a local set up.

    Please advise,
    =dn

    Reads: 721
    Link
    Posted by sylvie greverend posts: 1092

    You did the right thing by applying the instructions one by one
    First UpgradeTo18
    Then UpgradeTo19
    I don't understand if you have a problem with mysql or with tw login...
    MySQL password? Did you check the password in db/local.php
    login problem? I know that the procedure to save the password in the database changed between version (the md5 for the has value has not hte same default between release). If you try to change the password (the receipe is on this site in the admin faqs), does it help

    sylvie

    Link
    Posted by TikiET posts: 2

    > You did the right thing by applying the instructions one by one

    Yes I used those, excepting UpgradeTo19 pushed me to the more specific 1.9.2 edition.

    > I don't understand if you have a problem with mysql or with tw login...

    The latter. If I use MySQL Query browser or the MS-DOS command line client I am able to access the tables, eg querying tiki_pages shows me familiar contents. I have rebooted the machine to ensure that both Apache and MySQL are behaving themselves and nothing appears in the Event Log. The userNm "tiki" has been created with both % and localhost scope and with full range of access to all of MySQL as well as universal privileges to specific database.

    > MySQL password? Did you check the password in db/local.php

    Yes everything appears present and correct. All is in lower case.

    > login problem? I know that the procedure to save the password in the database changed between version (the md5 for the has value has not hte same default between release). If you try to change the password (the receipe is on this site in the admin faqs), does it help

    If I change the MySQL pswd then the errmsg changes to "Client does not support authentication protocol requested by server; consider upgrading MySQL client", and if I then modify the password using MySQL's old_password() I'm returned to square-one.

    I have followed through all of the ideas in the FAQs, deleted old sessions/cookies, checked the location of the PHP Session storage, modified the PHP sessions code, and so on.

    It still presents me with the logon screen. I type in the two values and it returns with the stated errmsg, the central/second logon box removed, and a green band at the top of the screen saying This is TikiWiki etc.

    BTW outside of TikiWiki I have rebuilt my wife's research database and its PHP/web front-end (complete with the old_password() issue), so I believe that the underlying servers are working and interacting correctly.

    > sylvie

    Many thanks for your help. Any other suggestions will be most appreciated!
    =dn

    Link