search for: sqls

Displaying 14 results from an estimated 14 matches for "sqls".

Did you mean: sql
2014 Feb 10
1
Rsync performance with large exchange database files
...noticed it on these other servers since they have a much smaller amount of data to backup? Still seems like some thing is wrong. I wouldn't expect the speed difference to be that huge. ------ Original Message ------ From: "Cary Lewis" <cary.lewis at gmail.com> To: bruce at sqls.net Sent: 2/10/2014 3:56:35 PM Subject: Re: Rsync performance with large exchange database files >when you were doing rsync from /cygdrive/c to /cygdrive/d was the >exchange file already there? Or was it clean copy? > >On Mon, Feb 10, 2014 at 4:03 PM, <bruce at sqls.net> wrote: &...
2005 Oct 27
2
Problems with dual ldap auth
Hi, I can't seem to figure this out. Is it impossible to use two different ldap auth? It works if I use one ldap and one pam, but I do need to use ldap for both. This is from my config: auth default { mechanisms = plain passdb ldap { args = /etc/dovecot/ldap-virtual.conf } passdb ldap { args = /etc/dovecot/dovecot-ldap.conf } userdb ldap { args =
2019 May 22
3
Dict issue with PostgreSQL for last_login plugin (duplicate key)
On 21/05/2019 15:45, mabi via dovecot wrote: > ??????? Original Message ??????? > On Monday, May 20, 2019 12:37 AM, John Fawcett via dovecot > <dovecot at dovecot.org> wrote: > >> So looking into this with a postgresql databse to work with: the >> above query does not work. You have to specify either the column name >> or the constraint name that you expect to
2019 May 23
0
more generic approach as for userdb? (was: Dict issue with PostgreSQL for last_login plugin (duplicate key))
...ttp://www.postgresqltutorial.com/postgresql-upsert/ > Constraint names are nowhere specified in the dictionary map syntax and > it's not possible either to identify with 100% certainty the primary key > column(s). One could dive into Postgres-specifics to get it, but there are other SQLs, too; the quota plugin advertises to use TRIGGERs to turn an INSERT into an UPDATE silently, which is no general approach either. https://wiki2.dovecot.org/Quota/Dict > 1) logic which always tries to update and falls back to insert if the > update fails (or viceversa) for all sql dictionari...
2006 Mar 10
0
ODBC to Web Service -- any advice?
...this access via a Web Service and then write an ODBC adapter to communicate to that Web Service? There is a lot of documentation for -using- ODBC adapters, but I haven''t seen much on -writing- one. Does anyone have any leads I could check out? Also, ODBC seems more tuned to work with SQLs. Abstracting that into a Web Service seems a bit awkward. Is there another solution? The software I''m trying to connect to my database speaks ODBC and ADO.NET. (After reading, I realize this may be off-topic, though my app is written in rails. Any suggestions for a better group to...
2005 Aug 25
0
[Fwd: Re:Dovecot] Finally PEBKAC was Failed authentication to a mysql database (bug or PEBKAC?)]
...f > > } > > passdb sql { > > args = /etc/dovecot/dovecot-mysql_django.conf > > } > > This should work. After trying to authenticate against the first one it > should try the second. Although I'm not sure if I've tried two passdb > sqls before, maybe Dovecot has problems with that.. Well, I'll try once > I get home. I'm working on this problem, but at the moment it doesn't work. It always connects only to second db. Another PEBKAC? This is my configuration file, maybe there's something wrong. (i've cut out c...
2006 Jul 17
2
Trouble with has_one
...(has_many) images POST (has_one) header When I try to create a header for a post, I get: You have a nil object when you didn''t expect it! You might have expected an instance of ActiveRecord::Base. The error occured while evaluating nil.create >From development log I could see that the SQLs built in case of has_many and has_one differ. has_one has LIMIT 1 attached. Is that the reason why this is failing? How to get around this? -- Posted via http://www.ruby-forum.com/.
2006 Dec 25
1
Urgent - Setup DoveCot with Plesk
...am trying to setup DoveCot with Plesk. But I could not go through the last step. Setup: MySQL 5.0.22 Qmail Plesk 7.5 DoveCot v1.0 RC15 The problem: I setup sql.conf for user query and password query. I tried different ways, DoveCot always says "Authentication failed". Here are my two SQLs. user_query = SELECT concat('/var/qmail/mailnames/', d.name, '/', m.mail_name) as home, concat('/var/qmail/mailnames/', d.name, '/', m.mail_name) as mail, 101 AS uid, 12 AS gid, 'dirsize:storage=1000000' AS quota FROM accounts a, mail m, domains d WHERE a.id...
2009 Nov 11
2
Slow IMAP Auth
Hello, I am experiencing IMAP authentication delays when a client first authenticates, or after the last auth timeout. There are only a handful of clients - less than 5 - using the server. I am using a mysql database and I have verified the PAM auth is commented out. Other than that I can't figure out what might be causing the slow authentication. The first time a client authenticates
2006 Nov 01
1
Windows != Samba - NETBIOS name handling
...created by Samba in Active Directory via "net ads join", then used by UNIX clients to authorise and authenticate via LDAP and Kerberos. Samba works perfectly until the computers hostname is longer than 15 characters. Then any attempt to join the domain fails with: ---- [root@uk1-sysstg-sqlsyslogtest etc]# net ads join -U Administrator Administrator's password: [2006/11/01 13:14:34, 0] libads/ldap.c:ads_join_realm(1763) ads_join_realm: ads_add_machine_acct failed (uk1-sysstg-sqlsyslogtest): Internal (implementation specific) error ads_join_realm: Internal (implementation specific...
2014 Feb 10
1
Rsync performance with large exchange database files
I'm using a mixture of FreeBSD w/ ZFS+snapshots and rsync to backup all the servers at my day job. This works pretty good overall but on one server it's not working so well :) We have an Exchange 2003 server with 4 separate mail store databases. One of them is roughly 900GB the others are ~200GB, ~160GB, and ~50GB. Rsync seems to spend a lot of time trying to find the differences in
2006 Aug 02
4
Struts
I have a STRUTS based webapp and I want to port it to RUBY/RAILS... Can anyone suggest a migration strategy...I would like to migrate my struts actions over time if possible. Jim _________________________________________________________________ Is your PC infected? Get a FREE online computer virus scan from McAfee® Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
2006 Jun 04
20
Proposal of some radical changes to API
Hey guys, Now that the Lucy[1] project has Apache approval and is about to begin, the onus is no longer on Ferret to strive for Lucene compatability. (We''ll be doing that in Lucy). So I''m starting to think about ways to improve Ferret''s API. The first part that needs to be improved is the Document API. It''s annoying having to type all the attributes to
2010 Mar 04
25
how to share variables in data migrations (up/down)
hi there, How do we share variables in a given data migration? For example, the code below fails to work because "statuses" don''t seem to be in scope for both up and down. class AddDefaultValuesToStatuses < ActiveRecord::Migration statuses = [ { ''details'' => ''details'', }, {