Mittal'sss

Last week, for one of my projects, I had to access a database which was hosted on remote server and there was no phpMyAdmin installed on that server. As I am an avid user of phpMyAdmin and quite familiar with it, I wanted to access the remote database server using phpMyAdmin only. I knew that phpMyAdmin does give a facility to access database on remote server and it was just a matter of configuration to make it work. When we access http://localhost/phpmyadmin it connects to the local mysql server by default.

To make it connect to other servers you can follow the following steps:

Go to phpMyAdmin directory in your server installation (c:\wamp\phpmyadmin, in my case)

Open config.inc.php file and find

$cfg[‘Servers’] = array();
$i = 1

Below this the configuration of localhost would be provided. All the details of the localhost is given by
$cfg[‘Servers’][$i][‘variable_name’] = ‘value_of_the_variable’;

Many of the variables are defined like that.

Find the value declaration for localhost (mostly the last one would be $cfg['Servers'][$i]['AllowDeny']['rules'] = array();)

Then below this line we need to add the details for the another server we want to connect. We don’t need to repeat all the variables declared for localhost. Only those which are required should be declared for the server we are going to add.

We’ll have to increase the count $i and then give values.

Provide appropriate information for the server above.

Now change the value of $cfg['ServerDefault'] to 0. So that when you will open phpmyadmin it will ask you to select the server.

If you will set $cfg['ServerDefault'] = 1; then by default localhost will open.

If you set $cfg['ServerDefault'] = 2; then by default remote database will open.

Did you find this helpful??? No-> Sorry to waste your time and efforts of reading. Yes -> Glad to know that :-)

Recently I got a new Dell Studio 1555 laptop with Windows Vista Home Premium and this time I chose to try out Vista rather than replacing it with Windows XP. (It is running slow but still I am happy with its graphics and user interface. )

Coming to the point, after installing Yahoo! Messenger I tried to log into chat rooms and I could get into chat rooms but Voice option was disabled. Then once I went into a conference and again voice option was disabled and it was popping up the error “This computer does not support the required audio compression format.” Now this was something new for me. I am a chat bug for last 4 years and I never encountered this error so I was bit surprised to see that.

Finding the error, the first thing I usually do is search about it on Google and I did the same this time too. I could find that I was getting the error because required audio codec, DSP True Speech, was missing. Actually, Windows Vista has deprecated this codec and Yahoo! Messenger still uses it for Voice chat so it was obvious to get an error.

Problem was identified. Next step : Find the solution. Again, go to Google! Search for DSP True Speech download and got thousands of link. I was lucky to find
http://www.bytescribe.com/downloads/tsp_codec_install.exe in the very first effort. I downloaded it, installed it and restarted my lappy. Wooohhhhh !!!! After re-boot the voice chat was enabled and I could enjouy it in the Chat rooms and Conference as well.

Enjoy this if you are facing the same problem in Windows Vista

Problem : “This computer does not support the required audio compression format” Yahoo Messenger Voice chat error. Unable to use Voice chat feature in Chat rooms and Conference.

Solution : Install DSP True speech codec for vista.

Link to download codec : http://www.bytescribe.com/downloads/tsp_codec_install.exe

Conclusion : Enjoy voice chat!!! ;-)

Hello All,
This is Mittal Patel, a computer engineer from Ahmedabad. I have been into web development for last 3 years and currently I am working as a freelance Drupal developer and PHP/Drupal consultant at Regius IT Solutions Pvt. Ltd.

Currently I (along with Regius IT Solutions) have many projects to be developed in drupal and due to shortage of time I am not able to cope up with all the requirements. So I am looking for Drupal developers based at Ahmedabad who can work with me. I can offer freelance work, part time employement or full time employement depending upon your preference.

All I want to have is to find experienced Drupal developers who have previously developed custom modules or themes. (Those who are just familiar with using Drupal can also contact but please let me know your expertise level in advanced. Please don't claim you are expert at Module/Theme development unless you have really done so. )

Kindly contact me at admin@mittalpatel.co.in for further inquiries and discussion.

Thank you
- Mittal Patel

"Together we grow faster."

Pahele Alibaba Aur 40 Chor tha

Ab

Alibaba Aur 30 chor ban gaya

Poocho Kyon ?

.
.
.
.
.
.
.
.
.
.
.
.
.
.

Frustration gets at peak when I can’t access my internet for longer. Especially when I am in Ahmedabad and internet isn’t working due to some technical or other problem.

I missed to pay the bill of my internet connection as I was busy with preparation of my exam(TOEFL). On the very same day when exam got over, I couldn’t access my net. Internet connection was suspended due to non-payment of the bill. Ok, it was my mistake, I accepted. I ran to near by reliance web world and paid the necessary amount at 5 o’clock in the evening. To my happiness, the cash recipient lady informed that internet connection would be activated again within half an hour (wow, I was sooo delighted.)

My clock was running well. Even after two hours of wait, the situation was same. So I called reliance customer care to know what was going on. I could know that amount was received, bill was paid and I was supposed to wait for 4 hours to get my connection re-activated (Ok, here half an hour turned into 4 hours.) Another 2 hours of wait, still no result, no difference. I went crazy, again visited the reliance web world to discuss the problem. And I got very irresponsible answer that internet in our area was facing some problem. Actually there was nothing like that because my friend who use the same connection was surfing net at full speed.

I contacted customer care again at around 10. Still, no good response. Same answer, wait and watch, it will be resolved soon. The next day was Sunday. I kept contacting customer care on regular interval but it wasn’t my day. They raised complain again, told me to wait for 4 hours but I guess their 4 hours were never ending. I was clueless what was going on. It was really irritating that I couldn’t surf net for more than 24 hours and to my bad luck that irritation was to last one more night.