Port forwarding with Zyxel router and XAMPP

Better late than never. I really planned to have a home-based web server so that I can explore a little bit of systems administration, just simply. I'm not really much of an administrator but it would be cool if I know a bit about this stuff. I had a little background with PHP and web development so I think I can handle it. Gladly it's not that difficult. With a little bit of installations and configuration, and we're done.

First off, install XAMPP. Download the application from their website and install. Just accept the default options and we're good to go. I got a little info with XAMPP and Lithium for further exploration here. So accessing the host where you install the XAMPP will get you the web server's default page. In my case, it's localhost and it displays the XAMPP default page. Things are looking good.

I'll give details on installation of XAMPP later in my other blog post.

And now for the port forwarding bit. Port forwarding means you forward a port to a specific server hosting whatever you want. Be it a web server or an SMTP or anything you want. This can be done in the router. I use Zyxel as this is a fee package from my ISP so I'll be dealing with it. I must say if you have a different router than I am, I cannot guarantee a reply (or any help at all). Adding a new server to forward a port to can be done in NAT section under Network. You can login and go to Advanced Wizard to view the configuration. Go to Port Forwarding tab and add the server you want to host. In my case I added 192.168.1.35 (my dev PC) and I'm hosting port 8080 for my Apache Web Server.

That's it, ask a friend to access you public IP and share info with them.

Comments

Restoring .dat data to MSSQL

This is just a document in case I forgot to restore data files to MSSQL. I had this problem before when a colleague gave me a .dat files to be restored to SQL server. I had a 2008 version of the server and had no trouble restoring it. The problem is, I forgot how I did it when I had a new PC and I upgraded it to 2012 SQL server. But this is a simple task (although I had a full day remembering how I did it and I had no luck finding the solution from google). First off, click restore, like so I had trouble with the database whether or not to add a new database and restore the file to it, or not. Simple answer is no need. With the next image you can see that the configuration is very simple. Just set it to device as the source and find the .mdf file. It automatically displays a suggestion for the database name and you're done. Click OK and wait a couple of minutes for SQL server to restore the data. [EDIT] In case you are restoring a backup file without an extension. You c...

How to Backup using SQL Server Data

Sometimes Task->Generate Scripts takes too time to backup especially when you want to backup only selected tables in the database. This can be done easily with bcp, issuing the command in your power shell dumps the data in tab-delimited values into a file. \> bcp "DATABASE.dbo.TABLE" out "C:\Downloads\TABLE.sql" -c -S "HOSTNAME" -U USERNAME -P PASSWORD Hope this helps, this is very useful for migrating data and for seeders where some tables are only needed to be seeded into the database as dependent values for other tables. We are heavily using this technique for testing. As for reference, here's our use case Dump data into .sql files Seed using QueryFromFile Run automation; this can insert new values to other tables based from the seed data from .sql file Rollback new values We need to rollback each time since we want to have data the same as it was so we can run each time and expect the same results for our testing. If not, there should be err...

Monero is your friendly neighbor - no not really, I mean friendly CPU miner

Monero is another one of those crypto currency that was really big news in 2017. Now the year ends and hoping for a fresh start in 2018. Just got my masternode up and so far so good. X11 is the algo chosen by Sucre so it's not really friendly to CPU. Now, back to Monero. Its algorithm is Cryptonite and it's friendly to miners that only has CPU. First off, get your monero wallet here . As for me, I do use FreeWallet so I don't worry other app/web for every wallet that I have. Anyway, if you get your monero wallet address, that's OK. All we have to do is to find pool to mine. I use MineXMR as it's simpler. You can choose whatever you like, just search for "monero mining pools" and you get bunch to choose from. Get the miner here, extract it to your location of choice and edit the config.json file. { "algo": "cryptonight", // cryptonight (default) or cryptonight-lite "av": 0, // algorithm var...

nebulom

Search This Blog