search for: concat_ws

...le.com | tmetro | example.com | .INBOX/ | | tmetro+spam at example.com | tmetro | example.com | .spam.tmetro/ | [...] where maildrop was handed ${recipient} from postfix, and it queries the above table matching ${recipient} to the address column, getting back the expression CONCAT_WS('/','/var/mail',domain,owner) as the home directory, and CONCAT_WS('/','/var/mail',domain,owner,mailbox) as the mailbox. The UID/GID are fixed, as this is a virtual user setup. So looking up the mailbox for the user postmaster at example.com returns: /var/mail/exa...

This apparently was a problem that i was not aware since i redid my mail server configuration to make use of Postfixadmin. I have update the conf files using the postfix document fromthe down load. The download document seems to be fpr an early version of dovecot (I am using 2.2.4) as it focuse of dovecot.conf which is now broken into file in the conf.d subdirectory I get "dovecot:

I''ve inherited an EAV database and there''s really no option to remodel it. Data is stored as key_name, key_value pairs Trying to return a meaningful, unified recordset is far too complex to be efficient. I''ve decided to make use of the MySQL GROUP_CONCAT, and CONCAT_WS functions to return a fast query result, with the consolidated fields as one string. The final data is to be displayed and downloaded (CSV), but not all fields will be available for each "row", which makes serialization awkward. I can''t decide where the "heavy lifting"...

...ot configuration with virtual users support: 1. User configuration is stored in MySQL database. 2. Mailboxes are owned by vmail:vmail with permission 0600 or drwx------. Is it possible to change mailbox mode to 0660? Dovecot version is 2.1.7 Part of SQL configuration: user_query = \ SELECT \ CONCAT_WS('/', home, u.uid, d.domain_name, u.user_name) AS home, \ 500 AS uid, \ 500 AS gid \ FROM users u \ LEFT JOIN domains d ON u.domain_id = d.id \ WHERE \ u.user_name = '%n' AND \ d.domain_name = '%d' AND \ u.active = 1 Regards. -- M.

...ons << ''(company_name LIKE ? OR last_name LIKE ? OR first_name LIKE ?)'' 3.times { values << name } @suppliers = Party.find(:all, :limit => 15, :conditions => [conditions.join('' AND ''), values].flatten.compact, :order => %q(CONCAT_WS('' '', company_name, last_name, first_name))) render :layout => false end As you can see, in my _form, I manually created the auto complete magic that Rails usually does for me. I can''t remember anymore, but I think there was no way for me to send the afterUpdateEl...

I''m using the autocomplete function, and need a way to grab a second value from the ajax request... an example would probably speak better: This is my HTML: <input name="CustomerName" id="CustomerName" type="text" /> <div id="CustomerList"></div> <input name="CustomerID" id="CustomerID"

I?m in the process of setting up a Dovecot IMAP proxy to handle a number of IMAP server domains. At the current time, I have my users divided into 70 different groups of users (call them G1 to G70). I want each group to configure their email client to access their mailboxes at a domain name based on the group they belong to (e.g., g1.example.com <http://g1.example.com/>, g2.example.com

Hi, how can I get Rails to generate SQL queries with conditions in the JOIN clause? What I would want is: SELECT * FROM people p LEFT OUTER JOIN jobs j (p.job_id = j.id AND j.salary > 9999999) I tried People.find(:all, :include => ''jobs'', :conditions => ''jobs.salary > 9999999'') but that generates SELECT * FROM people p LEFT OUTER

The Wine development release 4.8 is now available. What's new in this release (see below for details): - Support building most programs in PE format. - Unicode data updated to Unicode 12.0. - Support for MSI patch files. - Default to non-PIC builds on i386. - Joystick support improvements. - Asturian locale. - Various bug fixes. The source is available from the following