Hello,

Your appl. works great with a localhost database on the same server where the Joomla installation resides.

But when I try to use a remote MySQL database I'm having problems.

When I replace "localhost" with my remote MySQL database server webaddress in the form of "24.24.24.24:2424" I get a database connection error.

I checked with my hoster so I have the correct database webaddress. I also set my server to allow remote MySQL access from the IP where my Joomla with the login form is residing.

Is there anything wrong in the .php script with using the form "24.24.24.24:2424" ?

Also does the app. work with vTiger version 5.0.4 ?

Thanks,
Uwe

Hello Uwe,
Or if you are a German then "gruss got" :-). Thank you for employing our extension.
It works very well with Vtiger 5.0.4 .
I think the database connection is due to your unusual MySql port number, the default number is 3306. If you want to use a non default MySql port number the add it as an integer parameter in mysqli_connect in v_connect . It should be added as the last parameter, and remove it from the host definition, 24.24.24.24 instead of 24:24:24:24:2424
Cheers

Well, v_connect show us that in order to establish a connection between client side (Joomla) and vTiger's database "mysqli_connect" function is used. Far as I can remember you have to configure v_connect as follows:

// In the following line Replace vtiger_database_user_name with UserNameToAccessYourMysqlVitigerDatabase
$vtigerdb['username']="user";
// In the following line Replace vtiger_database_user_password with PasswordToAccessYourMysqlVitigerDatabase
$vtigerdb['password']="pass";
// In the following line Replace ip_address_or_url_of_mysql_vtiger_database_server with YourVtigerMysqlServerWebAddress
$vtigerdb['host']="ip";
// In the following line Replace vtiger_database_name with YourVtigerDatabaseName
$vtigerdb['database']="dbname";
//
// Do not modify the fallowing lines
//
@$vtdb = mysqli_connect($vtigerdb['host'], $vtigerdb['username'], $vtigerdb['password'], $vtigerdb['database'],yourport);

As you can see, despite the warning "Do not modify the 'fallowing' lines", you actually have to add your port number. I suggest you to add it as an integer (without quotation marks) because a number is requiered by the function. Hope it helps you.

I am getting:
Error
Vtiger database connection error

Having read the prior posts, I think I have the username, password, and URL correct. However, I don't think I have 'YourVtigerDatabaseName' correct. I have tried the mySQL DB name in my system, with and without 'vtiger' as a prefix.

FYI, my URL is of the form '23.23.244.244', I have also tried the IP the :1234 suffix. I have also tried it as 'http://23.23.244.244'

My host is hostgator.com. I have experienced hostgator requiring whitelisting. Please advise, thanks

I am getting:
Error
Vtiger database connection error

Having read the prior posts, I think I have the username, password, and URL correct. However, I don't think I have 'YourVtigerDatabaseName' correct. I have tried the mySQL DB name in my system, with and without 'vtiger' as a prefix.

FYI, my URL is of the form '23.23.244.244', I have also tried the IP the :1234 suffix. I have also tried it as 'http://23.23.244.244'

My host is hostgator.com. I have experienced hostgator requiring whitelisting. Please advise, thanks

I wonder if you add port number. I suggest you to take a look at mysqli_connect documentation Remember that port number is int, hence, you don´t need to add any kind of quotes.

Hope this solves the issue.

I am getting:
Error
Vtiger database connection error

Having read the prior posts, I think I have the username, password, and URL correct. However, I don't think I have 'YourVtigerDatabaseName' correct. I have tried the mySQL DB name in my system, with and without 'vtiger' as a prefix.

FYI, my URL is of the form '23.23.244.244', I have also tried the IP the :1234 suffix. I have also tried it as 'http://23.23.244.244'

My host is hostgator.com. I have experienced hostgator requiring whitelisting. Please advise, thanks

I wonder if you add port number. I suggest you to take a look at mysqli_connect documentation Remember that port number is int, hence, you don´t need to add any kind of quotes.

Hope this solves the issue.

I read the information, I believe I have the syntax correct. Hostgator requires that I add Remote Database Access Hosts, in the form 192.168.1.%. Could that be the problem, and if so, what is your address?

How did your config ended up???? May I see the params?