xml tools

http://www.freeformatter.com/xml-validator-xsd.html – online tool for validating an xml file against an xsd
http://www.validome.org/grammar/validate/ – online xsd and dtd validator
http://www.xmlforasp.net/CodeBank/System_Xml_Schema/BuildSchema/BuildXMLSchema.aspx – online xsd generator

in linux, i was able to generate a DTD from an xml file by using the trang utility.

Posted in: IT by resinblade No Comments

windows 2008 file share: ABE

ben told me about access-based enumeration (ABE) in 2009. it allows folders that a user does not have explicit access to on a file share to remain hidden. so it’s definitely ideal for home directories.

from share and storage management, choose properties for a share then “Advanced” then checkmark “Enable access-based enumeration” to enable the feature.

Posted in: IT by resinblade No Comments

javascript html form validation

very easy to use javascript form validation here:
http://www.javascript-coder.com/html-form/javascript-form-validation.phtml

some more info:
http://icecaves.net/2011/03/process-forms-javascript

Posted in: IT by resinblade No Comments

linux: ext4, advanced format drives

my sheevaplug still has ubuntu 9.04 installed on it. i’ve postponed putting debian on it due to lack of time. anyways, i’ve found that ubuntu 9.04 does not like ext4 nor advanced format drives formatted for 4K sectors.

from what i’ve read, to make sure a drive is set up for 4K sectors use gparted for partitioning and choose the align to MiB option.

verification can be done by running the following:
root@emobile:/home/resinblade# fdisk -lu /dev/sdb

Note: sector size is 4096 (not 512)

Disk /dev/sdb: 3000.6 GB, 3000592977920 bytes
255 heads, 63 sectors/track, 45600 cylinders, total 732566645 sectors
Units = sectors of 1 * 4096 = 4096 bytes
Sector size (logical/physical): 4096 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 4096 bytes
Disk identifier: 0x0005807e

Device Boot Start End Blocks Id System
/dev/sdb1 256 732566527 2930265088 83 Linux

here’s an article stating that there’s some special considerations for western digital green hdds in linux:
https://wiki.archlinux.org/index.php/Advanced_Format

i wish i had known that info prior to my WD drives developing a bunch of bad sectors…
the drives lasted a a little over 2 years.

Posted in: IT by resinblade No Comments

mac os x: miscellania

on a standard PC keyboard: option key = alt key, apple key = windows key

coverage of mac os x server services: http://www.anandtech.com/show/4547/mac-os-x-lion-server-review

services are managed from the server admin tool

removing open directory: run slapconfig -destroyldapserver

VNC can be enabled from System Preferences->Sharing->Remote Management. a VNC password will need to be set.

root password can be reset by booting into single mode (holding apple key and S while powering on). then mounting the root volume with /sbin/mount -wu /. finally, run passwd root

resetting a  system account’s password can be done by booting into Recovery (hold Option key while powering on). once in Recovery, open a terminal and run resetpassword.

changing hostname…i tried every way i could think of, but this was the only method that worked: scutil –set HostName <hostname> 

sources:
http://krypted.com/mac-os-x-server/mac-os-x-server-remove-od/
http://famousphil.com/blog/2011/08/resetting-a-password-on-mac-osx-server/
http://www.macworld.com/article/1164599/reset_password_lion.html
http://osxdaily.com/2010/09/06/change-your-mac-hostname-via-terminal/

Posted in: IT by resinblade No Comments

blackbaud netcommunity: merchant accounts

path to merchant accounts:
administration->merchant accounts

path to donation form merchant account setup:
site explorer->parts->donation forms->payment setup

test credit card numbers are in the blackbaud netcommunity administration guide – pg. 67

Posted in: IT by resinblade No Comments

linux: external drive changing to read-only

had another recent scare with the ext3 file system. this time, fortunately, there was a happy ending. i had an external usb drive that suddenly started behaving strange when i attempted to copy files to it. the file copy was just flat out rejected. i tried unmounting and remounting the drive – same thing. eventually i checked dmesg and saw that every time i attempted a file copy the drive would change to read-only. the error message was “journal was aborted”. i figured that a fsck was in order, but at the same time was afraid to do so because of a certain past experience.

i took precautions by rsyncing the data to another drive. that went okay, all except for one file which gave an input/output error. i tried copying that same file manually and received a similar error. so at this point i was ready to unmount the drive and do a “fsck -y”. originally i did a plain fsck, but there was a tremendous amount of fsck messages to confirm. i figured the data was done for at this point. at the end of the fsck the journal was automatically recreated.

