DB setup to play with aC on SVN(revision 7)
Page: 1
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
- 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)
- edit config/config.php
- 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!
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!
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.
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?
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.



