5,104 reputation
1132
bio website alexclear.livejournal.com
location Mother Russia
age 36
visits member for 3 years, 5 months
seen yesterday

An experienced software developer with a bit of sysadmin background. Can't dance.


Feb
4
comment introduction to replication
You are welcome, my email is alexclear@gmail.com
Feb
4
comment smtp sasl authentication failure
Glad to hear you managed to solve it!
Feb
4
comment HA Proxy won't load balance my web requests. What have I done wrong?
What does a stats page show? Is one of the backend servers in down state?
Feb
4
comment copy all *.mkv in subdirectories to parent directory
You are right guys. Edited a command to add a trailing slash. Yep, mv has more sense, but the task was to copy files for some reason.
Feb
4
comment File does not exist: /htdocs
Could you please post content of /etc/apache2/sites-available/default?
Feb
4
comment introduction to replication
Do you have any specific data integrity requirements? Should the replication be synchronous or asynchronous, e.g. can you commit your transaction before the record is inserted on the second server?
Feb
3
comment is it really necessary to run Apache as a front-end to Glassfish/JBoss/Tomcat?
Well, multithreaded Apache still uses synchronous I/O. I don't see big difference if threads not processes will be blocked on a socket by slow clients. Nginx is designed as single-threaded single-process finite state machine (well, not necessary single-process, number of processes should be set to number of CPU cores on a multi-core system).
Feb
3
comment is it really necessary to run Apache as a front-end to Glassfish/JBoss/Tomcat?
Actually, the problem is broader than just serving static content because if your server does not use async I/O clients with slow connections will block server's execution threads until they got the content in full. So, having an AIO-powered frontend is a benefit in any case. But, as I already mentioned, Tomcat has AIO capabilities. I think stock Glassfish package already includes AIO library, so you probably should not bother.
Feb
3
comment smtp sasl authentication failure
As you can see from the detailed postfix log, it tried DIGEST-MD5 SASL mechanism first, then fell back to the LOGIN SASL mechanism. If you use auxprop plugin with the LOGIN mech, your MySQL query should return a plaintext password.
Feb
3
comment smtp sasl authentication failure
Okay, you are using the auxprop plugin to provide SASL with a connection to the MySQL server. This plugin does not support encrypted or hashed passwords as stated here: "If you must store encrypted passwords, you cannot use the sql auxprop plugin. Instead, see section "Using saslauthd with PAM", and configure PAM to look up the encrypted passwords with, for example, the pam_mysql module. You will not be able to use any of the methods that require access to plaintext passwords, such as the shared-secret methods CRAM-MD5 and DIGEST-MD5"
Feb
3
comment smtp sasl authentication failure
Hmm, I'm a bit confused here, are you saying that the password is stored in the DB in the encrypted form? But it looks like you are using a plain authentication method on SASL side, so there should be some kind of conversion from plain to encrypted somewhere between SASL and MySQL storage. Do you use a kind of hashing algorithm right in the SQL query?
Feb
3
comment Connecting to SQL Server with PHP on Mac
Have you tried to use an 'IP:port' format for the 'hostname'?
Feb
3
comment VirtualBox - difference in actual and virtual size of a disk
Solaris commands should be basically the same, not sure if dd supports seek parameter under Solaris, you can use dd if=/dev/zer0 of=add.raw bs=1024 count=10000000 if it does not. It will take some time since this command creates a 10G file on disk. You can use a lower count value if it is enough for you.
Feb
3
comment postfix SMTPD relay problems while sending
You can test sending from an outside using a port different from 25 temporary. Ports are configured in /etc/postfix/master.cf The default port is defined in this line: smtp inet n - - - - smtpd You should change the first smtp to some other numerical value, like this:1025 inet n - - - - smtpd (It will use port 1025 then)
Feb
3
comment postfix SMTPD relay problems while sending
I don't think all is a proper configuration value for mynetworks, it should be 0.0.0.0/0 if you want to enable any IP to send email through your MTA. Actually, you don't want to enable anyway, because setting it to 0.0.0.0/0 will effectively turn your MTA to an open relay. That's not a good idea since every spammer will be able to utilize your open relay to send SPAM. It's better to leave mynetworks set to 127.0.0.0/8.
Feb
3
comment shorewall on debian proxy server troubleshooting
Probably forwarding is disabled at your Debian host, you should check /etc/shorewall/shorewall.conf and set IP_FORWARDING=On there
Feb
2
comment MySQL write intensive setup, kjournald performs a lot of I/O
To put stats tables in memory was an awesome idea, thank you! That saved a lot of I/O.
Feb
2
comment MySQL write intensive setup, kjournald performs a lot of I/O
I don't care about FS consistency too much, I'm going to set up MySQL replication anyway. And it's OK to lose data for several seconds if a master node fails.