openfire database connection problem in setup

When you setup the openfire on your server and if you face the database connection problem on your server than in many case the problem with the hostname. you need to use the hostname as “localhost” in case of database connection with your own server database.

Use hostname as domain or ip in case of  remote database connection. otherwise you need to use localhost  as hostname. so this issue will fix for sure.

 

Read More

rewrite

wordpress post name Permalink for localhost

If you getting trouble on running the wordpress system in your local system with post-name permalink than it is the problem of that your local server has disable the “rewrite module”.

For enable the “rewrite module” in your server you need to edit app-ache module stetting. So, after enaled this module you need to restart the server and then set post-name permalink from your wordpress system through admin panel and access any wordpress page or post you will see the permalink with post-name.

Read More

mozmenu

remove ads from Mozilla firefox

If you tired from ads in mozzila firefox browser and you need to remove the ads from your browser than you need to follow the below procedure.

->go to tools menu
-> then click on add on

.moz-addon

So, you will get the above screen. Now you need to remove unnecessary extension and plugins also visit the apprentice too. Than restart your browse and you will get the surfing with ads free.

Read More

Mysql set column character set

For converting mysql table character set for particular column than there is below query you can use. here we have change the character set of column say “col1″from default character set type may it Latin type to utf-8. this is support for all language and all characters of world wide.

Also if you want to change the character type of whole table means all column for the table than below query you need to use.

Read More

How to get information of your ip : domain to lookup

For getting the information from the ip of server or our local system, There is a api for that in which the api proider gives the information related to ip.

For Example : if you need to the location information of client or end user ip than use below code.

Also if you want the DNS information of the ip than you need to use below api.

So you will get the below output :

Read More

phpmyadmin automatic logout time

The default session logout time for mysql is 1440 secound. After this number of seconds, stored data will be seen as ‘garbage’ and cleaned up by the garbage collection process.

So if you want to stop auto logout of your phpmyadmin or mysql than go to php.ini file of your server and find the below statement.

You can edit the time and prevent the system from automatic log out from the mysql or phpmyadmin session.

Keep in mind that you must need to edit all php.ini file of your server.

If you have complain regarding to the phpmyadmin like “No activity within 1440 seconds; please log in again”
than you need to put this line as.. at path c:/wamp/appa/phpmyadmin4.0.4/config.inc.php

Read More

Phpmyadmin install on linux instance step by step

For installing phpmyadmin on linux server than follow below steps, you definitely will get install.
1. Follow below command to navigate to document root.
cd /var/www/html

2. follow this command: wget http://www.sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/3.4.1/phpMyAdmin-3.4.1-all-        languages.tar.bz2
3.  Unzip by typing: tar -jxf phpMyAdmin-3.4.1-all-languages.tar.bz2 -C /var/www/html
4.  rename the directory:mv phpMyAdmin-3.4.1-all-languages phpmyadmin
5.  Make a config directory in the phpmyadmin directory : cd /var/www/html/phpmyadmin and than mkdir config and than make copy by cp /var/www/html/phpmyadmin/config.sample.inc.php /var/www/html/phpmyadmin/config/config.inc.php.

6.  Open config.inc.php in VIM text editor by typing: sudo vim /var/www/html/phpmyadmin/config/config.inc.php

7.  Find the line that reads “$cfg[‘blowfish_secret’] = ”;” and change it so it reads:
$cfg[‘blowfish_secret’] = ‘type your secrete code';
secrete code has 60 character limit.
8.  Find the line that reads “$cfg[‘Servers’][$i][‘AllowNoPassword’] = false;” if you have not set the password for root than set true for this option.
9.  Hit “Esc” to get out of insert mode in your text editor. Then type:
:wq
Type it just like that, including the semicolon, to save and exit the file.
10.  Go to http://your_public_DNS/phpmyadmin/ and enter you mysql admin username and password. You should have recorded these in your notes when setting up the database above in step 7 of the previous section(not this one).

If you getting the error like permission denied than you need to following step

1) open mysql propmt by typing mysql. or giving sudo su root you can use for giving root user to permission.
2) Or follow $ mysql -uroot -p
3)mysql> select host, user from user;
+——————–+———+
| host | user |
+——————–+———+
| 127.0.0.1 | root |
| localhost | |
| localhost | foobar |
| localhost | root |
+——————–+———+
4)mysql> grant select on yourDatabase.* to yourUser@’urMachine.domain.com’ identified by ‘urPassword';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.05 sec)

5)mysql> select host, user from user;
+———————–+———+
| host | user |
+———————–+———+
| 127.0.0.1 | root |
| localhost | |
| localhost | redmine |
| localhost | root |
| urMachine.rovisys.com | urUser |
+———————–+———+

6) Now type http://yourdomain/phpmyadmin you can definitely open phpmyadmin.

Read More