According to the comments on my other question, it's more than possible that the reason my MD RAID array is performing poorly is because my RAID5 array has 5 data disks. I've tried searching for information on why this is, but haven't found anything, so I'm looking for more information about why this is, and what sort of impact it can have versus having 4 data disks.
Matthew Scharley's questions
The title pretty much sums in up. Local mail is working fine via LMTP, however non-local mail (virtual hosting) is struggling. I've provided as much information below as possible, trying to keep it relevant. I can't figure out what is going wrong here.
Things I've verified:
example.com
is in{VirtHost}
- It is trying to deliver via my mailer, not
local
(thoughlocal
is delivering to LMTP too, and is working perfectly). Verified via log and changing the LMTP socket for virtual mail only (see below).
Mailer specification:
Mdovecot, P=[IPC], F=SXmnz9,
S=EnvFromSMTP/HdrFromL, R=EnvToSMTP/HdrToL, E=\r\n,
T=DNS/RFC822/SMTP,
A=FILE /var/run/dovecot/lmtp
SMTP conversation:
$ telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 mail.example.com ESMTP Sendmail; Mon, 31 Oct 2011 23:29:54 GMT
EHLO localhost
MAIL FROM: [email protected]
RCPT TO: [email protected]
DATA
To: [email protected]
From: [email protected]
Subject: Hello world!
Hello there, everyone!
.
quit
250-mail.example.com Hello localhost [127.0.0.1], pleased to meet you
250-ENHANCEDSTATUSCODES
250-PIPELINING
250-8BITMIME
250-SIZE
250-DSN
250-ETRN
250-DELIVERBY
250 HELP
250 2.1.0 [email protected]... Sender ok
250 2.1.5 [email protected]... Recipient ok
354 Enter mail, end with "." on a line by itself
250 2.0.0 p9VNTswi016356 Message accepted for delivery
221 2.0.0 mail.example.com closing connection
Connection closed by foreign host.
Resulting LMTP conversation:
# socat -v UNIX-LISTEN:lmtp-socat UNIX-CLIENT:lmtp
< 220 mail.example.com Dovecot LMTP ready\r
> LHLO mail.example.com\r
< 250-mail.example.com\r
< 250-8BITMIME\r
< 250-ENHANCEDSTATUSCODES\r
< 250 PIPELINING\r
> MAIL From:<[email protected]>\r
< 250 2.1.0 OK\r
> RCPT To:<>\r
> DATA\r
< 550 5.1.1 <> User doesn't exist: \r
< 554 5.5.1 No valid recipients\r
> RSET\r
< 250 2.0.0 OK\r
> QUIT\r
< 221 2.0.0 Client quit\r
Sendmail address translation (I think this is the way the internal processing works, someone correct me if not and I'll fix this):
$ sendmail -bt
ADDRESS TEST MODE (ruleset 3 NOT automatically invoked)
Enter <ruleset> <address>
> 0,3,EnvToSMTP [email protected]
parse input: mscharley @ example . com
Parse0 input: mscharley @ example . com
Parse0 returns: mscharley @ example . com
ParseLocal input: mscharley @ example . com
ParseLocal returns: mscharley @ example . com
Parse1 input: mscharley @ example . com
Parse1 returns: $# local $: mscharley @ example . com
parse returns: $# local $: mscharley @ example . com
canonify input: $# local $: mscharley @ example . com
canonify returns: $# local $: mscharley @ example . com
EnvToSMTP input: $# local $: mscharley @ example . com
EnvToSMTP returns: $# local $: mscharley @ example . com
I'm trying to install Cyrus with SASL for authentication. I'm struggling getting logins to work properly though. I'm trying to setup virtual hosting, as we'll have several domains worth of email on this host.
In my imapd.conf:
sasl_pwcheck_method: auxprop
virtdomains: true
defaultdomain: fqdn.example.com
From sasldblistusers2
:
[email protected]: userPassword
I have a mailbox called user.matt
, and I tried creating [email protected]
and I got an error saying the mailbox already exists. With this setup, I am able to login using imtest localhost -m DIGEST-MD5 -a matt
, however I am unable to using imtest localhost -m DIGEST-MD5 -a [email protected]
. There is also not a UNIX user called matt
on the system. Does anyone have any idea what I am missing?
Exact error from syslog:
imap[23310]: badlogin: localhost [127.0.0.1] DIGEST-MD5 [SASL(-13): user not found: no secret in database]
I run an Ubuntu test server, and my deployment system is also Ubuntu.
I've recently been trying to get ASP.NET to work on my test server so that we can take it live. I managed to get it installed, and configured properly, and my application is installed and running, but I can't get anything to work.
The error I keep receiving is below, if anyone has any clue what might be going on, it would be greatly appreciated.
Server Error in '/' Application
Standard output has not been redirected or process has not been started.
Description: HTTP 500. Error processing request.
Stack Trace:
System.InvalidOperationException: Standard output has not been redirected or process has not been started. at System.Diagnostics.Process.CancelErrorRead () [0x00000] at (wrapper remoting-invoke-with-check) System.Diagnostics.Process:CancelErrorRead () at Mono.CSharp.CSharpCodeCompiler.CompileFromFileBatch (System.CodeDom.Compiler.CompilerParameters options, System.String[] fileNames) [0x00000] at Mono.CSharp.CSharpCodeCompiler.CompileAssemblyFromFileBatch (System.CodeDom.Compiler.CompilerParameters options, System.String[] fileNames) [0x00000] at System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromFile (System.CodeDom.Compiler.CompilerParameters options, System.String[] fileNames) [0x00000] at System.Web.Compilation.AssemblyBuilder.BuildAssembly (System.Web.VirtualPath virtualPath, System.CodeDom.Compiler.CompilerParameters options) [0x00000] at System.Web.Compilation.AssemblyBuilder.BuildAssembly (System.Web.VirtualPath virtualPath) [0x00000] at System.Web.Compilation.BuildManager.BuildAssembly (System.Web.VirtualPath virtualPath) [0x00000] at System.Web.Compilation.BuildManager.GetCompiledType (System.String virtualPath) [0x00000] at System.Web.HttpApplicationFactory.InitType (System.Web.HttpContext context) [0x00000]
Version information: Mono Version: 2.0.50727.42; ASP.NET Version: 2.0.50727.42
Apache version String: Apache/2.2.11 (Ubuntu) mod_mono/2.0 PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch Server at dev Port 80
PS: I had to add three DLL's to the /bin
directory in my application, copying them from Windows because I couldn't find them in any of Mono's packages. This might or might not be causing problems, I don't know. The list that I had to add is:
- System.Web.Abstractions
- System.Web.Routing
- System.Web.Mvc
I've been tasked with moving us from one decade old system (Access '97) to a brand new system using MS SQL Express 2008 as a backend. So great, I know I can connect to the database (successful with a read-only user), the only problem is... I don't have a user in the database with write access, and we don't have source access to the application to know what password the application uses (though, I do have the username).
So, as I can see it, I have two options:
- Recover the password for the user the application uses in a non-destructive (or undoable) manner.
- Insert an extra administrative user to the database that I can then use as a data import user.
Are either of these options viable and/or possible, and how would I go about one or both of them, given the fact that I am sitting infront of the computer with full access to do whatever.
Long story short, I have a SQL file that I want to import as a skel
style file, so this will be done repeatedly, programmatically. I can edit the SQL file however I want, but I'd rather not touch the application itself.
This application uses userid = 0
to represent the anonymous user. It also has a relevant (blank) entry in the database to represent this 'user'. Hence, the line in my skel.sql
looks something like this:
INSERT INTO `{{TABLE_PREFIX}}users` VALUES (0, '', '', '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, NULL, '', '', '', NULL);
The problem with this is that uid
is a auto_increment
field, for which, technically, 0
is an invalid value. Or atleast, if you set it to 0, you're basically telling MySQL, "Please insert the next id into this field."
Now, I suppose I could put an INSERT
then an UPDATE
query into my SQL file, but is there a way of telling MySQL in general that yes, I actually want to insert 0
into this field?