Two lines from the config file are not reflecting

[vjandyal]

Hi Team
Below two lines are not reflecting in the execution, meaning as per 1st line unable to enter the 50 characters in the room name field and as per 2nd line booker unable to receive the email after the booking however the admin and whomever mentioning as 'cc' were able to receive.

$maxlength['room.room_name'] = 50;
$mail_settings['booker'] = true;

Browser details (please complete the following information):

• OS: Win
• Browser : Chrome
• Version : Version 137.0.7151.104

Server details (please complete the following information):

• MRBS version : MRBS 1.11.6
• Web server: Apache/2.4.52 (Ubuntu)
• OS: Ubuntu Linux 22.04
• PHP version: 8.1.2-1
• Database used: Mysql

Additional context
Add any other context or screenshots about the feature request here.

[campbell-m]

1. $maxlength isn't used anymore in MRBS 1.11.6. The maximum length of the field is determined automatically by MRBS and set to the length of the database column. If you want to have 50 characters in the room name you need to change the name column in the room table to be a VARCHAR(50).
2. $mail_settings['booker'] = true;. This should work. Is the booker in the address list of the email received by the admin?

[vjandyal]

I have tried by VARCHAR(70) directly in the database, however able to enter the 70 characters but when i am really submitting the addition of the new room its getting the error as "Fatal error: unfortunately the database is not available at the moment."

mysql> ALTER TABLE mrbs_room modify column room_name VARCHAR(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' NOT NULL
-> ;
Query OK, 27 rows affected (3.22 sec)
Records: 27 Duplicates: 0 Warnings: 0

mysql> DESCRIBE mrbs_room;
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | int | NO | PRI | NULL | auto_increment |
| disabled | tinyint | NO | | 0 | |
| area_id | int | NO | MUL | 0 | |
| room_name | varchar(70) | NO | | | |
| sort_key | varchar(25) | NO | MUL | | |
| description | varchar(60) | YES | | NULL | |
| capacity | int | NO | | 0 | |
| room_admin_email | text | YES | | NULL | |
| invalid_types | varchar(255) | YES | | NULL | |
| custom_html | text | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

mysql>

[campbell-m]

but when i am really submitting the addition of the new room its getting the error as "Fatal error: unfortunately the database is not available at the moment

What's the detailed error message you are getting in your PHP error log? If you can't find your error log then set $debug = true; in your config file and the error message will be displayed in your browser.

[campbell-m]

Ah, you'll also need to change the length of the 'sort_key' column to match.

[vjandyal]

Thanks it worked after changing the length for 'sort key'.

On the other issue on still the booker is unable to receive the email, here are the mail settings i have in my config file.
Person in CC and Admin and Area admins were able to receive it but not the booker.

//mail settings
        
$mrbs_admin = "vjandyal@qti.qualcomm.com";
$mrbs_admin_email = "vjandyal@qti.qualcomm.com";
$mail_settings['from'] = 'TE.Support@qti.qualcomm.com';
$mail_settings['organizer'] = 'vjandyal@qti.qualcomm.com';
$mail_settings['room_admin_on_bookings'] = true;
$mail_settings['cc'] = 'ksuribab@qti.qualcomm.com';
$mail_settings['details']   = true;
$mail_settings['html']      = true;
$mail_settings['admin_on_bookings']      = true;  // the addresses defined by $mail_settings['recipients'] below
$mail_settings['area_admin_on_bookings'] = true;  // the area administrator
$mail_settings['booker']                 = true;  // the person making the booking
$mail_settings['book_admin_on_approval'] = true;  // the booking administrator when booking approval is enabled

[campbell-m]

When the email arrives for the others, is the booker on the address list of the email that they receive?

[vjandyal]

No, booker is not available in the email list

[campbell-m]

Which authentication type are you using (eg 'db', 'ldap', etc.)?

[vjandyal]

We are using ldap authentication.

[campbell-m]

It's possible that the problem is that your config isn't correctly configured to retrieve the user's email address from the LDAP server. You need something like:

// Set to true to tell MRBS to look up a user's email address in LDAP.
// Utilises $ldap_email_attrib below
$ldap_get_user_email = true;
// The LDAP attribute which holds a user's email address
// This can be an array.
$ldap_email_attrib = 'mail';

[vjandyal]

Same issue even after adding these lines

Btw below is the error log during observed during the reservation done by booker.

[Fri Jun 27 16:06:24.068145 2025] [php:notice] [pid 1253973] [client 10.218.40.88:61634] [MRBS DEBUG] MRBS\Auth\AuthLdap->action(730): got LDAP connection using ldap://qed-ldap.qualcomm.com:389, referer: http://10.142.101.65/web/index.php?year=2025&month=6&day=27&area=5&room=124&view=day
[Fri Jun 27 16:06:25.249061 2025] [php:notice] [pid 1253973] [client 10.218.40.88:61634] [MRBS DEBUG] MRBS\Auth\AuthLdap->action(748): binding anonymously, referer: http://10.142.101.65/web/index.php?year=2025&month=6&day=27&area=5&room=124&view=day
[Fri Jun 27 16:06:25.486044 2025] [php:notice] [pid 1253973] [client 10.218.40.88:61634] [MRBS DEBUG] MRBS\Auth\AuthLdap->action(758): initial bind was successful, referer: http://10.142.101.65/web/index.php?year=2025&month=6&day=27&area=5&room=124&view=day
[Fri Jun 27 16:06:25.486121 2025] [php:notice] [pid 1253973] [client 10.218.40.88:61634] [MRBS DEBUG] MRBS\Auth\AuthLdap->action(763): searching using base_dn 'ou=people,dc=qualcomm,dc=com' and filter '(qcADMailAcct=rnalam)', referer: http://10.142.101.65/web/index.php?year=2025&month=6&day=27&area=5&room=124&view=day
[Fri Jun 27 16:06:25.723767 2025] [php:notice] [pid 1253973] [client 10.218.40.88:61634] [MRBS DEBUG] MRBS\Auth\AuthLdap->action(781): 0 entries found, no unique dn, referer: http://10.142.101.65/web/index.php?year=2025&month=6&day=27&area=5&room=124&view=day
[Fri Jun 27 16:06:25.723860 2025] [php:notice] [pid 1253973] [client 10.218.40.88:61634] [MRBS DEBUG] MRBS\Auth\AuthLdap->action(811): no DN determined, not calling callback, referer: http://10.142.101.65/web/index.php?year=2025&month=6&day=27&area=5&room=124&view=day

[campbell-m]

I think the problem may be with the setting of $ldap_dn_search_attrib. It looks like you've got it set to "qcADMailAcct" rather than "sAMAccountName" or "uid" or whatever the attribute is called that holds the username.

[vjandyal]

I have tried with both "sAMAccountName" and "uid" separately but noticed the same issue.

[campbell-m]

What have you got $ldap_user_attrib set to?