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'',
},
{