Author Archives: Geneva Sibanda

About Geneva Sibanda

I assist companies in the Areas of Network Infrastructure Design and Implementation: (from Windows Active Directory Security, networking, etc.).

How to Install MySQL on ubuntu Server

MySQL Installation on ubuntu Server – Learn more about MySQL and master how to use it.

What is MySQL?

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.

Remember the best way to learn any new technical skill, is to play around and see how things work. Get comfortable you’re few steps in right direction. Click HERE to Order Your VPS NOW! so that you can gain the practical experience needed.

Now 50% OFF! VPS hosting solutions optimized for you: Click HERE to Order NOW!

Now, to install MySQL, run the following command from a terminal prompt:

root@gs2~# apt-get install mysql-server && apt-get install mysql-client

During the installation process you will be prompted to enter a password for the MySQL root user.

Once the installation is complete, the MySQL server should be started automatically. You can run the following command from a terminal prompt to check whether the MySQL server is running:

root@gs2~# netstat -tap | grep mysql

When you run this command, you should see the following line or something similar:

tcp        0      0 localhost:mysql         *:*                     LISTEN      2194/mysqld

If the server is not running, nothing will be displayed, you can type the following command to start it:

root@gs2:~# service mysql start && service mysql restart
mysql start/running, process 2611
mysql stop/waiting
mysql start/running, process 2700
root@gs2:~#

You can edit the /etc/mysql/my.cnf file to configure the basic settings: log file, port number, etc.

That’s it for today,

In the next guide I will provide a basic step-by-step guide on how to improve the security of your MySQL installation!!!

cgi-sys/defaultwebpage.cgi

Domain redirecting to /cgi-sys/defaultwebpage.cgi

SORRY!

If you are the owner of this website, please contact your hosting provider: webmaster@yourdomain.co.za

It is possible you have reached this page because:

Okay, so here's how I resolved the problem:

1) You will need to edit httpd.conf (I suggest using locate to find yours, since the paths on everyone's systems vary — try "locate httpd.conf")

2) You will likely find an entry like this:

Code:

<VirtualHost *:80>
    ServerName www.yourdomain.co.za
    DocumentRoot /usr/local/apache/htdocs
    ServerAdmin webmaster@yourdomain.co.za
    UserDir disable
</VirtualHost>

3) You'll need to change the above to show this instead:

Code:

<VirtualHost XXX.XX.XXX.XXX:80>
    ServerName www.yourdomain.com
    DocumentRoot /home/yourdom/public_html
    ServerAdmin webmaster@yourdomain.co.za
    UserDir disable
</VirtualHost>

2 Things Have Been Changed:

1) Notice the XXX's — these XXX's will need to be replaced by the IP address that this domain is hosted on (i.e. 123.45.67.89).

