Re: [Web-erp-users] installation problems

[Daintree F. <p.d...@xt...>]

Hi Andreas and Frederico,

To get a handle on the windows installation, I installed it today on Windows
using Apache 1.3.27
PHP 4.3.1 from the zip file
MySql Max 3.23.54 on Windows XP.

The traps I found were:

I installed PHP as a module and editing the C:\Program Files\Apache
Group\Apache\conf\httpd.conf file to
LoadModule php4_module C:/Program Files/php-4.3.1-Win32/sapi/php4apache.dll
failed for me so I moved the file php4apache.dll and the file php4ts.dll
(the file php4apache.dll needs this file) to C:\Windows (it could be
C:\Winnt in NT or 2000) and edited httpd.conf to:
LoadModule php4_module C:/Windows/php4apache.dll

The next problem was that having edited the extensions section of the
php-dist.ini file so that pdf extension was activated - by taking out the
semi colon before the line:

extension=php_pdf.dll

When Apache started it couldn't find the necessary php_pdf.dll
I moved the file from the php distribution files under extensions to
C:\Windows\System32 (this directory could be C:\Winnt\System32 or something
else on other versions - I am using XP).

Apache and PHP ran sweetly.
I tested the Apache PHP and MySQL were running by installing phpMyAdmin
2.4.0
I had modified the file C:/mysql/my-medium by uncommenting the line

# Uncomment the following if you are NOT using BDB tables
skip-bdb

then I uncommented the lines for innodb:

# Uncomment the following if you are using Innobase tables

innodb_data_file_path = ibdata1:40M

innodb_data_home_dir = c:\mysql\ibdata

innodb_log_group_home_dir = c:\mysql\iblogs

innodb_log_arch_dir = c:\mysql\iblogs

set-variable = innodb_mirrored_log_groups=1

set-variable = innodb_log_files_in_group=3

set-variable = innodb_log_file_size=5M

set-variable = innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=1

innodb_log_archive=0

set-variable = innodb_buffer_pool_size=16M

set-variable = innodb_additional_mem_pool_size=2M

set-variable = innodb_file_io_threads=4

set-variable = innodb_lock_wait_timeout=50

I created the directories for C:/mysql/ibdata and C:/mysql/iblogs

and changed its name to my.ini

Using the phpMyAdmin utility under the Show MySQL System variables link I
could see that the my.ini I had created under C:/mysql/my.ini was not being
read because the HAVE-BDB was not set to OFF and innodb_data_home_dir was
not set so I moved it and renamed it to:

C:/my.cnf

ie right under the root directory. I restarted MySql from the control panel
services.

Using phpMyAdmin utility under the Show MySQL System variables link, I could
now see that the my.cnf had been read and innodb variables were properly set
in particular HAVE-BDB was set to OFF and innodb_data_home_dir was set to
c:\mysql\ibdata

It was also evident that Innodb was working because 40Meg data file had been
created under C:/mysql/ibdata

I had been able to create the database in MySQL without Innodb enabled. you
can check that Innodb tables have been created using phpMyAdmin to enquire
upon the database weberp created. It will list the tables with the type of
table. The default is MyISAM the first one in the list to be an Innodb is
chartdetails - this was set to be a MyISAM type table, so I dropped the
database using phpMyAdmin and re-ran the web-erp-demo.sql script from a
command box knowing that Innodb was now operational:

C:/mysql/bin/mysql.exe --user=weberp --password=weberp < "C:/Program
Files/Apache Group/Apache/htdocs/web-erp/web-erp-demo.sql"

I got nasty messages about using the database weberp so I manually created
the database weberp using phpMyAdmin then edited out the line in
web-erp-demo.sql that creates the database.

Re-running it worked happily and away I went.

With Frederico's problem I am guessing that the table StockMaster is a
MyISAM type table and that Innodb only became operational subsequent to
creating the db. You need to drop it and re-create the db now you have
innodb going.

I hope this narrative helps,

Regards

Phil Daintree


----- Original Message -----
From: Federico Vera
To: web...@li...
Sent: Sunday, March 09, 2003 9:22 AM
Subject: [Web-erp-users] installation problems


Hello

I'm trying to setup the web-erp solution but I have some problems.

I have a Apache server under W98with php extension and  mysql with innodb
enable

I start the server with mysqld-max on the shell, I verified the show
variables and innodb is enable

This kind of messages that I put under this text appear on all the pages, I
have been lookin around for a week, I really don't what more I have to do, I
have global_setting on in the php config file too.




Notice: Undefined index: submit in
c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 17


Notice: Undefined variable: StockID in
c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 254




Could you give to me some clues.

I hope that you can help me

Regards

Federico Vera