I installed from the latest 4_2_3 source onto win2k3 server E E( that was running Sugar CRM)
I installed php 4.3.9 and mysql 4.1.18 as the prereq's specified and got php running under IIS6.
I modified the 2setConfig.php and config.php as specified for IIS
I created the mysql database
Error Message: Unable to connect to database Sever with the specified connection parameters. This may be due to the following reasons:
- specified database user, password , hostname or port is invalid.
- specified database user does not have access to connect to the database server from the host
Kindly check the specified database connection parameters...
Database Configuration
Host Name crmtest:3306
User Name root
Password ********
Database Name : vtigercrm4_2
C:\>mysql -h crmtest --port 3306 -u vtiger -D vtigercrm4_2 -
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 75 to server version: 4.1.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
2setConfig.php
has
$H_NAME=gethostbyaddr( 'a.b.c.d');
and
$db_name = 'vtigercrm4_2';
in it
connection.php
$mysql_dir = 'MYSQLINSTALLDIR';
$mysql_username = 'root';
$mysql_password = '********'; (yes my password)
$mysql_port = '3306';
$mysql_bundled = 'MYSQLBUNDLEDSTATUS';
$apache_dir = 'APACHEINSTALLDIR';
$apache_bin = 'APACHEBIN';
$apache_conf = 'APACHECONF';
$apache_port = 'APACHEPORT';
$apache_bundled = 'APACHEBUNDLED';
What is going on???
A clear set on installation insrtuctions would be handy for some one like me, not at all familiar with php or mysql..
Thanks in advance for any advice
Regards Colin Melboune Australia <!-- s:) --><img src="{SMILIES_PATH}/icon_smile.gif" alt=":)" title="Smile" /><!-- s:) --> <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>; <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>;
Comments
now having permissions problems
database vtigercrm4_2 user vtiger password password does not have sufficient permissions
user root no password is the superuser
step 5 of 5
create database tables
create command denied to user: 'vtiger@ozonline' for table 'convertleadmapping'tables partially created
fatal error: call to a member function on a non-object in c:\inetpub\wwwroot\vtigercrm\include\database\peardatabase.php on line 434
the web site gives:
warning: invalid argument supplied for foreach() in c:\inetpub\wwwroot\vtigercrm\index.php on line 541
<!-- s:roll: --><img src="{smilies_path}/icon_rolleyes.gif" alt=":roll:" title="rolling eyes" /><!-- s:roll: -->
the path environment variable didn't have c:\mysql\bin in it, so i had to change directory to mysql\bin in command prompt
the instructions above have a space between parameter and command, whereas i don't put one (eg, mysql -uroot -hlocalhost)
when you get into the mysql command client:
'show databases;' to see databases,
'use mysql;' to use the system database,
'select * from db;' to see the database specific permissions granted.
there were no entries for the user vtiger, so i've added full permissions for vtiger on the vtigercrm4_2 database. you can see with the above select tool how the user has y's in all the columns.