vtiger

[philip]

Hi,

The installation is cool. It goes like a breeze. I could go to the next steps, but unfortunately am unable to connect to the client. After the DB configurations etc with the default values, when I type http://localhost/ I get the following error.

Could not select database. Reason: Access denied for user: '@localhost' to database 'vtiger'

Can any one say whatz the problem :!:

Philip
to make things better

[indigoleopard]

Hi!

We acknowledge there is a small bug from our side which results in this.
In the screen where you are asked to fill in the hostname and the admin password for the db access, the default name that comes in Windows is localhost:5000. This should actually be <hostname>:5000. You need to give the hostname to get the proper installation going.

You can get the hostname in windows by doing the following.

a) Go to the Desktop
b) Rt click on My Computer
c) Click on Network Identification tab

The name listed there as Full Computer name is the hostname.
You need to give this name in the hostname field.
So it wil look like richie:5000 for that particular field.


Thanks,
Richie

[Michael]

Hi

My Distro

RHL 8.0
PHP 4.2.2
MySQL 3x
Apache 1x

In my m/c i have already installed Apache and MySQL. When i install vtiger.bin, it is not installing properly..

Any help !!!

Thanks
Michael.

[vtiger]

Michael:
We are working on improving the installer to check existing installations of MySQL and Apache. Please stay tuned.

We will also provide a zip version of download in addition to the bin. That should get you going shortly. Sorry for the inconvenience.

vtiger Team

[Michael]

Many Thanks

[Art P]

How does the installer know what db username and password to use when it is run?
It comes up with an invalid usernaem and password in the setup form, and I cannot change these values.
The result is that it cannot connect to the database, and I do not know where I can change these values.

[crouchingtiger]

Dear Art P,

Follow the steps given below to configure vtiger CRM 3.0 if vtigerCRM 3.0 Source.zip is used instead of EXE/bin:


1. Download the vtiger_CRM_3_0_Source.zip file from the following location:

http://prdownloads.sourceforge.net/vtigercrm/vtiger_CRM_3_0_Source.zip?download


2. Unzip the vtiger_CRM_3_0_Source.zip in the Apache document root directory.

3. Download the MessageBoard-mysql-db.zip from the following location:

http://prdownloads.sourceforge.net/vtigercrm/MessageBoard-mysql-db.zip?download

4. Unzip MessageBoard-mysql-db.zip. This contain mysql_schema.sql and mysql_basic.sql file.


Execute the above *.sql files to populate the Message Board data as given below:

mysql --user=<mysql_username> --password=<mysql_password> --port=<mysql_port> -h <hostname> vtigercrm3_0 < mysql_schema.sql

mysql --user=<mysql_username> --password=<mysql_password> --port=<mysql_port> -h <hostname> vtigercrm3_0 < mysql_basic.sql


Note: In the above commands the database name is vtigercrm3_0. If you want to use some other database, replace the database name in the above commands

5. In connection.php file present under <vtiger CRM Home> directory, populate the values for the following variables:

$mysql_username
$mysql_password
$mysql_port
$apache_port

These values will appear in the setup form in step 2

Example:

$mysql_username = 'root';
$mysql_password = 'public';
$mysql_port = '3306';
$apache_port = '0.0.0.0:80';

6. The default database name is vtigercrm3_0. If you want to use some other database then modify the 2setConfig.php file present under <vtiger CRM Home>/install/ directory as given below in all the places.

Modify $db_name = 'vtigercrm3_0';

to

$db_name = '<your database name>';


7. To migrate database from the existing vtiger CRM 2.1 to vtiger CRM 3.0 follow the procedure given below:

a)Download migrate_2_1to3_0.sql file from

http://prdownloads.sourceforge.net/vtigercrm/migrate_2_1to3_0.sql?download


b) Execute migrate_2_1to3_0.sql file as given below:

mysql --user=<mysql_username> --password=<mysql_password> --port=<mysql_port> -h <hostname> <database name> < migrate_2_1to3_0.sql

c) Execute the following command to add 'MessageBoard' in the Tab:

mysql --user=<mysql_username> --password=<mysql_password> --port=<mysql_port> -h <hostname> <database name> -e "insert into tabmenu values('','MessageBoard',1,13,'MessageBoard','','',0)"

Hope this helps in solving your problem.

Thanks & Regards
Don

[chrisj909]

Greetings,

I am trying to install your software using the bin. I have used all the bundled software except for the mysql package. I have verified all of the settings are indeed correct but I still get this message in step five of the install.php:

Unable to select database

Please advise.

Thanks,
Chris

[dcha]

Make sure the Mysql database is started. This message usually indicates the db is not started.

[chrisj909]

rCRM # ps -ef | grep mysql
root 9425 1 0 Dec14 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql 9447 9425 0 Dec14 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fury.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock
root 3292 3114 0 16:31 pts/6 00:00:00 grep mysql

Its definitly going as you see by the ps output. I can also access another site that uses this mysql db just fine.

Thanks for the quick reply... any other help is much appreciated as well.