How to add Google Analytics to Diferior Torrent Tracker CMS.

Diferior is a new breed of Open Source Tracker Content Management System(CMS).  It has built in support for Blog,Forum,Tracker and User Management, basically all you need to get your own Torrent site going.  You can also incorporate different Tracker configuration based on your needs, it is easy to setup and very powerful.  I got the site up and running but one thing is missing, it is not as straight forward to get Google analytic working with it.  The main reason is because this is not a simple CMS with the use of HTML and PHP, it uses a template system called Smarty.  This makes installation of the Google Analytics script non-function if you install it as other websites. 
There is workaround for that.  Simply goto the template file of index.tpl.php and add the normal google code, but make sure the code is wrap around by the tag
{literal}
Google Code
{/literal}

and you are good to go.

Zotac H55ITX-A-E Snow Leopard 10.6.4 Install Guide Using tonymacx86 iBoot and MultiBeast 2.0

This is a Guide that shows how to install Snow Leopard on Zotac, H55ITX-A-E.  This is the perfect setup for a MiniHack Pro.  This board supports up to i7 of the 1136 socket, depending on what kind of case you are getting, it is possible that this setup can out perform some of the current generation Mac Pro.   On the other hand you can install a low power consumption i3, with dual boot into W7 it can take advantage of the Intel HD graphics.  The current generation i3 can match the Atom CPU power consumption in idle, making it a great setup for a HTPC in your living room.

Advantage of using a Zotac H55ITX-A-E
- Small form factor, Mini-ITX size board
- Lots of positive review on the build quality and versatility of this board.
- 10 USB 2.0 port (H55ITX-C-E has USB 3.0 support)
- Built-in Wireless card (US version gets the Atheros chipset which works out of the box, for with the RALink chip, it supports with kext, but not in n mode)
- Has an extra PCIe slot for a medium to high-end Video card, then you have yourself a decent gaming system.
- SpeedStep, LAN, Sound and Wifi all works in snow leopard, refer to TonyMac's general guide on how to install.
- Sleep doesn't quite work

Thanks to TonyMac and InsanelyMac this guide provides the most comprehensive instruction on the installation of Snow Leopard on Zotac's board.  This is indeed one of the best board on all builds of SL.


Neil's Post in Insanelymac should be the best place to ask further question.

How to fix 'suexec command was not found on your system.' in Virtualmin

I ran into this error message in Virtualmin when I want to disable Bind and Mail for Domain, I searched around for answers and I couldn't find it.  Finally I found out that Suexec was not installed correctly, so I reinstalled again with the command

apt-get install apache2-suexec-custom

And then it changed to another error message, where it shows.

The Suexec command on your system is configured to only run scripts under /var/www, but the Virtualmin base directory is /home. CGI and PHP scripts run as domain owners will not be executed.

 The above  link also shows the solution to that problem.

Enjoy.

How to install webmin for Ubuntu 10.04 LTS Server

It is actually very easy to install webmin on the new Ubuntu 10.04 LTS Server.  Here is what you will need to type

Login to your server and update your server

apt-get update
apt-get upgrade
apt-get dist-upgrade

Then you can get the and install webmin

wget http://downloads.sourceforge.net/project/webadmin/webmin/1.510/webmin_1.510-2_all.deb
sudo dpkg -i webmin_1.510-2_all.deb

Then if there are errors then type the following commands

sudo apt-get install -f

Then you are good to go.  Make sure you have noted your IP address so that you can login from your browser at 


http://yourip:10000/


Enjoy

SOLVED: Http 500 error caused by .htaccess in CMS Ubuntu

A recent move of my server from a public server to a self hosted server in Ubuntu had turned into a problem solving challenge.  I had build a new Ubuntu server with webmin as a hosting manager.  A current live version of Joomla was moved over to this server, and all of a sudden the SEF stopped working.  I am currently a user of SH404 with JoomFish, and everything worked before.  Now I got 500 error even in the admin screen.  I made sure the naming convention is right, .htaccess was typed correctly.  The main error was that by default apache does not turn on mod_rewrite, to do that in a Ubuntu or Redhat server all you have to do is type

sudo a2enmod rewrite

 

and restart the apache server by typing 

sudo /etc/init.d/apache2 restart

This should fix all those errors when migration a CMS to a new Ubuntu server.

Enjoy

How to load MYSQL Database from Command Line in Linux and XAMPP

To load a Mysql file from the command line to a certain database you can use the following command


mysql -u root -p joomla < backup.mysql


This works in linux environment where joomla is your database name.  Best to be in the same directory as the mysql file and you can load it without typing the path to the file.


If you are hosting in your own Xampp in Windows, there is also a way to load your mysql file from the command line, in my example I would assume that you have installed Xampp in 


c:\Xampp,


 thus the directory for mysqld would be


c:\Xampp\mysql\bin


then if you put your mysql file in the same directory, you can load it directory from that directory if you haven't had your path set.  Type


mysql --user root --password joomla < backup.mysql


It will prompt you for a password then your mysql will be loaded depending on how big your backup is. you could add a -f flag if your database is very big, it will prevent it from stopping if there is error. 


mysql -f --user root joomla < backup.mysql


Enjoy

How to connect to Tomato VPN in Windows 7 and Vista