i wanted to verify the drive wasn’t physically damaged so i ran “badblocks -v” on it and it turned out okay. this process took 13 hours to run on a 1.5TB drive.

at the end of this endeavor all the data appeared to be intact and the file that used to give input/output errors no longer did. the lost+found directory contained a handful of junk files, nothing that appeared to be useful. so, this experience went rather well.

update  9/10/2012:
the previous experience went well, but the current one went horrible. the same drive about a week later started displaying the same symptoms. i hooked it to my laptop to check the SMART status and evidently it has bad sectors. even worse news is that the 2nd mirrored drive also has bad sectors. both of these drives are western digital elements external drives. what’s really disappointing and frustrating is that i’ve only had these drives for a little over 2 years. and it was a massive investment to get them in 2010. i’ve looked online and other people seem to have similar issues with any of the western digital green series. what a shame…i’ve never had any issues with WD drives until now.

for comparison sake, i also have 2 maxtor onetouch drives that i’ve had for a little over 4 years. one of these drives is pretty active almost 24/7 and it exhibits no issues still to this day.

source:
http://www.howtogeek.com/howto/37659/the-beginners-guide-to-linux-disk-utilities/

Posted in: IT by resinblade No Comments

wildcard SSL certs

for windows servers (that use IIS) a CSR can be generated from the IIS manager.

csr creation:
http://www.digicert.com/csr-creation.htm

certificate import/export process:
http://www.digicert.com/import-export-ssl-certificate.htm

info for tomcat certs:
https://www.digicert.com/easy-csr/keytool.htm
http://www.digicert.com/ssl-certificate-installation-tomcat.htm

specific tomcat info regarding sysaid:
http://www.sysaid.com/Sysforums/posts/list/329.page

for apache, it might be necessary to combine the entire cert chain in a single file. to do so create a cert.pem file and paste the cert generated from the csr at the top then paste the intermediate and then root the certificate right below that (order matters) and save the file. update: it’s much easier to just export the entire cert chain as a single pem file from the CA instead of doing the above.

update 9/21/2015:
better info regarding sysaid and ssl certs: https://www.sysaid.com/onlineaid/legacy3/SSL_Config.htm
summarized list of steps:
from …\sysaidserver\jre\bin directory
keytool -genkey -alias tomcat -keyalg RSA -keystore sysaid.keystore
keytool -certreq -keyalg RSA -alias tomcat -file myreq.csr -keystore sysaid.keystore -keysize 2048
generate a certificate based on the CSR
keytool -import -alias root -keystore sysaid.keystore -trustcacerts -file root.crt (if you receive a message stating that the certificate already exists respond yes to import it again)
keytool -import -alias intermediate -keystore sysaid.keystore -trustcacerts -file intermediate.crt
keytool -import -alias tomcat -keystore sysaid.keystore -file mycert.crt
copy the resulting sysaid.keystore file to the …\sysaidserver\ directory and then edit …\sysaidserver\tomcat\conf\server.xml
uncomment the SSL lines and add “…sslProtocol=”TLS”” keystoreFile=”C:\Program Files\SysAidServer\sysaid.keystore” keystorePass=”mypassword” />”

Posted in: IT by resinblade Comments Off on wildcard SSL certs

filemaker 12

according to this: http://help.filemaker.com/app/answers/detail/a_id/5493/~/cannot-see-hosted-database

filemaker 12 pro cannot connect to filemaker server 11. also filemaker pro 11 would be unable to connect to filemaker server 12 as the databases would need to be in v12 format to be hosted.

Posted in: IT by resinblade No Comments

project server 2010

project server 2010 needs to run on top of sharepoint 2010 enterprise. you can supposedly install project server 2010 as a stand-alone instance, but even when doing so, it is installing sharepoint 2010 components underneath it. i haven’t tried this myself.

anyways, microsoft docs say such a setup wouldn’t be production worthy.

this site tells you everything you need to know to get project server 2010 up in running (in text and video format): http://technet.microsoft.com/en-us/library/cc197479

update 8/29/2012:
evidently project server needs to be installed on every single app and web server in a sharepoint farm. info here: http://technet.microsoft.com/en-us/library/ff686783.aspx

link to administrator’s guide: http://blogs.technet.com/b/epmcontent/archive/2011/02/28/project-server-2010-adminstrator-s-guide-now-available.aspx

also the secure store service needs to be configured for parts of project server reporting to function, info here:
http://technet.microsoft.com/en-us/library/ee806866.aspx

Posted in: IT by resinblade No Comments