From: Daintree F. <p.d...@xt...> - 2003-03-13 00:13:15
|
Hi Federico, Great.- so glad you got up and running after all the effort you put in. Yes the system was designed to be run with the register_globals set to off - the problem with on is that users can pass variables to the scripts directly - a potential security issue - but also quite handy too! Could I use your name for a contact for a spanish version ? Regards Phil ----- Original Message ----- From: "Federico Vera" <fed...@ar...> To: "Daintree Family" <p.d...@xt...> Sent: Thursday, March 13, 2003 1:52 AM Subject: All runing ok! > Dear Phil > > I fixed the problem, I find out that variable arguments start with "&" and > some others don't start in a A HREF line, after the SID . > > I added this simbol and the problem was fixed. > > I had some problems with the session too, and I did a directory c:/php/tmp, > and the problem was fixed. > > Now I'm working on the translation, because I need this system in Spanish. > > Can the sistem work with global setting off? > > My idea to find out a sistem with Apache-php-mysql, was the independence of > plataform, I Ican run a server in windows-linux , I can expand network > without problems in a Intranet. and the workstations only need to run a web > browser in windows-linux. > > I'll be in contact with you. > > Thanks a lot for your help, in this way is easier to fix a problem. > > > Federico Vera - Argentina > > > > > > > ----- Original Message ----- > From: "Daintree Family" <p.d...@xt...> > To: "Web-ERP List" <web...@li...>; "Federico Vera" > <fed...@ar...> > Sent: Wednesday, March 12, 2003 3:39 AM > Subject: Re: now runing!, but with some problems > > > > Hi Federico, > > > > I cannot simulate this problem. > > > > I got this message: > > > > Warning: session_start() [function.session-start]: > > open(/tmp\sess_467e0da7dc4b471479be32ea0acf8cda, O_RDWR) failed: No such > > file or directory (2) in c:\program files\apache > > group\apache\htdocs\web-erp\header.inc on line 6 > > > > when I removed the file php.ini from the C:\windows directory altogether. > > > > All I had to do to fix it is to copy the file php.ini-dist to > > C:\Windows\php.ini > > and modified the line > > > > ;extension=php_pdf.dll > > to > > extension=php_pdf.dll > > > > to ensure that the pdf creation functionality in php was enabled. Many of > > the reports depend upon this. Also, I changed the line that read: > > > > session.save_path = /tmp > > to > > session.save_path = C:\Temp > > > > and I created the directory C:\Temp > > > > other than that the whole php.ini-dist file was unchanged. Then I > restarted > > apache from the Services in the control panel. > > I tried to get it to repeat your problem with register_globals on and off > > but as expected it works either way. Security-wise it is best to leave the > > default setting to off. > > > > I am sorry I cannot get my system to duplicate your problem. > > Have you compared your php.ini file to the default php.ini-dist file - in > > particular the variables surrounding the use of sessions? > > > > Regards > > Phil > > > > ----- Original Message ----- > > From: "Federico Vera" <fed...@ar...> > > To: "Daintree Family" <p.d...@xt...> > > Cc: <web...@li...> > > Sent: Wednesday, March 12, 2003 3:18 AM > > Subject: now runing!, but with some problems > > > > > > > Hi Phil > > > > > > > > > I have bee working the whole weekend in the apllication, I think that my > > > problem was to install php from the executable installation, I have > > > installed php from the zip file now, and it's working now! > > > > > > But somethings aren't working, and the problem is the following > > > > > > When I enter in a link with with session ID and another variable, the > > sistem > > > give me the followinr error: > > > > > > Warning: session_start() [function.session-start]: The session id > contains > > > illegal characters, valid characters are only a-z, A-Z and 0-9 in > > > c:\inetpub\wwwroot\apache\web-erp\header.inc on line 6 > > > > > > > > > I discover that the variable follow to the session ID and the browser > > cann't > > > detect the diference betwen the variable and the sesion ID. But I don't > > > don't how to fix it. > > > > > > > > > > > > .../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3Application= > > > stock > > > > > > > > > when I open a link with only the session ID all work fine > > > > > > .../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3 > > > > > > > > > Any suggestion? > > > > > > Thanks a lot for the previus mail > > > > > > > > > Federico Vera > > > > > > > > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > From: "Daintree Family" <p.d...@xt...> > > > To: "Andreas Berner" <an...@ne...>; "Federico Vera" > > > <fed...@ar...>; "Web-ERP List" <> > > > Sent: Sunday, March 09, 2003 5:27 AM > > > Subject: Re: [Web-erp-users] installation problems > > > > > > > > > > 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 > > > > > > > > > > > > > > |