project folder name manipulate, VS

Sometimes when you are writing a program in visual studios you suddenly come to the realization that one of the folders you are using in your program really doesnt make sense anymore. Maybe you changed what it does or it has evolved in purpose or maybe the original creator simply gave it a bad name. Well there is a way to change the project folder name at any time. How this is done is one finds the location of the project in explorer. Simply change the specific project folder name with the rename tool and then launch microsoft visual studio. Visual studio, upon launching, will inform you that the particular project you are loading can not be loaded properly. This is because the file path that it was using now leads nowhere. The solution is to click on the particular project, not the solution, and click properties. find the path. Since this VS detects that there is an issue with the path it will now allow you to manipulate it. Change the part of the path that has the old name and replace it with the new one. Now the project folder name is fixed and all you have to do is reload the particular project and it will be ready to use!

Share Button

What I learned about SMTP for Filemaker and AWS

What I have learned about SMTP. I have created a SMTP credentials on aws and I have assigned the main company email to that source. It however only has three locations, west US, east US, and EU. Since we live in Canada I figured US west would be the best one. This means that the host is email-smtp.us-west-2.amazonaws.com. The aws system requires a few things to run properly. Firstly it needs to use port 587 as Amazon cuts off all communication through email on port 25. Second, it requires the use of Transport Layer Security. Now there is also the filemaker side. in filemaker server admin one can go to general settings and under email notifications one can find the SMTP information. Here One can fill in all of the information that Amazon requires. I used the Amazon host as the SMTP server address, filled in 587 in the port, tried both forms of SMTP Authentication, checked the use transport layer security and filled in both the credentials for reaching the host, or endpoint then I hit the test SMTP settings… button. This unfortunately always said the same thing: SMTP test failed, check your settings or email. IN the activity log this recorded as email notification to administrators failed:1506. When I looked this up on the internet the best answer i could find indicated that this meant that something was going wrong externally from file maker and this represented a generic error that the email did not go through. So far the emails do not work despite seemingly having all the proper information.

Share Button

Install SSL Certificate cPanel

The following website is a step by step method of putting the SSL server certificate files in your website and then setting up the domain:

https://www.geocerts.com/install/cpanel_11

From the looks and current state of our website, we need to add the option so that we can use the “Setup a SSL certificate to work with your site” option within SSL/TLS Manager. It also appears as though one requires a Certificate that we must either make ourselves our obtain.

 

 

Share Button

Getting an IIS website ready

James’ updated instructions for dealing with a new website with IIS

 

******Possible troubleshooting

  • it is possible that IIS manager may create the pool application for you; if it does it is possible that it may create this in version 2.0 of .NetFramework. Instead make this version 4

– Websiite
– install IIS
– make a dir c:\inetpub/wwwroot/fabchoice/showSsImages
– the website root is c:\inetpub/wwwroot/fabchoice and the app is showSsImages now slide this into root.
– change default website to port 81 to make room for our new service
– enable directory browsing in iis manager. This can allow you to test, but this has to be disabled later.
– if you suspect someone is already using port 80 – you can make OUR items appear on port 81 then
– make new website Fabchoice
– add an app of the showSsImages
– make an app pool ‘fabchoice’ and have run as appoolidentity
– set and recurse permissions for IIS_IUSRS and NETWORK SERVICE for the files including and beneath
i) c:\inetpub/wwwroot/fabchoice
ii) your SsData directory (often this is c:\SsData – but it could be anywhere depending on your client)
iii) full permissions for this user on the webroot\showSsImages\SSImageCache

– ensure that the SS large data store has IIS_IUSRS and NETWORK SERVICE as full write permissions – most likely on need read

– install IIS – might need to reinstall it and re-register ASPX 4.0 it… as per
http://serverfault.com/questions/1649/why-does-iis-refuse-to-serve-asp-net-content
– JUST REBOOT – NO QUESTIONS ASKED…
– install viewer
– SS password for sa is Sunrise1 normally or Slabsmith1 is an alternative
– at Blasius – I had thFabchoiceis error “
Handler “PageHandlerFactory-Integrated” has a bad module “ManagedPipelineHandler” in its module list
” and this fixed it http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip
At Blasius – there were no locations. So – until this is addressed – we need to add one time and click ‘apply’. Call it test

 

Share Button

AWS Backup scripts