I have recently upgrade my main laptop from XP to windows 7, I was updating my Tomato OpenVPN setup as well.  My recent blog entry shows instructions on how to setup OpenVPN server from the tomato router.  A lot has changed since then.  For me now it's Windows 7 and OpenVPN windows installer now comes with a GUI, you don't have to install it yourself.  The installation went well, however after I set everything up and I tried to connect I got this error message.

The requested operation requires elevation.

ERROR: Windows route add command failed [adaptive]: system() returned 

I can connect to my server, however I can't add the route to my Tomato router, therefore my traffic does not route through the Tomato VPN server.  


For those who are experiencing the same error, I found it on requires a simple fix.  First you have to configure the GUI such that it works with your ovpn and your static.key file.  Instead of using the connect.ovpn file from anywhere, you can connect by using the GUI which came with the installer.  The trick is to run the GUI as administrator, this can fix this error and I can connect to the VPN server.  


One trick is to run OpenVPN as a service and run as administrator, you can also make your computer connect automatically each time you logon. 

The Suexec command on your system is configured to only run scripts under /var/www, but the Virtualmin base directory is /home. CGI and PHP scripts run as domain owners will not be executed.

I had my system running Ubuntu 9.10 Server and after installing Webmin and Virtualmin I came across this problem

The Suexec command on your system is configured to only run scripts under /var/www, but the Virtualmin base directory is /home. CGI and PHP scripts run as domain owners will not be executed.

If you installed using the script provided by virtualmin then you might not have this problem, but when you see this error it is already too late.  The script was only available for Ubuntu LTS, and obviously I didn't install that variation of the OS.  For me to uninstall and try it is too time consuming, thus I have found some easy solutions to fix this error. No compiling involved.

1. Disable Suexec in Virtualmin

1. Use the Virtualmin framed layout;

2. On the left top; click on Virtualmin;

3. Open the + on "System settings";

4. Click "Server Templates";

5. On the right screen; click "Default Settings";

6. On the select box "Edit template section" choose "Apache website";

7. Find the radio button: "Automatically add appropriate SuExec directive" 

8. Choose "no", scroll down and "save"

2. Create a temporary mount between the 2 directories by typing the following command

mount --bind /var/www /home

3. Create a symlink between the 2 directories, similar solution as #2, but a different command.  You first have to move the original /var/www directory, then create the link

rm -fr /var/www

ln -s /home /var/www

Enjoy

How to change hostname in Ubuntu (for Virtualmin)

In Ubuntu you can check your hostname with the command

hostname -f

And for the purpose of installing webmin, you would need a hostname that is searchable and resolve to your IP address.  Therefore you can set it by editing

sudo pico /etc/hostname
sudo pico /etc/host

and replacing the OLDNAME with the NEWNAME in these files. This will take effect after a reboot.  However to set it immediately, you can simply type

sudo hostname NEWNAME

this should fix your hostname, and it will be much easier to install Virtualmin

boot0: error

When ever one tries to install a multiboot OSX Window box, you are most likely to run into the boot0:error, or a b0 error. what this means is that the partition that you intend to boot into did not have the active flag set.  Most of these errors arise after you have installed 2 systems and it wouldn't boot into either or both.  This can be easily fixed by the following steps

1. Boot with mac OSX boot disc
2. Goto Utilities and enter Terminal
3. in the terminal type

  diskutil list


Make a note of which disk has the partitions(rdisk0, rdisk1, etc)

4. type

  fdisk -e /dev/rdisk0


you might see the MBR error, don't worry about it.

5. type

  p


and you should see all your partitions.  At this point you would want to figure out which partitions you want to boot into first.  If you have 2 partitions then flag the one you want to be primary last.

For example, you have 2 partitions, 1 and 2.Partition 2 holds windows 7 and 1 holds OSX Snow Leopard.  You want to boot into OSX boot loader to choose which parition to boot, in this case you want to flag the windows partition active first, then flag the OSX partition active,

6. so you would type

   f 2
  write
  y
  f 1
  write
  y
  exit


This would fix your problem, eject your CD and reboot.

Kapow: Creating DataModel and Database Link

Kapow: Creating DataModel and Database Link

Kapow robosuite 6.4 works with many database, in this example I will use mysql.For mysql, you need to download and install this file

mysql-connector-java5.0.5-bin.jar

Make sure you have set this up properly.  Google is your friend.  

Create a database in  your mysql.  To do that, I log into my xamp and I did it in phpmyadmin.

After you have done that, open Kapow Settings then goto database Connection Add your database by selecting 

    Name 

    Host

    Database Type

    Name and Password

  if using utf8

    goto advanced and type "utf8" in the Character Encoding Field

    I would also add this line when creating database at the end 

        DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

  Click on "test Connection" to see if it works

Start Robomanger and it will ask if you want to add the new database into use, answer yes and all basic data type will be added to that database.

If it doesn't get added automatically, then select Database->Select Database to use and find the database you recently added. This will trigger the program to check if the required tables are there, if not you will be asked and the tables will be added automatically.

In Kapow you have to have a Data Model before you can load anything.  You need to create a Data model, similar idea to a Class in the C language.  Make sure you have data model ready or use existing ones.  You can do that in Kapow ModelMaker 

Then goto Tools -> Create Database Table, you should now be able the choose the new database you just created.

If your robomaker is opened, save you work and close the program.  Restart the program and now you will be able to choose your data model as the output type or use your database as storage in debug mode.  Warning: Without restarting robomaker won't be able to see the newly added database.