Two directories pointing to one database

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
jelv
Posts: 16
Joined: 23 Feb 2005, 11:35
Location: Wiltshire, UK

Two directories pointing to one database

Post by jelv »

For security/access rights reasons it looks like I am going to need to have two copies of the Mantis directory with the config files pointing to the same mySQL database tables. The only difference between the two copies will be the setting of $g_path in config_inc.php which will be slightly different.

Can anyone see why this may cause me any problems?
John
thraxisp
Developer
Posts: 509
Joined: 14 Feb 2005, 03:38
Location: Ottawa, Canada
Contact:

Post by thraxisp »

On the surface, the only thing that I can think of is that MySQL doesn't support locking. There might be the possibility of a collision in some of the tables, say, if two issues are logged at the same time.
vboctor
Site Admin
Posts: 1293
Joined: 13 Feb 2005, 22:11
Location: Redmond, Washington
Contact:

Post by vboctor »

I am not sure about MySQL's support for locking, but assuming this is the case, the problem exists with one installation. Adding another installation, want cause any extra problems.

Assuming that the config_inc.php is the same with the exception of the path, and that both folders have the same version of Mantis, I don't see a problem with having two folders accessing the same database.

Regards,
Checkout MantisConnect
http://www.futureware.biz/mantisconnect
jelv
Posts: 16
Joined: 23 Feb 2005, 11:35
Location: Wiltshire, UK

Post by jelv »

Just to report back - the twin Mantis directories pointing to the same mySQL database are working fine - thanks for people's comments.
John
vboctor
Site Admin
Posts: 1293
Joined: 13 Feb 2005, 22:11
Location: Redmond, Washington
Contact:

Post by vboctor »

Fantastic!!! Thanks for letting us know.

Regards,
Victor
Mantis to Go?
http://www.futureware.biz/mantisconnect
Post Reply