Activity for Greg Wilson

  • Greg Wilson Greg Wilson posted a comment on discussion Help

    The button does change form show change history to hide change history without the history list changing. Then clicking hide change history does nothing - doesn't change the button back to show change history.

  • Greg Wilson Greg Wilson posted a comment on discussion Help

    Show Change History isn't working in Microsoft Edge. It works fine with both IE & chrome. i.e Some changes aren't appearing in Edge at all despite clicking the Show Changes button. All changes display fine in IE & Chrome. using BugTracker version 368

  • Greg Wilson Greg Wilson posted a comment on ticket #2286

    Thanks Campbell. That fixed it. Is that code likely to work with later versions? i.e Should I keep it to paste in after the next upgrade of MRBS? Cheers, Greg.

  • Greg Wilson Greg Wilson created ticket #2286

    Room Admin can't edit room bookings

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    I could see the emails were being sent and every indication was that the 20 second delay was on the sending side. i.e receiving email server was recording no delay. From: Campbell Morrison cimorrison@users.sourceforge.net Sent: Friday, 15 January 2021 8:38 AM To: [mrbs:support-requests] 2270@support-requests.mrbs.p.re.sourceforge.net Subject: [mrbs:support-requests] #2270 Fatal error: unfortunately the database is not available at the moment. I think there were two problems: the first was slow LDAP...

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    Campbell, I think the problem changed with the upgrades as the database not available warning was coming up at first. Is it possible that the email sending was the problem the whole time and the code's written to update the booking into the database once the email sending's complete? Sendmail was definitely getting a 20 second delay on sending email. I haven't worked out why as dns, bandwidth and connectivity all seem fine. Installing Postfix solved the problem as it accepts mail instantly and handles...

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    Campbell, I've finally fixed the problem! I installed Postifx with a simple config to send all mail via our internal email server. I stopped sendmail in startup and rebooted the web server. Creating and deleting bookings in MRBS is now instant again. I don't know why sendmail was was inserting a 20 second delay into the email sending process but now, even if there is a delay sending, it happens in the background without slowing down MRBS. Many thanks for your help troubleshooting this. Cheers, G...

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    Icalendar false didn't help. I'm checking mail log on web server and email server, which is internal. No delays at receiving end but I can see delays at sending end. The only error is: Authentication-Warning: SCULDAWEB3.lismore.local: www-data set sender to password_reset@summerland.com.au using -f I've tried adding www-data to /etc/mail/trusted-users and restarted sendmail but error is still appearing and sending is still slow. I don't know if that's what's causing the delay but 20 seconds delay...

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    Campbell, The dev code is quicker but 20 seconds to record, change or delete an entry is still long. 2. I disabled mail and response time was really fast - a second or two. Once mail enabled again I tried changing the mail server name entry in MRBS to be the name the mail server responds with via smtp, also tried using it's ip rather than a name but it didn't help. Here's the mail setup: // These settings are only used with the "smtp" backend $mail_settings['admin_backend'] = 'mail'; //$mail_settings['admin_backend']...

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    Campbell, We’re using ldaps to Windows Active directory. No currently getting failures but entries are taking over a minute to run after submitted. Thanks, Greg Sent from my iPhone On 7 Jan 2021, at 10:11 pm, Campbell Morrison cimorrison@users.sourceforge.net wrote:  I don't quite understand what's going on. There seem to be two problems: You are getting a timeout when MRBS is trying to get a lock. However this should result in the fatal error message "Failed to acquire exclusive database access",...

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    I think this is the problem (from apache2 error log): [Thu Jan 07 10:20:57.300785 2021] [:error] [pid 2560] [client 10.99.122.19:52050] \nE_USER_WARNING in /var/www4/html/web/lib/MRBS/DB_mysql.php at line 107\nGET_LOCK timed out after 20 seconds\nMRBS GET: Array\n(\n)\nMRBS POST: Array\n(\n [csrf_token] => 0b68da104b2fd04d1ad3e8ed2d80486f9cf76147dea7b9f60c06bcab2fb4cbeb\n [returl] => https://10.99.122.38/web/\n [rep_id] => 0\n [edit_type] => series\n [name] => Test\n [description] => Test only\n...

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    (1) I am now sometimes able to create new bookings but it takes over a minute for the screen to refresh - hence the timeouts above. I've been doing some SQL tuning as both html and php web pages seem to be very fast. I've increased the innodb_buffer_pool_size t0 8 Gb but it hasn't helped. Webmin is also slow although all memory, PC use etc is all very low <10%. (2) I have made that entry and removed the booking for field. Thanks, Greg.

  • Greg Wilson Greg Wilson posted a comment on ticket #2270

    BTW The site is running PHP 7.0 Problem occurred after updating form MRBS 1.7.1 to 1.9.2

  • Greg Wilson Greg Wilson created ticket #2270

    Fatal error: unfortunately the database is not available at the moment.

  • Greg Wilson Greg Wilson posted a comment on discussion Help

    Great Tip! Adding the line into Web.Config <add value="dd/MM/yyyy" key="JustDateFormat"></add> Solved the problem for me in the latest version.

  • Greg Wilson Greg Wilson posted a comment on discussion Help

    I have two different custome date fields with different names. Both use datetime type. The second works fine but the first won't poplulate off the calendar. It won't allow typing so no was to put a dae in there. I'm onthe lastest vesion of Bugtracker.net. Thanks, Greg.

  • Greg Wilson Greg Wilson created ticket #1892

    Email to send SMS to number on booking form

  • Greg Wilson Greg Wilson posted a comment on ticket #186

    Thanks for that. I turned onthe debug with the existing code, then added the extra debug lines to the mail file. The email to the room admin shows in both debugs. In both cases no email is sent to the sms gateway as mobile variable is listed as blank in the debug. The mobile number IS getting entered into the entry table but for some reason the mail code isn't seeing it. Another small glitch is that the leading zero is getting stripped from mobile numbers when stored - ours are 10 digit numbers starting...

  • Greg Wilson Greg Wilson posted a comment on ticket #186

    I've added the column mobile as a int. It's displaying and populating ok. I've added the above code to functions_mail.inc but no additional emails are being sent (from mail log.). We're suing smtp mail, not sendMail. Does the code above need to be changed to reflect that? Thanks.

  • Greg Wilson Greg Wilson posted a comment on ticket #186

    Excellent! Thank you very much. That's exactly what I need. I'll test this code today.

  • Greg Wilson Greg Wilson posted a comment on ticket #186

    Could I please have some help to setup a custom email? We'd like to send an sms (via email) to notify people of bookings. I'd like to add a global custom field labelled mobile number, then if it's been populated, have MRBS send an email to mobilenumber@oursmsprovider.com when the booking is made . The sms provider cant support sending of booking files so the email would need to contain text of the booking time and date plus location. I've updated to MRBS V 1.7 so whater will work witht he latest...

  • Greg Wilson Greg Wilson posted a comment on ticket #314

    I'd like to do something similar to this too. We have the ability to send sms via email so if we were able to add a field of mobile number, it would be good to send an email to mobilenumber@oursmspriveder.com with the booking info as the message body.

  • Greg Wilson Greg Wilson posted a comment on discussion Help

    I've added a custom date field. When we poplulate the field, the pop-up calendar...

1