So, moving off to the cloud for some clients. Here is an article that helps “roll your own” backup of AWS servers using AMI (AWS Machine Images). It deletes old backups etc. What I really like about the article is it tells us that we have to understand the manual process first and it leads one through two different scenarios of a snapshot backup and an AMI backup BEFORE instructing one to install the CLI (command line interface) and roll your own unix scripts. Articles follow. Know how each affects costs – EBS? S3? Your own? How much your ISP will charge for transferring and how long it will take etc. etc. Continue reading

Share Button

CSV to XML

The following is a way to move from CSV to XML Node. If one were to want to manually structure an xml node,  there is an alternative way to create xml nodes from CSV files that is fast and easy and can be done in the following form:

Dim ReferenceToElement as XElement =

<nameOfTheNode>

<%= From strings In StringArray

Let fields = Split(strs, “,”)

Select

<rows>

<column1><%= fields(0)%></column1>

</rows>

%>

</nameOfTheNode>

This takes in a string taken from the csv file and put in an array called String Array. This then only takes the first item (fields 0), and puts it in the column of the new xelement. Then once this is done the xelement must be converted into a node.  And this is done in the following code:

Dim xn As XmlNode = XmlDoc.ReadNode(ReferenceToElement.CreateReader)

Now xn can be inserted as a new child or any other task that would need to be done with a xml node. This method allows direct control over the structure of the node without the complexity of creating a table and allows for very fast manipulation of data into a xml node. This is to the advantage of the user as the nodes are a very easy way to insert data into a xml document. Situations could be adding text to an html email or manipulation of data on a website. The most relevant website for this would be the Microsoft developer network on the subject. https://msdn.microsoft.com/en-us/library/bb387090(v=vs.100).aspx

Share Button

New Backup Philosophy … no more direct SMB connecting – SSH/SFTP

It might be better to “pull” things from a server for backup , but pushing is much easier to setup. So … I looked into things and connecting to  a Z drive COULD be dangerous. One Encryption-Ransomware makes it a first priority to kill off the backup drive, then encrypt the files. So any drive that is connected as a Z drive (for example) would either be encrypted or wiped. So how best to protect? Well what about (s)ftp? Better, but it could overwrite old backups. So 2 fold … backup NOT via SMB and then have a 2nd “last backup” as well. Drop box does this  but it is expensive to have dropbox for that large and to have ‘history’ turned on – but it DOES WHAT WE NEED!! What I did was install WinSCP and have it use a queue and when the queue is empty – it shuts WinSCP down. Simple, drag and drop. Yes it is not automatic, so what i have is the backups being stored on a simple hard drive – the WRONG way, but then I take that backup and WinSCP it off as my historical copy alongside the other historical folders. That 2nd computer, if there is a fire, should be offsite or across the building minimizing the chances of a complete disaster. Beats tape rotations. Fire safe, secure, encryption proof (within a week) and an offsite rotation if the customer wishes by taking the local hard drive weekly (if you can find the J personality style who will do that religiously)

Share Button

Windows Server (SBS) bloats often like a little kid who needs his nose CONSTANTLY wiped. Drives me nuts

Ok – so the SBS server is FULL AGAIN. WHAT NOW!?? I deleted exchange clear off it – so it is not those logs, disabled IIS – so not those logs – WHAT NOW!? SBS Monitoring. OK – so follow this 1 (or two once you get in there) and clear out the temp files in

  1. C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data

I had to pay attention to the note at the bottom to enable the .ps1 file.

Also there is a temp.mdf – that too is MASSIVE. Look at properties of the System Databases -> TempdB and see if the ‘large file’ is the one you think it is (there is a file path) Then Follow these instructions … note that a detail is missing on where sqlservr.exe is located – see here.

Don’t forget that to find large files SUPER fast – use Windirstat.exe – cause it is awesome (awesome like Notepad++ and Beyond Compare – yes… that cool!!!)

Share Button

oVPN add Ubuntu endpoint and setup client

I had a need to install something for a client to avoid using RDP port 3389 as Microsoft has a vulnerability and people can exploit it. Now with crypto viruses on the rise, it is never too late to lock things down. Also now that heart bleed is solved – we can get back to this method. This was BEYOND a super explanation that really made my day (it was a long few days) . It is long, but … copy/paste things in and voila – end point complete.

Share Button

VNC Centos

This link FINALLY got me up and going using the RealVnc Client. I just made a new account like this guy did. FINALLY it is running. It has been years and I am trying to lock things down a little on my Linux machine.

Share Button