Hi, Have you tried changing the daemon.conf to use a database username and password for each separate database ?
There is _nothing_ in the Scmbug source that reads the localconfig file. Only the installation_directory of Bugzilla is used. Then, values like the ::$db_name variable (in Daemon/Bugzilla.pm) are set to the values from daemon.conf. Perhaps a multi-database bugzilla has a different way of setting that variable ? Tried with admin username and password which is having access to all database. I have tried to configure scmbug in two different way and the example scenario is given below. I hope the information given will help you to short out the isse. ISSUE : Log file: -------------------------------------------------------------------------------- 2008/09/19 16:43:32 Scmbug ERROR> DB.pm:901 - Can't connect to the database. Error: Access denied for user 'root'@'localhost' (using password: NO) Is your database installed and up and running? Do you have the correct username and password selected in localconfig? 2008/09/19 16:47:02 Scmbug WARN> Daemon.pm:567 - Processing connection from xyz.abc.com 2008/09/19 16:47:02 Scmbug WARN> Process.pm:886 - Processing an 'activity_verify' for bug ids '1,2' from SCM user 'rajesh_allun' 2008/09/19 16:47:02 Scmbug ERROR> localconfig:62 - Bareword found where operator expected at ./localconfig line 62, near "$db_check" 2008/09/19 16:47:02 Scmbug ERROR> localconfig:62 - (Missing operator before db_check?) 2008/09/19 16:47:02 Scmbug ERROR> Localconfig.pm:208 - An error has occurred while reading your 'localconfig' file. The text of the error message is: syntax error at ./localconfig line 62, near "$" (Might be a runaway multi-line $$ string starting on line 52) Please fix the error in your 'localconfig' file. Alternately, rename your 'localconfig' file, rerun checksetup.pl, and re-enter your answers. --------------------------------------------------------------------------------------- In my case the localconfig file for different database is different and it will read the exported PROJECT variable and read the localconfig accordingly. Ex: * db 'abc' the the bugzilla locate the localconfig.abc file and the credentials are given in localconfig.abc file. * similarly for db 'xyz' the file is localconfig.xyz ....... Example: Two SVN Repos :: Repos Name : ABC , XYZ path to access ABC Repo: https://svn.aaa.com/svn/ABC path to access XYZ Repo: https://svn.aaa.com/svn/XYZ Two Bugzilla Database :: DB name : abc, xyz path for bugzilla-1 : https://bugzilla.aaa.com/abc path for bugzilla-2 : https://bugzilla.aaa.com/xyz SCMBUG Requirement: https://svn.aaa.com/svn/ABC ==> https://bugzilla.aaa.com/abc https://svn.aaa.com/svn/XYZ ==> https://bugzilla.aaa.com/xyz Tried two possible ways Scmbug Issue: Case 1: Installation source: RPM package daemon.conf # Configuration information of the bug tracking bugtracker => { type => 'Bugzilla', version => '3.0.3', database_location => '127.0.0.1', database_port => '3306', database_vendor => 'mysql', database_name => 'abc', database_username => 'root', database_password => 'root123', installed_locally => 1, installation_directory => '/opt/bugzilla-3.0.3', bug_url_prefix => 'http://bugzilla.aaa.com/abc/show_bug.cgi?id=' }, Road Blocks: How to specify multiple database under database_name and bug_url_prefix varaiable and read the localconfig.<db_name> to get the credential accordingly. Case 2: Installation Source: source.tar.gz Compiled the source in two different location with two process ID /scmbub/abc & /scmbug/xyz with two different daemons running. /scmbug/abc/etc/scmbug/daemon.conf & /scmbug/xyz/etc/scmbug/daemon.conf I have specified different database in daemon.conf on both location /scmbug/abc/etc/scmbug/daemon.conf bugtracker => { database_name => 'abc', database_username => 'root', database_password => 'root123', installed_locally => 1, installation_directory => '/opt/bugzilla-3.0.3' bug_url_prefix => 'http://bugzilla.aaa.com/abc/show_bug.cgi?id=' }, /scmbug/xyz/etc/scmbug/daemon.conf bugtracker => { database_name => 'xyz', database_username => 'root', database_password => 'root123', installed_locally => 1, installation_directory => '/opt/bugzilla-3.0.3' bug_url_prefix => 'http://bugzilla.aaa.com/xyz/show_bug.cgi?id=' }, But in this case when try to commit the changes, it is trying to find the localconfig in the bugzilla installation directory as the log given above. Note: I may trying something wrong since I am new to scmbug, Please correct me if anything wrong in the config or suggest me the possible ways. Regards Rajesh A S Kristis Makris wrote: Hi Rajesh, http://bugzilla.mkgnu.net/show_bug.cgi?id=1250 On Fri, 2008-10-03 at 15:11 +0530, Rajesh A S wrote: I tried to run multiple instances of scmbug, but all the instances are What did you try, precisely ? tried to read only the localconfig file of bugzilla. Its not reading the database name like localconfig.<dbname> Have you tried changing the daemon.conf to use a database username and password for each separate database ? There is _nothing_ in the Scmbug source that reads the localconfig file. Only the installation_directory of Bugzilla is used. Then, values like the ::$db_name variable (in Daemon/Bugzilla.pm) are set to the values from daemon.conf. Perhaps a multi-database bugzilla has a different way of setting that variable ? ________________________________ This message (including attachment if any) is confidential and may be privileged. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. E-mail may contain viruses. Before opening attachments please check them for viruses and defects. While MindTree Limited (MindTree) has put in place checks to minimize the risks, MindTree will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. MindTree reserves the right to monitor and review the content of all messages sent to or from MindTree e-mail address. Messages sent to or from this e-mail address may be stored on the MindTree e-mail system or else where.
_______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