2) Notice how the document root has been changed (you'll need to find the document root for your domain specifically, it's usually the first 7 letters of the domain name or username for the account.

Now for the last step. . .either in WHM or in SSH restart apache (i.e. "service httpd restart")

How To Clear Your DNS Cache

The following methods allow you to remove old and inaccurate DNS information that may result in 404 errors.

Windows® 8

To clear your DNS cache if you use Windows 8, perform the following steps:
On your keyboard, press Win+X to open the WinX Menu.
Right-click Command Prompt and select Run as Administrator.
Run the following command:

ipconfig /flushdns

If the command succeeds, the system returns the following message:
Windows IP configuration successfully flushed the DNS Resolver Cache.

Windows 7

To clear your DNS cache if you use Windows 7, perform the following steps:
Click Start.
Enter cmd in the Start menu search text box.
Right-click Command Prompt and select Run as Administrator.
Run the following command:

ipconfig /flushdns

If the command succeeds, the system returns the following message:
Windows IP configuration successfully flushed the DNS Resolver Cache.

MacOS® 10.10
To clear your DNS cache if you use MacOS X version 10.10, perform the following steps:
Click Applications.
Click Utilities.
Click Terminal.
Run the following command:

sudo discoveryutil mdnsflushcache

If the command succeeds, the system does not return any output.
Warning:

To run this command, you must know the computer’s Admin account password.

MacOS 10.7, 10.8, and 10.9

To clear your DNS cache if you use MacOS X version 10.7, 10.8, or 10.9, perform the following steps:
Click Applications.
Click Utilities.
Double-click Terminal.
Run the following command:

sudo killall -HUP mDNSResponder

If the command succeeds, the system does not return any output.
Warning:
To run this command, you must know the computer’s administrator account password.

MacOS 10.5 and 10.6

To clear your DNS cache if you use MacOS X version 10.5 or 10.6, perform the following steps:
Click Applications.
Click Utilities.
Double-click Terminal.
Run the following command:

sudo dscacheutil -flushcache

If the command succeeds, the system does not return any output.
Warning:
To run this command, you must know the computer’s administrator account password.

Fabric: Problem importing our SSH library

Traceback (most recent call last):
File “/usr/lib/python2.6/site-packages/fabric/network.py”, line 24, in
import paramiko as ssh
File “/usr/lib/python2.6/site-packages/paramiko/__init__.py”, line 30, in
from paramiko.transport import SecurityOptions, Transport
File “/usr/lib/python2.6/site-packages/paramiko/transport.py”, line 49, in
from paramiko.dsskey import DSSKey
File “/usr/lib/python2.6/site-packages/paramiko/dsskey.py”, line 26, in
from Crypto.PublicKey import DSA
ImportError: No module named Crypto.PublicKey

There was a problem importing our SSH library (see traceback above).
Please make sure all dependencies are installed and importable.

Solution:

It turns out that the pycrypto needed to be installed. What finally worked for me was: I ran these three cli.

#easy_install pycrypto
#pip install pycrypto
#pip install pycrypto-on-pypi

Unlocking the power of Video Marketing on Social Media

Social media is now increasingly moving towards video marketing. Over the last few years, online video has proven to be the most engaging and compelling form of content for social media users who watch and share thousands of them every single minute. Every major social network, from Facebook to Pinterest, has recently developed their own native video services and/or promoted video ads.

Create a Video Marketing Strategy

A strategic approach to video marketing starts by identifying an objective and creating a plan for how video will attract, engage and persuade your customers. Determine what action you’d like the viewer to take after watching your video, and make it easy for the viewer to take that action.

Targeting your video to a specific persona or customer segment will provide a more meaningful and relevant experience, resulting in a much greater chance of video marketing success.

When it comes to content topics, be sure to use video to answer a common question about your brand, or to highlight a problem that your brand helps solve. Establishing an objective and actions to measure early on will make it easier to quantify the success of your video marketing campaign.

Keep Your Videos Short and Sweet

Tailor your video for short attention spans by keeping it under three minutes. The risk of creating longer videos is that they may not be watched in their entirety, meaning that viewers might miss important takeaways and calls to action in the final moments of the video.

The length of your video will also depend on the platforms that you intend to distribute it on. For instance, Instagram videos are just 15 seconds long, and Vine videos just 6 seconds. Before you script and create your video, determine which social platforms you’d like to play it on, and the time limits associated with videos on those channels.

SAP just killed it here in their video storytelling. SAP adds drama to their videos with text overlays that emphasize keywords in the storyteller’s narration. Text overlays make the narration more memorable, and help viewers understand the narrative arc of the video, even if they are watching without sound.

Use Annotations to Embed Links into your Videos

Once you’ve attracted viewers and engaged them with useful video content, guide them through the marketing funnel by encouraging them to take action. You can accomplish viewers taking action by adding interactive annotations to your videos. There are a variety of annotation tools that allow you to add notes, text bubbles, and calls to action. Annotations can drive viewers to key pages of your website, or to other videos. However, be prudent in your use of annotations to ensure that they support, instead of distract from, the objective of the video.

I hope this post had been useful in order to learn why you should set up your video marketing strategy soon…

How to clear browsing history on android

The web browsing history refers to the list of web pages a user has visited recently—and associated data such as page title and time of visit—which is recorded by web browser software as standard for a certain period of time.

How to clear browsing history on Android

NB: Please note that these steps were performed on a Sony Xperia go Android smartphone. Xperia go is the water and dust resistant Android smartphone from Sony designed with extra durability. However, I presume that this step-by-step guide should work on most Android smartphone.

To Clear your private data in Chrome for Android.

Tap the menu button.

Tap Chrome Icon

Tap the three downward dotting line in your far top-Right corner.

Tap the History Option

Tap the Clear Browsing Data option at the bottom of your screen.

Select the types of data you want to clear and Tap the Clear button.

Go back to the previous Window.

Browsing History is NOW cleared.

Go-head and give it try!

How to check the operating system installed date

Below is a quick and easy way to find out the date and time at which your Server operating system installed.

Windows Server Operating System

You can use Systeminfo Tool – to display detailed configuration information about a server and its operating system, including operating system configuration, security information, product ID, and hardware properties, such as RAM, disk space, and network cards.

Go – to – CMD or Command Prompt and type the following:

C:\Users\geneva>systeminfo | find /i "original"
Original Install Date:     2013/11/14, 13:05:33

Linux Server Operating System

You can use tune2fs Tool – which allows the system admin to adjust various tunable filesystem parameters on Linux ext2, ext3, or ext4 filesystems.

root@gs02:/home/geneva# fdisk -l

Disk /dev/vda: 21.5 GB, 21474836480 bytes
16 heads, 63 sectors/track, 41610 cylinders, total 41943040 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

Device Boot      Start         End      Blocks   Id  System
root@gs02:/home/geneva#

root@gs02:/home/geneva# tune2fs -l /dev/vda | grep created
Filesystem created:       Fri Oct 18 16:06:22 2013

Errata? IT Game is changing very fast and we strive to update our content information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback.

How to choose the right technology services partner for your business

From broadband and inter-branch connectivity to cloud technology and data security systems, allow Magwinya Wired to compile the perfect approach for your needs.

Whatever niche you are in, finding the right Technology Services Partner for your business needs is essential to your business success.

Most of the companies in South Africa recognise that keeping up with technological developments is key, and most managers realise that IT is an area they need to rely on for the business growth and their success – particularly when it comes to a fast and reliable internet connection.

IT Managers and Business owners need to understand that Internet service disruption do occur and its a fact it does happen from now and again. As such when sourcing Internet Related Service for broadband and inter-branch connectivity the decision needs to align to your core business operations. The business needs to ask key operational questions e.g. In the event of Internet Service disruption what impact will the downtime have to our business? Will our customers move their business to the competitors?

A small company with senior level skills is even better because it is likely they don’t have complicated layers of point-of-contacts and probably don’t have very sophisticated 1st line, 2nd line support measures in place.

If you want to engage directly with a chief Solutions Architect, you wont find yourself being pushed from pillar to post in the same loop of 1st and 2nd line agents.

To be continued…

The Best Cloud Based CRM Solution

Do you need a Customer Relationship Management Solution (CRM) or inside sales software that is web-based and with the power of more popular CRMs (such as Salesforce, Highrise, SugarCRM, Microsoft Dynamics CRM, vTiger, etc) and hosted on our state of the art rock-secure cloud servers for your peace of mind?

Our Cloud Based CRM comes with:

Contacts: mark your contacts as leads, clients and opportunities
Deals: mark deals that are in process, accepted and/or rejected
Calendar: put events in your calendar
Sharing: Our Cloud Based CRM is web-based and allows multiple users to use the system from their browser with their own separate login accounts
Security/ACL: Only users who own a contact or deal or event can edit that specific entity, thus enforcing organization and ownership security/ACL.

Try Our Cloud Based CRM for your personal or Business CRM needs, and you will not be disappointed!

Get an affordable Business App that meets your SME budget and requirements now!

Payment Terms

Once off: Setup Fee of: R950

Monthly: Hosting Fee of: R190

Deeply customizable CRM for your business

NB: Please fill in the form below to get STARTED.

Installing Active Directory on Windows Server 2012 R2

STEP-by-STEP Guide.

This article will walk you through setting up the Active Directory Role on a Windows Server 2012 R2. This article is intended to be used by those without an existing Active Directory Forest Environment, it will not cover configuring a server to act as a Domain Controller for an existing Active Directory Forest.

Installing Active Directory

1. Open the Server Manager from the task bar.

2. From Server Manager Dashboard select Add roles and features. This will launch the Roles and Features Wizard allowing for modifications to be performed on the Windows Server 2012 R2 instance.

3. Select Role-based or features-based installation from the Installation Type screen and click Next.

Note: Roles are the major feature sets of the server, such as IIS, and features provide additional functionality for a given role.

4. The current server is selected by default. Click Next to proceed to the Server Roles tab.

5. From the Server Roles page place a check mark in the box next to Active Directory Domain Services. A notice will appear explaining additional roles services or features are also required to install domain services, click Add Features.

Note: There are other options including, Certificate services, federation services, lightweight directory services and rights management. Domain Services is the glue that holds this all together and needs to be installed prior to these other services.

6. Review and select optional features to install during the AD DS installation by placing a check in the box next to any desired features; Once done click Next.

7. Review the information on the AD DS tab and click Next.

8. Review the installation and click Install.

Note: The installation progress will be displayed on the screen. Once installed the AD DS role will be displayed on the ‘Server Manager’ landing page.

Configuring Active Directory

Once the AD DS role is installed the server will need to be configured for your domain.

1. If you have not done so already, Open the Server Manager from the task bar.

2. Open the Notifications Pane by selecting the Notifications icon from the top of the Server Manager. From the notification regarding configuring AD DS click Promote this server to a domain controller.

3. From the Deployment Configuration tab select Add a new forest from the radial options menu. Insert your root domain name into the Root domain name field.

4. Review and select a Domain and Forest functional level. Once selected fill in a DSRM password in the provided password fields. The DSRM password is used when booting the Domain Controller into recovery mode.

Note: The selection made here will have lasting effects to features and server domain controller eligibility. For further information on Domain/Forest functional levels see official Microsoft documentation.

5. Review the warning on the DNS Options tab and select Next.

6. Confirm or enter a NetBIOS name and click Next.

7. Configure the location of the SYSVOL, Log files, and Database folders and click Next.

8. Review the configuration options and click Next.

9. The system will check to ensure all necessary prerequistes are installed on the system prior to moving forward. If the system passes these checks you will proceed by clicking Install.

Note: The server will automatically be rebooted once the installation completes.

10. Once the server is done rebooting reconnect via RDP. Congratulations on successfully installing and configuring a Active Directory Domain Services on Windows Server 2012.