Wednesday, 2009-06-03

../irclogs/#mantishelp.2009-06-03.log
--- scribe started ---00:00
MkJacksonhey folks, so it looks like the issue was that phpmailer was not in my php/includes directory (which is now set in the INI file)01:07
MkJacksonbut now it's saying that maximum in-progress requests reached01:08
MkJacksondoes PHP have to be restarted01:09
thraxisppaul_: The graph api is crap. It uses associative arrays for all of the data. For a date range, there could be 3 or 4 copies of all of the date strings :P01:09
thraxisp(The date is the dependent variable).01:10
thraxisp^dependent^independent01:10
MkJacksonDoes anyone know how to reset the number of in-progress requests?01:19
MkJackson"Max. number of in-progress requests reached. Please contact the system administrator." is what I get now that I'm trying to test my e-mail connectivity01:20
MkJacksonno love from the interwebs either01:20
MkJacksonAPPLICATION ERROR #1905 is the exact error btw01:27
mantisbotNew bug: Bug 10558 - aCCuReRaS - open - new06:50
mantisbotNew bug: Wrong sorting on changelog/roadmap - http://www.mantisbt.org/bugs/view.php?id=1055806:50
Heady|anyone know if it is possible to set the $g_notify_flag in config.php also in the webinterface? I want to change it only for one project not for all09:58
Heady|or is it possible to add options in config_inc.php for only one project?09:58
Heady|anyone here? :D11:03
MkJacksonI am, but I'm still waiting for a response to a query I had earlier last night11:08
MkJacksonHeady|: you wouldn't happen to know about the issue where you get "APPLICATION ERROR #1905  Max. number of in-progress requests reached. Please contact the system administrator." do you?11:09
Heady|sounds like a database issue11:13
MkJacksonit only happens when I try to shoot e-mails to people when they've forgotten their password11:13
MkJacksonI'll look to see if anything else DB related is affected though, good idea11:14
Heady|normaly people can do this alone11:14
Heady|just click the forgot pw link and enter email11:14
MkJacksonyeah, I know... I'm running this on a windows server running IIS though and it seems that this is a reason for special install steps (wasn't my idea to use MS though...)11:17
nuclear_eclipseMkJackson: you'll need to manually modify the db user_table to set the request number back to zero11:32
nuclear_eclipseHeady|: it should be possible to set the notify flags through the ui; if anything, you can use the configuration management page to manually set the notify_flag value via textbox11:35
MkJacksonnuclear_eclipse: so I can log into mysql, find the request number in the table user_table and set it to 0 and all should be well?  this is in the same db that mantis is using correct?11:40
nuclear_eclipseright11:40
MkJacksonto search for it (now that I'm logged in) I've put in "SELECT * FROM user_table" to show the table but it doesn't seem to show me anything11:41
MkJacksonjust gives me a -> prompt11:41
nuclear_eclipsewell, it would be mantis_user_table11:42
MkJacksonah... :-)11:42
MkJackson\c11:42
MkJacksondoh11:42
nuclear_eclipseim just on my phone, so im typing lazy :-p11:42
MkJacksonno worries nuclear, your assisting this n00b is most helpful.  I want mantis working so badly on this box but the boss has this idea that it's better to just use an SVN based text doc... MUST GET MANTIS WORKING11:43
MkJackson;11:44
CIA-61Mantisbt: s.mazeland * r2b2ec01451c3 /lang/ (strings_catalan.txt strings_swissgerman.txt): Localisation updates from http://translatewiki.net (2009-06-03 11:38 UTC)11:44
nuclear_eclipse.511:45
nuclear_eclipseoops11:45
MkJacksonnuclear_eclipse: I know this isn't a SQL forum but I'm trying to reset the "lost_password_request_count" to 0 by doing a "UPDATE bugtracker.mantis_user_table SET lost_password_request_count = 0 WHERE lost_password_request_count > 0;" and I'm getting a syntax error?12:00
Heady|hi nuclear_eclipse can you give me an example how to add it to the webinterface?12:01
Heady|jackso you have no phpmyadmin?12:01
Heady|the sql is correct12:02
Heady|you can leave out the ; at the end12:02
MkJacksonHeady|: If I leave the ; out at the end I get the -> prompt12:06
MkJacksonHeady|: What's phpadmin?  does it come with mantis?12:06
Heady|its a php tool to manage databases in a webfrontend12:06
Heady|you use an sql console?12:06
MkJacksonlol, yeah... this is my first time playing with any of this12:07
MkJacksonreading stuff out of a book for reference12:07
Heady|what kind of sql error you get?12:07
Heady|the syntax looks fine12:07
MkJacksonERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE mantis_user_table12:08
Heady|update mantis_user_table set lost_password_request_count=0 where lost_password_request_count>012:08
MkJacksonson of a bitch, the trick was putting it all in one line12:10
MkJacksonthe book breaks it down into sections12:11
MkJacksonlol12:11
MkJacksonWOAH, now it all works... must be PEBKAC somewhere around here12:15
MkJacksonHeady|: Thanks so much for your assistance!12:19
MkJacksonnuclear_eclipse: you mentioned to me a little while back that Mantis required an SMTP server to be configured in order to send out e-mails, etc.  Does this also mean I have to manually install phpmailer into my php?  I've done that, added the path to the includes into the php.ini but still no love on the e-mails12:21
leetcode_39224moi12:29
MkJacksonhey folks, will I have to set the $g_use_iis to ON still?  I'm trying to figure out why e-mail notifications aren't working13:15
MkJacksonhey folks, can someone please let me know if there's any reason e-mail notifications will not work out of the box with IIS?  I've put in phpmailer, added the includes directory (where I placed phpmailer) to the php.ini, restarted the server, placed the appropriate credentials (and method) into the config_inc.php file but still no love... the server seems to "think" it's sending out the mail but no juice13:33
MkJacksonbrb...13:33
MkJacksonis there a log somewhere that can help me figure out why SMTP is not functioning with Mantis?  Should I just resort to using the mail() option in the config_inc.php file?14:45
Maxim1hello15:08
Maxim1is it possible to configure mantis so it will send SMS messages on new bug reports ?15:08
[KK]KirillMaxim1: If your operator support send sms via email - mantisbt support15:10
Maxim1what do you mean my operator ?15:11
Maxim1mail server ?15:11
Maxim1I use phpmailer for mantis15:12
Maxim1[KK]Kirill:15:13
MkJacksondoes the smtp setting in the config_inc.php file have to correlate to the smtp setting in the php.ini file for a server running IIS?15:13
Maxim1see15:27
Maxim1you15:27
MkJacksonfolks, can someone please tell me if there's a log file somewhere that can tell me at least why e-mails aren't going out to users?  mantis is useless to us if users can't receive things like password resets, etc.  I know that this normally works out of the box but I've gotten nothing but grief from trying to get this single crucial piece of functionality running.15:51
moto-moiMkJackson: have you already checked the /var/log/mail.*'s?15:53
MkJacksonmoto-moi: not yet, didn't know it existed.  is there a place better than the wiki/manual for troubleshooting mantis?15:54
moto-moiwel, /var/log is the mail place for the logging on a *nix server :)15:54
MkJacksonmoto-moi: wait... that's a unix/linux directory, I'm currently running on Win15:54
moto-moiah..15:54
MkJacksonyep, don't look at me, just using what the boss gives me15:54
MkJackson:-P15:54
moto-moiYou poor boy :P15:55
MkJacksonI'm pretty sure this is where my pain is coming from15:55
MkJacksondoes that help indicate why I'm having these issues?15:55
moto-moiwell, maybe :)15:56
moto-moiwhat is your $g_phpMailer_method setting? :)15:56
moto-moiI don't know how your mail is being send, but I guess that's the point you have to look at :)15:57
MkJacksonI've set it to 2 so that we can use SMTP and I've been able to confirm my settings (since it's my e-mail that I'm testing it with)15:57
moto-moiah, ok15:57
MkJacksonin my php.ini though it's pointing to another, does that really matter?15:57
moto-moiwell, if both are 100% working it doesn't :P15:57
moto-moibut you can always check by telnetting to the smtp server and yell some command's15:58
MkJacksonbecause I've heard that gmail isn't supported and I got a strong feeling my higher-ups are using gmail for something else15:58
moto-moipossibly, again, haven't used gmail :P15:58
moto-moimaybe paul_ has an idea? :_)15:58
moto-moibut my best guess would be those settings15:59
MkJacksoncould I just use option 0 and resort to mail() ?15:59
MkJacksonalso, do I have to manually install phpmailer?  I already did but I was curious if it came with mantis now15:59
moto-moisure, that's the internal command of php, so that would use the settings from your php.ini afaik15:59
MkJacksonthat's what I was thinking16:00
MkJacksonusing option 0 causes the request for lost password link to just hang16:01
MkJacksongonna see if I can find any php log files16:01
moto-moigood luck16:02
mib_paulmkjackson: try sending a test mail from /admin - does that work?16:09
MkJacksonmib_paul: ahhhh... I just deleted that directory (from the suggestion of the login page)... I'll extract it and try again but what page in the /admin directory are you referring to?16:12
MkJacksonmib_paul: just sent the test, saiy to check my php/mail server settings16:15
MkJacksonso I guess I got to configure the php.ini16:16
mib_paulyour running iis?16:16
mib_paulwhat mail server you using?16:16
MkJacksonIIS16:16
MkJacksonmib_paul: TIA btw16:17
mib_paulso that's a remote smtp server right?16:17
MkJacksoncorrect... the IIS server is going to use a server elsewhere unless there's a way to have it just use something built into IIS that I may now know about?16:18
mib_paulso just set $g_smtp_host in config.inc.php to the remote address of the smtp server16:18
mib_paulthe next question is whether you need to supply a user/pass to access the smtp server16:18
mib_paulincidently, I have $g_phpMailer_method set to 216:19
MkJacksonmib_paul: yep, I've already set all those settings but the php.ini is still pointing to gmail (bosses idea) which I've come to learn isn't supported in this build (until 1.2 I've heard)16:19
* mib_paul wonders where that came from16:21
* mib_paul wonders what gmail do that's special16:21
MkJacksonmib_paul: you got me dude, just got to work with what I'm given16:22
MkJackson:-(16:22
MkJacksonjust restarted IIS after changing up the php.ini16:22
MkJacksongoing to double-check my config_inc.php now and then give it a whirl16:22
mib_paulwhy do you think gmail isn't supported until 1.2?16:22
MkJacksonmib_paul: that's what I was told16:23
MkJacksonmib_paul: (18:38:03) nuclear_eclipse: MkJackson: I think gmail SMTP support only works correctly in 1.2 atm16:24
nuclear_eclipseiirc, it's because the smtp port configuration isn't working correctly in the old version of mantis/phpmailer16:25
MkJacksonmib_paul: still no go atm btw  All the settings seem correct though...16:26
MkJacksongoing to try a manual telnet to the server16:26
MkJacksonhmm... looks connected but not sure how to manually enter credentials via telnet (first time connecting to SMTP manually)16:27
nuclear_eclipseMkJackson: it's too complicated to do manually, unfortunately =\16:28
nuclear_eclipseit requires a HELO command, and then some other goofy business, including a base64 encoding of you username and password, and more16:28
MkJacksonnuclear_eclipse: well, I managed to get to the smtp site from telnet though I wasn't sure how to give it my credentials (the server did seem to recognize the account though since it did start asking for credentials)16:32
mib_paulbbiab16:34
mantisbotNew bug: Bug 10559 - aik099 - open - new17:39
mantisbotNew bug: Missing "session_delete" function in "session_api.php" - http://www.mantisbt.org/bugs/view.php?id=1055917:39
markw_seeing an issue in 1.2.0a3 with attached files.20:40
markw_it's trying to send me file_download.php as the file.20:40
giallumarkw_, that's usually a symptom of some server side problem20:42
gialluche logs20:42
giallucheck20:42
markw_looking right now...   it's only 1 file attachment that's got the issue.20:46
markw_[Wed Jun 03 13:41:05 2009] [error] an unknown filter was not added: PHP20:47
markw_huh?20:47
gialluanything before that one?20:48
markw_memory space...20:48
markw_checking my php.ini20:48
markw_hmm.  apparently 32MB isn't enough for mantis. :)20:49
paul_should be 'ok' for most things21:01
paul_but php guys set default to 128mb in their ini files now a days21:01
markw_paul_: I'm old school.  I remember when we only had 512mb in the box. :)21:01
markw_even though this one has 8gb. :)21:02
* giallu actually has 512Mb in his web server...21:02
markw_see..21:02
paul_run apc21:02
gialluI prefer writing less broken code when possible... :P21:03
paul_code's not broken21:03
gialluLOL21:04
paul_lo siebrand21:05
* nuclear_eclipse still runs PHP apps from a 360MB VPS21:06
paul_my logic still stands21:06
paul_php5 requires more ram then php421:06
nuclear_eclipsewell, yyes21:07
siebrand'lo21:08
siebrandpaul_: try processing large files with 5.2.[89]. You'll be *very* unhappy.21:09
siebrandpaul_: twice as much memory required as with 5.2.6. Should be fixed in 5.2.10.21:09
paul_siebrand: I run php5.3 so that's not an issue21:10
paul_:P21:10
siebrandI have an application with which I process files up to 300MB. I've had it run out of memory with max usage of 1200M.21:10
paul_what did they break?21:11
siebrandpaul_: dunno. Lemme check.21:11
siebrandthe company whose product I use filed a dupe report and got bullied.21:11
giallusiebrand, move to pyhton...21:11
paul_heh21:11
* paul_ can guess who then;p21:11
siebrandpaul_: http://bugs.php.net/bug.php?id=4815221:12
siebrandaka bug #4748721:13
paul_that's a standard response21:13
siebrandpaul_: yeah, I can guess it makes the reporter feel really welcome and make sure he reports his next bug again...21:14
siebrandStatus: "Bogus" (not "duplicate")21:14
nuclear_eclipset I use filed a dupe report and got bullied.21:15
nuclear_eclipset I use filed a dupe report and got bullied.21:15
nuclear_eclipseoops21:15
paul_siebrand: did you realise it was standard text btw?21:15
siebrandpaul_: yep. That makes it worse.21:16
paul_'bullied' is what company said?21:16
siebrandpaul_: with templates one can at least think of what message one wants to get across.21:16
siebrandpaul_: no, that's my POV>21:16
paul_k21:17
siebrandpaul_: coming from 'the ueberworld of not-so-friendly templates' Wikidia, I know what I'm talking about :)21:17
siebrandthrow in a "pe" somewhere...21:17
* giallu having a look at nuclear_eclipse email-bugnotes branch21:18
nuclear_eclipseyay!21:20
* paul_ thought john already commited that21:20
nuclear_eclipsenope21:21
gialluI think you cherry picked a couple of them21:25
nuclear_eclipseI did commit some other branches the other day, but the bugnotes fix is not yet in master21:26
paul_hmm21:42
paul_nuclear_eclipse: busy?21:43

Generated by irclog2html.py