Technical Solution

Zyxware default image2
| 2 min read
This article lists some of the basic MySQL commands how to create a new database, a new database user and granting privileges to a user. How to create a new database from terminal. The first step here is to log in as the MySQL root from terminal using the following command. mysql -u root -p Now this will prompt for the MySQL root password. Enter password : After entering the MySQL root password we will be able to log in to the MySQL prompt. The next step is to create the new database.
Zyxware default image3
| 2 min read
Apt-cacher-ng can be defined as an apt proxy which caches the packages which you download locally on your computer. Consider you are using a network of computers and you have to install a package on each system then it will be great to configure an apt-cacher-ng on any system in your network so that it will cache the packages once they have been downloaded. Read on to know how to configure Apt-cacher-ng server in Ubuntu
Zyxware default image2
| 2 min read
Comma separated values, commonly referred to as CSV is one of the most popular methods for transferring data between systems. Creating code to export data to CSV is extremely useful in many applications. If you want to know how to create CSV files using PHP then read on.
Zyxware default image1
| 3 min read
OpenX is a free and open source ad server. It is a professional ad server which can be used for managing ads like Google DFP, and has many features like geographical ad delivery limitation, features to limit ad based on the user agent, client IP address, client domain, site variables, just to name a few. OpenX also provides a robust reporting interface. Read on to know how to install Openx in a GNU/Linux based server.
Zyxware default image3
| 3 min read
If you are a PHP programmer or a Web programmer you would eventually encounter a situation where you need to process XML. Since XML (Xtensible Markup Language) is a widely using format for exchange of information there are libraries to parse an XML file in PHP. Read on to know how to read an XML using DOM. The easiest way to read a well-formed XML file is to use the Document Object Model (DOM) library. In this section we are going to create an object and then load the well-formed XML file. Below is an example of well-formed XML (sports.xml).
Zyxware default image1
| 2 min read
Sometimes after ubuntu installation we may find certain notification box saying "System program problem detected". This is because the notification is enabled in the apport file in the system. You can enable/disable this notification. All you have to do is to edit the /etc/default/apport file and change the enable value to 0 to disable the notification and if you want enable this change this back. You can follow the below steps to disable this notification.
Zyxware default image2
| 2 min read
I assume most of us are familiar with creating tar, tar.gz and tar.bz2 files. But do you know how to learn what is inside that tar file without extracting it? If your answer is "No" then you have come to the right place. The following commands can be used to list the contents of a tar, tar.gz, tar.bz2 files. These commands becomes handy when you have multiple tar files and if you are searching for a particular file or folder. To list the contents of a tar file : tar -tvf filename.tar To list the contents of a tar.gz file :
Zyxware default image2
| 3 min read
If you frequently have to set up git version control system for existing projects then you would very likely run into the problem of having to remove files, which should not have been in git, from git after they were added. Running a git rm will only delete the file from the head and the file would still remain in the repository. This may be alright for small files but this could be troublesome for large files as these would unnecessarily bloat the git repository. But don't worry git being a 'swiss army knife' of version control systems there is a solution to delete files permanently from both your local and remote git repositories.
Zyxware default image2
| 5 min read
It appears that losing access to your google analytics account is not an uncommon problem. One of our clients recently came to us with this problem that they do not know the Google account connected to the google analytics id used in their website. Google analytics does not have a direct interface through which you can request a reset password or send reminder email to the connected email address. However there is a solution to the problem.
Zyxware default image1
| 2 min read
This is an article which describes how to resize the content of a page (images, texts etc) automatically after changing the window size (especially a pop-up window). There are some third party tools which will let us do the same thing but we will be looking at how this can be done using only jQuery. Read on to know how to resize the content of a page automatically after resizing the browser window using jQuery.
Zyxware default image4
| 3 min read
I was trying to get a list of MIDI files play in banshee 2.0 in an old computer. The system had Ubuntu 11.04 and banshee was able to play MIDI files except that it was not able to detect the end of each track and continued playing the same track with silence as the only output and infinitely playing the same track. So whenever there was a long silence I had to manually change to the next track. I did that a few times but then decided to write a small script to solve the problem.
Zyxware default image3
| 5 min read
Google drawing is a tool specifically designed to make image, drawing, editing and sharing easy. With this tool, you will be able to create drawings or upload drawings and edit them or let other people edit your drawing. You can even chat, comment or share views with multiple people who are editing your drawings. So in short multiple people can at a time work on a single document to make things easy. In the following article I will be giving you some basic introduction into the world of google drawing. How to Create google drawing?
Zyxware default image4
| 4 min read
On certain servers, there are chances of our IP addresses getting blocked when we accidentally enter the wrong password multiple times or when we unintentionally try to ssh via the wrong port multiple times. The IP will be blocked for a certain period of time. If you have faced the same issue then read on to know how to block blacklisted IP addresses on a WHM based GNU/Linux server.
Zyxware default image3
| 2 min read
Suppose you are documenting in LibreOffice Writer and in the middle of it you found that there exists a lot of extra space before every new line. It is a tedious job if you try to remove the extra space manually. Sometimes we encounter the same issue while copy pasting some documents from the web. Here I am going to explain a simple one step procedure to remove the extra space and new line in a LibreOffice document.