Login or Register

RSS IconRecent posts in this topic

avatar
andrewCharron on Jan 23. 2008. 8:39 am
As per Ilija in another topic, we are allowed both a local development copy and a public copy of the software on one license. I have one set up on a local development server for testing and modification before we put it up to the public next week. Now I have it set up how I want it, and want to expose it to the LAN for further testing internally. However, the problem arises that aC is set up under the domain "localhost", which now needs to be changed to the LAN IP of my computer/server.

Whats the best way to obtain this? It is also useful to know when I transfer the software to the server, as ill need to change the domain there. I went through all files and replaced localhost with my IP, but to no avail. The webserver is working correctly, as I can pull up my website but the aC system redirects to localhost for others.
avatar
andrewCharron on Jan 23. 2008. 3:48 pm
Problem resolved. I had edited localhost from my DB Hostname on accident. Oops!
avatar
andrewCharron on Feb 7. 2008. 1:44 pm
This problem is back up. We backed up the database and attempted to install on our web server.

The first problem we came across when we tried to install is that it did not like the internal IP address of the server. We are temporarily setting it up on port 8080 until we are ready for it to go live on port 80 where the old site is located.

Putting http://192.168.0.101:8080 in the Base Url box returns:

Installation process:
error — Invalid absolute URL

Removing the port returns the same error. Using localhost:8080 works, but it gives this error on install:

error — SQL error: INSERT INTO `acx_permissions` (`name`, `module`, `default_value`, `type`, `position`) VALUES ('system_access', 'system', '', 'system', '0'), ('people_management', 'system', '', 'system', '0'), ('project_management', 'system', '', 'system', '0'), ('admin_access', 'system', '', 'system', '0'), ('auto_assign', 'system', '', 'system', '0'), ('add_project', 'system', '', 'system', '0'), ('discussions_manage', 'discussions', '', 'project', '0'), ('discussions_add', 'discussions', '', 'project', '0'), ('milestones_manage', 'milestones', '', 'project', '0'), ('milestones_add', 'milestones', '', 'project', '0'), ('files_manage', 'files', '', 'project', '0'), ('files_add', 'files', '', 'project', '0'), ('checklists_manage', 'checklists', '', 'project', '0'), ('checklists_add', 'checklists', '', 'project', '0'), ('pages_manage', 'pages', '', 'project', '0'), ('pages_add', 'pages', '', 'project', '0'), ('tickets_manage', 'tickets', '', 'project', '0'), ('tickets_add', 'tickets', '', 'project', '0'), ('timetracking_manage', 'timetracking', '', 'project', '0'), ('timetracking_add', 'timetracking', '', 'project', '0')
error — Failed to import initial data. MySQL said: Incorrect integer value: '' for column 'default_value' at row 1

Restoring the database from my local copy on my machine works, and when you change the aC data to match the new IP, returns a blank page on index with no errors.

What could be causing this?
avatar
Ilija Studen on Feb 7. 2008. 1:50 pm
If you get Invalid URL error you can use fake URL with the installer (http://activecollab.com will work). When installer is done open config/config.php and change ROOT_URL value to the actual URL you want to use.

activeCollab installer has problems with MySQL in strict more. Here you can find more info: MySQL 5 Strict Mode Issues.
activeCollab team member
avatar
andrewCharron on Feb 7. 2008. 3:05 pm
Ilija Studen:
If you get Invalid URL error you can use fake URL with the installer (http://activecollab.com will work). When installer is done open config/config.php and change ROOT_URL value to the actual URL you want to use.

activeCollab installer has problems with MySQL in strict more. Here you can find more info: MySQL 5 Strict Mode Issues.


Ive changed the database mode, and it now installs correctly. I ran it the first time forgetting to change config.php, and it of course redirected to a non-existant page. I then changed config.php and made it to http://192.168.0.101:8080/online like it should be, and I receive a blank page with no errors or redirects. Any ideas?

8080 does in fact work, we have another database driven site working on the same port.
avatar
Ilija Studen on Feb 8. 2008. 12:56 am
1. URL should be like http://192.168.0.101:8080/public (if you do not use this tweak /public is mandatory).

2. Open config/config.php and set DEBUG to 2 to enable PHP errors (and other debugging tools activeCollab provides). This should give you more details if something is off with the code.
activeCollab team member
avatar
andrewCharron on Feb 8. 2008. 7:39 am
I got it fixed. Somehow config.php did not write correctly when I used a port, it failed to put a '); at the end. This was newly generated, so I dont think I removed it. Well, its all working now, thanks for the help.

RSS IconRecent posts in this topic