Login or Register

RSS IconRecent posts in this topic

avatar
haya on Jul 26. 2006. 8:18 pm
I wrote a SQL file to play with aC on SVN(revision 7).

I checked out /svn/ac/trunk and installed with installation script, but aC didnt work well, some error messages said there were missing columns. It seems that SQL of installation scripts does not create latest schema, and I have to use 'construction.sql' in the root dir of aC to construct latest schema.

I succeeded to setup latest aC in the way below:
- checkout the source
- make 'create-admin.sql' in the root dir of aC
--- create-admin.sql ---
insert into `pm_companies` (`id`, `client_of_id`, `name`, `created_on`, `created_by_id`, `updated_on`, `updated_by_id`)
  values ('1', '0', 'owner_company', NOW(), '1', NOW(), '1');
insert into `pm_users` (`company_id`, `username`, `password`, `email`, `is_admin`, `auto_assign`, `created_on`, `updated_on`)
  values ('1', 'admin', SHA1('admin'), 'admin@dummy.com', '1', '1', NOW(), NOW());
--- create-admin.sql ---

- change dir to the root of aC
- execute following commands(suppose that username for mysql is 'sql_user', and password is 'sql_pass', database for aC is 'db_ac' and db_ac has to be created)
$ mysql -u sql_user --password=sql_pass db_ac < construction.sql
$ mysql -u sql_user --password=sql_pass db_ac < initial_data.sql
$ mysql -u sql_user --password=sql_pass db_ac < create-admin.sql

- edit config/config.php
--- config/config.php ---
<?php
  define('DB_ADAPTER', 'mysql'); 
  define('DB_HOST', 'localhost'); 
  define('DB_USER', 'sql_user'); 
  define('DB_PASS', 'sql_pass'); 
  define('DB_NAME', 'db_ac'); 
  define('DB_PERSIST', true); 
  define('TABLE_PREFIX', 'pm_'); 
  define('ROOT_URL', 'http://ac.ac.ac/ac'); 
  define('DEFAULT_LOCALIZATION', 'en_us'); 
  define('DB_CHARSET', 'utf8'); 
  return true;
?>
--- config/config.php ---
change 'DB_*' and 'ROOT_URL' for your environment, but do not change 'TABLE_PREFIX'.

- hit the url. you will be able to login with username:admin, password:admin.

aC on SVN is not stable (Ilija said) and the way above might have some mistakes, so play at your own risk!
avatar
jarilo on Aug 19. 2006. 6:28 pm
I try this but nothing works. But not a single error in error.log of php. Then I find autoloader.php file in cache directory. With strange values (D:\projects\activecollab). I'm using Linux and there is no such directories. If You using svn last step before hit the url must be delete autoloader.php file from cache directory.
avatar Staff
Ilija Studen on Aug 20. 2006. 3:19 am
That is my autoloader.php ;) I don't know why I didn't added it to the ignore list already... Sometimes when I'm tired I by accident commit it :)
activeCollab Team Member
avatar
dmurphy on Sep 1. 2006. 12:28 pm
construction.sql forgot to add the 'password' column in pm_users. I added the column as VARCHAR(128) just to be safe. Then I created the user admin, with the password SHA1 of 'admin'. But I still can't login on the front page. It says to check my login daya. What else am I missing?
avatar Staff
Ilija Studen on Sep 1. 2006. 12:46 pm
This instructions are out of date. Please check this page: Using the code from SVN repository. `password` field is not required.

The way user passwords are stored in database is changed. Combination of salt and user password makes the token. Twister is used to "twist" the token before it is saved in the cookie and "untwist" it when it need to be checked.

Delete owner company and administrator user and let activeCollab create them for you.
activeCollab Team Member
avatar
dmurphy on Sep 1. 2006. 5:14 pm
It worked! thanks Ilija
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.

RSS IconRecent posts in this topic