search for: concat

Displaying 20 results from an estimated 1467 matches for "concat".

2020 Oct 05
2
isc-dhcp dynamic update problem
...= "172.30.1.40"; set ClientDHCID = "c8:1f:66:08:dd:49"; set ClientName = "MB-DISPATCH-20"; client-hostname "MB-DISPATCH-20"; on expiry { set ClientIP = binary-to-ascii (10, 8, ".", leased-address) ; log (debug, concat ("Expired: IP: ", ClientIP)); execute ("/usr/local/bin/dhcp-dyndns.sh", "delete", ClientIP, "", "0"); } on release { set ClientIP = binary-to-ascii (10, 8, ".", leased-address) ; set ClientDHCID = conca...
2007 Aug 28
2
quota imap_quota
...p_quota imap_client_workarounds = outlook-idle delay-newmail } plugin { # 10 MB + 1000 messages quota limit # quota = maildir:storage=10240:messages=1000 driver = mysql connect = host=/var/lib/mysql/mysql.sock user=mail_admin password=XXXXXXXX dbname=mail user_query = SELECT CONCAT(('/home/vmail/'), SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), CONCAT('5000'), CONCAT('5000'), CONCAT('maildir:storage=', quota) FROM users AS quota WHERE email = '%u'; } The querry output looks like th...
2006 Sep 11
2
Compilation Errors
...now when I try to run my app with mongrel on Windows, I get very strange compile errors: ompile error C:/rails/app/script/../config/../app/views/login/index.rhtml:8: Invalid char `\002'' in expression C:/rails/app/script/../config/../app/views/login/index.rhtml:9: syntax error _erbout.concat " <td>".; _erbout.concat(( text_field("user", "email") ).to_s); _erbout.concat "</td>\n" ^ C:/rails/app/script/../config/../app/views/login/index.rhtml:12: Invalid char `\003'' in expression C:/rails/app/script/.....
2006 Feb 07
3
Newbie help ..
...#39;, :action => ''list'' %> <%= end_form_tag %> In browser: Showing app/views/admin/new.rhtml where line #8 raised: compile error script/../config/../app/views/admin/new.rhtml:8: parse error, unexpected '';'', expecting '')'' _erbout.concat " <td> "; _erbout.concat(( text_field( "member", "first_name", size => 40 ).to_s); _erbout.concat " </td>\n" ^ script/../config/../app/views/admin/new.rhtml:12: parse error, unexpected '';'',...
2015 Sep 13
3
no login with MySQL
...t;> mail: /srv/mail/%u/Maildir > > > > The query-strings for virtual users look like this: > > > > password_query = SELECT username AS username, password FROM mailbox > > WHERE username = '%u' AND active = 1 > > user_query = SELECT maildir, uid, gid, concat('*:storage=', quota) AS > > quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM > > mailbox WHERE username = '%u' > > what about > user_query = SELECT CONCAT(maildir, SUBSTRING_INDEX(username,'@',+1)) as > mail, uid, gid,...
2011 Oct 04
11
Concat::Fragment collection broken in 2.7.5
I don''t if anybody is using the concat modules from ripienaar, but since an upgrade to 2.7.5 I keep getting an error on fragment collection. The code is like below: @@concat::fragment{ "${name}" : target => "/etc/bind/named.conf.keys", content => template("dns/named.conf.keys.erb"), order...
2012 Jul 19
2
Problem with puppet-concat
Hi I am developing a module to create a simple nas for my work and I am using the concat module to assemble /etc/exports and /etc/samba/smb.conf. I developed my module on my puppet development server and concat worked like a charm, however when I rolled it out to my live servers if kept on failing with the following error: err: Failed to apply catalog: Could not find dependent Exe...
2006 Feb 26
3
simplify
Trying to use Eric''s help and Amy Hoy''s page of playing with auto_complete and decided that the script/console is the place to rapidly test. I have this feeling that CONCAT isn''t working for postgresql... c = find_by_sql(SELECT * FROM clients WHERE CONCAT (first_name,middle_initial,last_name) = "johnadams") ^ (irb):61: syntax error c = find_by_sql(SELECT * FROM clients WHERE CONCAT (first_name,middle_initial,las...
2006 Mar 19
2
Functional Testing
...nswer.transaction() do @question = Question.find(params[:id]) for answer in question.answers if !answer.destroy #printf ("Answer %s on Question did not destroy!\n", answer.id.to_s) raise ActiveRecord::RecordInvalid.new(answer), "Error: Answer ID#:".concat(answer.id.to_s).concat(" on Test ID# ").concat(@exam.id.to_s).concat(" failed to destory! <br /> Contact Administrator for help! ") end end if !question.destroy #printf ("Question %s on Section did not destroy!\n", question.id.to_s)...
2019 Aug 13
4
Configure DHCP to update DNS records with BIND9
...ME.LAN. <http://HOME.LAN.> "; ddns-rev-domainname "0.168.192.in-addr.arpa."; option ntp-servers 192.168.0.1; pool { range 192.168.0.100 192.168.0.200; } } on commit { set noname = concat("dhcp-", binary-to-ascii(10, 8, "-", leased-address)); set ClientIP = binary-to-ascii(10, 8, ".", leased-address); set ClientDHCID = concat ( suffix (concat ("0", binary-to-ascii (16, 8, "", substring(hardware,1,1))),2), ":", suffix (c...
2007 Jul 10
0
Plot dies with memory not mapped (segfault) (PR#9785)
..., "DATEDIFF(MAX(FROM_UNIXTIME(submit_time)),MIN(FROM_UNIXTIME(", "submit_time))) DAY FROM ",systems[iter],") ",sep="") if(QUERY_DATE=="Year") { usageAVGQuery<-paste("SELECT STR_TO_DATE(CONCAT(YEAR(FROM_UNIXTIME(dispatch_time)),'-01-01'),'%Y-%m-%d') AS date, AVG(cpu_seconds_user/total_time) AS time, AVG(num_cpus) AS AVG_CPUs, AVG(dispatch_time-end_time) AS AVG_job_length FROM ",systems[iter],usageDateClamp,"GROUP BY date;",sep="")...
2005 Dec 27
13
<%= works, print doesn''t
In my views, for example list.rhtml, if I try: <%= "test" %> everything works fine. If I try: <% print "test" %> then instead of outputting the page, the browser displays the HTML source code. Any ideas on what my problem is? This is my first RoR app so it''s probably a stupid bug on my part, but my Google-fu isn''t powerful to track down
2011 Feb 01
2
override not working
...imap { mail_plugins = quota imap_quota trash expire autocreate } Using the following password/user queries: password_query = SELECT username as user, password, if('%d'='virttest2.xxx.net', 'acl imap_acl',null) as mail_plugins, concat('/var/vmail/%d/', maildir) as userdb_home, concat('maildir:/var/vmail/%d/', maildir) as userdb_mail, 101 as userdb_uid, 502 as userdb_gid, CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM mailbox WHERE username = '%u' user_query = SELECT maildir, if...
2014 Dec 09
2
Quota issue with mailbox.
...ted: Quota exceeded (mailbox for user is full) *[root at sentinel dovecot]# grep -v '^ *\(#.*\)\?$' dovecot-mysql.conf* driver = mysql connect = host=localhost dbname=postfix user=postfix password=xxxxxxxx default_pass_scheme = MD5-CRYPT password_query = SELECT username as user, password, concat('/home/vmail/', maildir) as userdb_home, concat('maildir:/home/vmail/', maildir) as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1' user_query = SELECT concat('/home/vmail/', maildir) as home, concat(...
2007 Jul 24
1
blocks using concat do not work inside helper
Hi, I wrote this ticket yesterday and it had been deleted and marked as invalid http://dev.rubyonrails.org/ticket/9066 Ticket: ----------------------------------------------------------------------- When I try to do this from a helper: def foo(&block) concat "<div>", block.binding yield concat "</div>", block.binding end def bar(&block) concat foo {"content"}, block.binding yield end I get this error undefined local variable or method `_erbout'' for ... Using "foo" without &qu...
2015 Sep 13
2
no login with MySQL
...e userdb query from > mysql > > home: /srv/mail/%u > mail: /srv/mail/%u/Maildir The query-strings for virtual users look like this: password_query = SELECT username AS username, password FROM mailbox WHERE username = '%u' AND active = 1 user_query = SELECT maildir, uid, gid, concat('*:storage=', quota) AS quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM mailbox WHERE username = '%u' There is no mail_loation defined. I thought if maildir is queried, the %u would expand to the mail_location of the user. Where the users only with th...
2006 Jan 10
7
All My Rails Apps Died Over the Holidays
I have several Rails (version 1.0) apps I''m working on on a Win XP box using Webrick that were working fine before I left for the holidays. I came back, started up and they all get the same syntax and compile errors: compile error ./script/../config/../app/views/time/list.rhtml:4: Invalid char `\212'' in expression repeated over and over. Refreshing the page gives thes same
2007 Feb 19
2
NTLM oddities
...service=POP3 lip=204.17.177.60 rip=209.33.215.142 resp= dovecot: Feb 19 16:15:56 Info: auth(mail.infowest.com): client out: CONT 1 dovecot: Feb 19 16:15:56 Info: auth-worker(mail.infowest.com): sql(John, 209.33.215.142): query: SELECT a.clearpasswd AS password, v.storeIP AS host, CONCAT(IF('John' LIKE '%@%.%',CONCAT(LCASE('John'),''),CONCAT(LCASE('John'),'@',p.host)),'*masteruser') AS destuser, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS proxy, 'masterpass' AS pass FROM iwmailsystem.virtmailbox AS v...
2013 Jul 17
2
Dovecot 2.2.4/sendmail with sql user and aliases
...ssion_host = localhost:25 userdb { args = /vdl/etc/dovecot/dovecot-sql.conf driver = sql } protocol imap { mail_plugins = quota imap_quota mail_log notify } protocol pop3 { mail_plugins = quota } protocol lda { mail_plugins = quota sieve } dovecot-sql.conf password_query = SELECT \ concat(s_courriel_utilisateur.utilisateur, '@', s_courriel_domaine.nom) AS user,s_courriel_utilisateur.password as password \ FROM s_courriel_utilisateur left join s_courriel_alias on s_courriel_utilisateur.id=s_courriel_alias.utilisateur and s_courriel_alias.archive !=1 ,s_courriel...
2007 May 28
2
helper with block compile error
..., i''m trying to write a helper that replaces link_to_remote that accepts a block but it gets a compile error in the template: I don''t know what I''m doing wrong... TIA # application_helper.rb def link_block_to_remote( options = {}, html_options = {}, &block) concat(link_to_remote(capture(&block), options, html_options), block.binding) end # in template <% link_block_to_remote {:url => { :action => :start_login } }, { :href => url_for( { :action => :start_login }), # when degraded...