292877 - Bugzilla Mail Interface - No Database Selected

Status: RESOLVED WONTFIX

(Bugzilla :: Bugzilla-General, defect)

Description

[DCO]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050317 Firefox/1.0.2
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050317 Firefox/1.0.2

The script contrib/BugzillaEmail.pm (line 72) should select a database prior to
execute a query.  

These lines should be added before line 72:

my $stmt = "USE bugs;";
SendSQL($stmt);

Once I add this command before executing the query, I can receive an help e-mail
from the bugzilla server.



Reproducible: Always

Steps to Reproduce:
1. Once the e-mail interface is well configured on the bugzilla server,  send a
test e-mail to the server (example : [e-mail])
Actual Results:  
1. Nothing happens!
2. If you modify your ~/.promailrc so the output of contrib/bug_email.pl is
redirected in a log file, you get that :

DBD::mysql::st execute failed: No Database Selected [for Statement "SELECT
login_name FROM profiles WHERE profiles.login_name RLIKE 'myuser.name';"] at
Bugzilla/DB.pm line 62
Bugzilla::DB::SendSQL('SELECT login_name FROM profiles WHERE profiles.login_name
RLI...') called at contrib/./BugzillaEmail.pm line 72


Expected Results:  
1. Select the Bugs Database
2. Execute the Query
3. Return an help e-mail

Using Bugzilla 2.18 on SuSE Linux 9.2, 
Apache 2.0.50, 
MySQL Ver 12.22 Distrib 4.0.21

Comment 1

[DCO]

Forgot to mention that I use postfix version 2.1.5.



Here is my ~/.forward :

"|IFS=' '&&p=/usr/bin/procmail&&test -f $p&&exec $p -Yf-||exit 75 #YOUR_USERNAME"



Here si my ~/.procmailrc :

:0 fhw
| formail -I "From " -a "From "

BUGZILLA_HOME=/srv/www/htdocs/bugzilla/contrib

:0
* ^Subject: .*\[Bug .*\]
RESULT=|(cd $BUGZILLA_HOME && ./bugzilla_email_append.pl)

# Feed mail to stdin of bug_email.pl
:0 Ec
#* !^Subject: .*[Bug .*]
RESULT=|(cd $BUGZILLA_HOME && ./bug_email.pl 1>$HOME/bug_email.err
2>$HOME/bug_email.err)

# write result to a logfile
:0 c
|echo `date '+%d.%m.%y %H:%M:  '` $RESULT >> $HOME/bug_email.log

:0 c
|echo "----------------------------------" >> $HOME/bug_email.log

:0 c
$HOME/bug_email.log

# Move mail to the inbox
:0
$HOME/Mail/INBOX

Comment 2

[Frédéric Buclin]

BugzillaEmail.pm calls globals.pl which itself calls Bugzilla.pm. Then Bugzilla->dbh will automatically connect to the DB. So there is no need to add 'USE bugs'.

Comment 3

[Frédéric Buclin]

BugzillaEmail.pm has been killed in bug 356924.