search for: sql

Large for loops are slow. Try to avoid them using apply, sapply, etc. I've made the paste statements a lot shorter by using collapse. See ?paste for more info. Append.SQL <- function(x, channel){ sql="INSERT INTO logger (time, v1, v2, v3, v4, v5, v6, v7, v8, v9, v10) VALUES("d1=strptime(x[2],"%d/%m/%y %H:%M:%S %p '", d1, "' ,", paste(x[3:12], collapse = ", "), ")" ) sqlQuery(channel, sql) } ntry=dim(...

I am trying to find where the authoritative sql definitions for Asterisk Realtime Architecture ARA are located. I have found many locations but each and everyone seems to be different. http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example Files...

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFo...

Hi All, I am trying to install Dovecot connecting to MySQL and all seems to be working until I try to send/receive. I'm getting a "Unknown setting" error for anything that is inside dovecot-sql.conf.ext dovecot-sql.conf.ext is inside /etc/dovecot and is referenced from /etc/dovecot/conf.d/auth-sql.conf.ext The error I get is:...

...read an vignette, and calls something like vignette("mle2", package="bbmle") the pdf file opens (for me in Foxit reader), no problem, but then emacs starts to spew a lot of spam, interfering with the use of ess/R. A small sample: ScheduleTimerQuery called GetDntDataTotal sql exec success GetDntDataQueue sql exec success SchedulePriorTracktype called GetDntDataPriorQueue sql exec success SchedulePriorTracktype called GetDntDataPriorQueue sql exec success SchedulePriorTracktype called GetDntDataPriorQueue sql exec success ScheduleTimerQuery called GetDntDataTotal sql exe...

I wasted some time yesterday and today implementing a SQL storage plugin. It seems to be working, but: - Saving new messages is done in a regular INSERT statement, which is bad. PostgreSQL has at least this COPY TO command which could be used instead. - It breaks in stress testing - It's not that well optimized. Especially it could support caching...

I'm transitioning someone's quite old server [Debian] to a new CentOS6 host. All going pretty well. But they server up some functionality using CGI scripts via Apache that use something referred to on the Debian box as the www-mysql package? This a binary that executes HTML pages containing embedded SQL statements. Anyone know where the source for this can be found or if it has a more specific name? The 'helpfulness' of search engines is getting in the way of finding the provenance of this code. -- System & Ne...

rly there would be a heavy penalty to launching a shell so you would want t= o carefully evaluate the frequency this is executed on your system.<br /> <div class=3D"container"> <div class=3D"line number1 index0 alt2"><code class=3D"sql plain"><br /> DELIMITER @@</code></div> <div class=3D"line number2 index1 alt1">&nbsp;</div> <div class=3D"line number3 index2 alt2"><code class=3D"sql keyword">CREATE<= /code> <code class=3D"sql keywo...

...rder => ''count DESC''}.merge(options) o, t, o_pk, o_fk, t_pk, t_fk = table_name, tag_model.table_name, primary_key, taggable_foreign_key, tag_model.primary_key, tag_foreign_key jt = tags_join_model ? tags_join_model.table_name : tags_join_table sql = "SELECT #{t}.#{t_pk} AS id, #{t}.name AS name, COUNT(*) AS count FROM #{jt}, #{o}, #{t} WHERE #{jt}.#{t_fk} = #{t}.#{t_pk} AND #{jt}.#{o_fk} = #{o}.#{o_pk}" sql << " AND #{sanitize_sql(options[:conditions])}" if options[:conditions]...

Currently using 2.0.12, configured the auth-sql.conf to look like this for password lookups (doing smtp auth with postfix, so I am not actually running pop or imap, just auth): passdb { driver = sql connect = host=server.net dbname=passwd user=sqluser password='password' default_pass_scheme = CRYPT password_query = SELECT CONCAT...

Hi, using dovecot 2.0 and I'm using a couple of user DBs, sql/prefetch and pam. Currently if the user logins with username at domain it authenticates off the sql DB and works fine. If the user logins with username with no @domain it fails on the sql lookup and succeeds on the pam user DB. However I was wondering if I can have another sql DB lookup that says...

Dear list,   Dear list, I am using read.csv.sql() from the sqldf package to read individual-based data from a csv file that is too large for R. My original file contains a column called “ID” that identifies the individual. I would like to read in data for only one individual at a time, for example "Bobby". read.csv.sql("filenam...

Hello Is it possible to setup double backend ? ldap for auth only and SQL for userdb information(quota,maildir etc) ? Now I'm using SQL backend and configuration looks like this: passdb { driver = sql args = /etc/dovecot/dovecot-sql.conf } userdb { driver = prefetch } userdb { driver = sql args = /etc/dovecot/dovecot-sql.conf } Can I do something like: pas...

I see some possible issues with the SQL that is being generated by the firebird adapter. Every SQL is being generated on the fly by concatenating strings. Can someone please explain why the SQL is being generated the way it is? I cannot use this in real life for a couple of reasons: 1. This introduces a security hole because a use...

...e wasted your time. The text editor I am using (Ultraedit) is adding a BOM (Byte Order Marker) to the beginning of the file. I have disabled this in settings but it keeps doing it. Thank you so much for pointing me in the right direction. After removing the 3 invisible characters from the dovecot-sql.conf.ext file it magically worked. Andy -----Original Message----- From: Aki Tuomi [mailto:aki.tuomi at open-xchange.com] Sent: 20 February 2020 11:26 To: Andy Woolley <andy at milonic.com> Subject: Re: Unknown setting error with dovecot-sql.conf.ext I am unable to reproduce the issue...

Hello, I have 2 databases MySQL. I would like to do that: If the user does not existe in the first base, it goes in the second database. my configuration auth default { mechanisms = plain passdb sql { args = /etc/dovecot-sql-1.conf } passdb sql { args = /etc/dove...

I am trying to get * to write CDR records to an MS SQL table. I am used the freeTDS set up (not using UNIX ODBC), and it appears to be making the connection to the database, but I make a call, I get this error: WARNING[3369]: cdr_tds.c:180 tds_log: Reconnected to SQL database. ERROR[3369]: cdr_tds.c:191 tds_log: Failed to insert Call Data Records int...

AOA Dear friends we have a Windows 2003 network. I want to run VB6 Applications in Ubuntu 10.10 under Wine. So far I have managed to run the Application by running the exe of the application through Wine but the application cannot access the database which is SQL-Server 2000 and this SQL server is running on Win2003 Operating system and the name of this machine is "webserver" and its ip is 192.168.41.87. Actually the developer has used either machine name or ip in the code. How can this be configured so that Wine can see it and able to read and...

Hi, I have a Dovecot test installation with MySQL userbase and authentication where I am trying to setup last_login plugin with SQL dictionary I read http://wiki2.dovecot.org/Plugins/LastLogin and I addes this to my configuration plugin { last_login_dict = sql:/etc/dovecot/dovecot-sql.conf.ext } mail_plugins = $mail_plugins stats protocol...

Hello Everyone,   I'm still quite new to R and am having trouble reading SQL Server Tables using RODBC. I've looked though the RODBC documentation as well as material I found online and in the book "Data Manipulation with R," but I just can't quite seem to get things to work.   Right now, I have code that looks something like:   channel <- odbcDriverCon...