Setup / Database creating

[GoogleCodeExporter]

Thanks for your work.

I installed concerto_platform_v4.0.0.beta1
Everything went fine but the database creation while launching setup script. 
see : http://bit.ly/ZmifMd
If I run the setup again once more, it is going ok. see http://bit.ly/16PTLPK

In fact, no user is created in concerto database, User table is empty. 
UserWorkspace is fine, with one raw for db_login = concerto_1

So, I can't login with the default admin account.
I created a admin id in the User table, but couldn't generate the right 
password because the hash function is quite complex. I can't use 'forgot your 
password' feature as I do not have any mail server on my local machine.

I am working on MacOS X 10.6.8, with default web server, MySQL, accessing 
concerto on localhost.

Thank you very much in advance for your input.
I stay available for any other feedback.

Original issue reported on code.google.com by florent....@gmail.com on 10 Apr 2013 at 10:25

Attachments:

• concerto_setup_ok.png

[GoogleCodeExporter]

Below is a way to hash password the concerto way, if someone is interested, 
based on User Class in model/User.php

<? $id = 1;
$login='admin';
$last_login='0000-00-00 00:00:00';

function calculate_raw_password_hash($password) {
       global $id, $login,$last_login;
        $hash = $password;
        for ($i = 0; $i < 5000; $i++) {
            $hash = hash("sha512", $login . "-" . $hash);
        }
        return calculate_password_hash($hash);
    }

function calculate_password_hash($hash) {
        global $id, $login, $last_login;
        for ($i = 0; $i < 5000; $i++) {
            $hash = hash("sha512", $hash . "-" . $id . "-" . $login . "-" . $last_login);
        }
        return $hash;
    }

echo calculate_raw_password_hash('admin');
?>

Thanks to this, I can access concerto now.

Original comment by florent....@gmail.com on 10 Apr 2013 at 3:58

[GoogleCodeExporter]

Are you sure your MySQL user had ALL privileges on *.* and GRANT privilege ?

Original comment by LisPrzem...@gmail.com on 6 May 2013 at 5:48

• Changed state: Accepted

[GoogleCodeExporter]

I solved the issue.
I recreated the MySQL database with the right privileges.
Thanks for your reply.

Original comment by florent....@gmail.com on 7 May 2013 at 9:16

[GoogleCodeExporter]

Original comment by LisPrzem...@gmail.com on 7 May 2013 at 12:33

• Changed state: Done