UPDATE table SET field = replace( field, ‘needle’, ‘replacewith’ ) ;
I need to stop and smell the roses in life. So this first blossom of spring I noticed out side of IM as Lind G was also admiring was my wake up call. February and early March have been pretty rough. These cuties were what I needed that day to remind me of God’s creation amidst my stormy weather.
DNS issues
Migration: Gotta make sure DNS is all aligned. This is plaguing me. Gotta get it right the 1st time!!
Plesk:
• Edit /var/named/run-root/var/domainname.com to reflect correct SOA and NS records also A records.
• Increment the record!!!
• Make sure to restart the named with something like /etc/init.d/named restart
cPanel:
• Be sure to add in webmail subdomain as stated here.
Caching server (local )
For testing consider editing hosts file as mentioned in earlier post or manual enter on caching server.
Nameservers 1 and 2:
Change the SOA for the slave files and apply settings check to see that record is updated.
Check KLOTH.NET for updated values as outside source/verification.
Webmail on a cPanel linux box
Found a resource at http://support.lunarpages.com/knowledge_bases/article/20 for my webmail problem.
1. Create subdomain: webmail.domain.com
2. add .htaccess file below to forward to to horde email. Even non-https. Yeah!!
To Redirect to the Horde Webmail Client:
RewriteEngine on
RewriteCond %{HTTP_HOST} ^webmail.yourdomain.com$ [OR]
RewriteCond %{HTTP_HOST} ^www.webmail.yourdomain.com$
RewriteRule ^(.*)$ http://yourdomain.com:2095/horde/$1 [R=301,L]
To Redirect to the Squirrel Mail Client:
RewriteEngine on
RewriteCond %{HTTP_HOST} ^webmail.yourdomain.com$ [OR]
RewriteCond %{HTTP_HOST} ^www.webmail.yourdomain.com$
RewriteRule ^(.*)$ http://yourdomain.com:2095/3rdparty/squirrelmail/index.php$1 [R=301,L]
Secure ya want????
You can also use a secure login to the webmail as well, for the line:
RewriteRule ^(.*)$ http://yourdomain.com:2095/horde/$1 [R=301,L]
change this to:
RewriteRule ^(.*)$ https://yourdomain.com:2096/horde/$1 [R=301,L]
same applies for Squirrel Mail:
RewriteRule ^(.*)$ http://yourdomain.com:2095/3rdparty/squirrelmail/index.php$1 [R=301,L]
change this to:
RewriteRule ^(.*)$ https://yourdomain.com:2096/3rdparty/squirrelmail/index.php$1 [R=301,L]
Migration steps
Migrating from Plesk to cPanel
Consider:
Setup Account primary login has shell and sftp abilities.
Use sftp instead of ftp.
Setup mx records in mail area of cPanel. Note server type should be local.
Email passwords can’t be migrated….not yet. Looking into that….
Add redirects as forwarders. Aliases as forwarders. Dist list as multiple forwarders on same address,
Tar up the httpdocs directory and sftp to the cPanel server. Extract to the www or public_html directory.
chmod 755 -R public_html/*
export databases on Plesk and download to desktop pc. Make sure to decompress as cPanel phpmyadmin does’t like the compressed version.
Create the db in cPanel mysql databases and set user and password. be sure to link the user to the db.
Import the sql you downloaded in phpMyAdmin.
ALT: export using mysqldump -p -u root tablename > tablename.sql
tar czf tablename.sql.tgz tablename & sftp to new server
tar xzf tablename.sql.tgz
import using mysql -p -u root newtablename < tablename.sql
Edit the config file of your wrdpress install (wp-config.php) reflecting the db,use,pass) credentials you used.
If using the wordpress permalink option be sure to use the hybrid version (see in previous post).
Make sure the dns is set in the masters servers.
Double check the mx local setting as it got reset on me couple of times unbeknownst to me. big pain.
Check firewall to make sure the server can be connected to by posting.
Set POSTINI redirect email to this server
Check to see if email is flowing in.
Might use /private/etc/hosts (mac) or c:\windows\system32\drivers\etc\hosts (windows) to pre-view/test site before dns switch.
xx.xx.xx.xx domain.com
Places of files:
named: /var/named /etc/named.conf
mail: /home/1stusername/domainname.com/mail/username/new & cur
mail pass: /home/1stusername/domainname.com/etc/….
cPanel DNS – MX records
Their simple dns is not worth much. Gotta alays remember to use the advanced. BTW MX records are not changed in the DNS area but the email area. OOOkkkk.
So I had my domain sanjuanweb.com setup. AND I did receive email there. Not sure what changed there and how. But the DNS MX record slipped from being postini.com to being self.
So since that “slip” I have not recieved email at sanjuanweb.com. BECAUSE postini has me lock down port 25 (the port email would get delivered to) and only allow email from postini on port 25
MX 0 sanjuanweb.com.s5a1.psmtp.com.
MX 15 sanjuanweb.com.s5a2.psmtp.com.
MX 30 sanjuanweb.com.s5b1.psmtp.com.
MX 45 sanjuanweb.com.s5b2.psmtp.com.
but the MX was
MX 0 sanjuanweb.com
Not sure why it slipped. hmmmm. Storm support has been email me about port 25 not working…nah.
StormOnDemand – Migration
Moveing to a StormOnDemand webserver. Uses cPanel. I’m freindly with a Plesk cp and the cPanel is a bit of a change for me. Nice to stretch but wow lots to consider.
1st note:
WordPress permalinks .htaccess mess up the ability to have .htaccess files in other directories. Good head ache this. The solution for now isnot much different from the wordpress derivative. but it appears to work.
WordPress verision:
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ – [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress
Modified version:
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ – [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} (/|\.htm|\.php|\.html|#.*|\?.*|/[^.]*)$ [NC]
RewriteRule ^(.*) /index.php [L]
</IfModule>
# END WordPress
So whats the diff? Hmmm…
Church Library Ceiling Leak
Hi Gary and Dick,
Below is what I found in the church libtrary. The video is tough to see but gives reference. The two images have better detail.
