webERP Forum
Installation Issue - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Installation Issues (/forumdisplay.php?fid=13)
+--- Thread: Installation Issue (/showthread.php?tid=164)

Pages: 1 2


Installation Issue - ionous - 03-13-2012 07:22 PM

Hi,

I have just currently download the webERP and try to install it on the VMware using Windows XP operating system. I download the source in http://www.apachefriends.org/en/xampp.html for the prerequisites (Apache, mysql, PHPadmin and PHP). I have started the Apache and mysql using the console for xampp.

When I try to install webERP, it said that the config.php has been created (all fields have been filled up). When I try to login to the weberpdemo(in this case we used the demo database).

When I tried to login using admin with the password registered in the installation process, it returned error like this:

Warning: mysqli_connect() [function.mysqli-connect]: (HY000/1130): Host 'VMWareXP' is not allowed to connect to this MySQL server in C:\xampp\htdocs\webERP\includes\ConnectDB_mysqli.inc on line 17

Warning: mysqli_set_charset() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\webERP\includes\ConnectDB_mysqli.inc on line 23
Connect failed: Host 'VMWareXP' is not allowed to connect to this MySQL server
Clickhereto try logging in again


Does anyone know about this issue?


Thank you so much for any help given.


RE: Installation Issue - phil - 03-14-2012 10:09 AM

This is a connection issue to the mysql server....

1. Does phpMyAdmin work in XAMPP?
2. Is mysqli installed in your php installation?
3. Re-check the username and password you are using to connect to mysql


RE: Installation Issue - ionous - 03-15-2012 06:55 PM

Hi Phil,

Thanks for the help, actually now I can setup the webERP, but in this case I still have problem in triggering any of the function of the webERP. why when I triggering the one of the function, it become so long to render? Also, I have problem in the time format, I have set it to my country timezone during the installation, but the time is not updated?

Thank you for any helps.


RE: Installation Issue - phil - 03-15-2012 07:33 PM

I am afraid the sourceforge logo takes a while to render if you have a poor internet connection.
In most cases it is best to remove it by deleting the line in includes/footer.inc

Code:
    if(http_file_exists('http://sflogo.sourceforge.net/sflogo.php')) {
        echo '<tr><td class="footer"><a href="https://sourceforge.net/projects/web-erp"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=70949&type=12" width="120" height="30" border="0" alt="Get webERP web-based ERP Accounting at SourceForge.net. Fast, secure and Free Open Source software downloads" /></a></td></tr>';
    }

check in the file config.php for the entry:

Code:
putenv('TZ=Australia/Melbourne');

and check that the entry is one of the time zones at:
http://nz.php.net/manual/en/timezones.php


RE: Installation Issue - ionous - 03-16-2012 12:25 AM

Hi Phil,

Thanks for the help, it is now faster than before. In this case, I use putenv('TZ=Asia/Singapore'); but the time is still wrong. Any idea?

Thank you


RE: Installation Issue - phil - 03-16-2012 05:48 AM

Is the clock of the web-server incorrect? You will need to advise your web-host.


RE: Installation Issue - ionous - 03-16-2012 11:01 AM

Hi Phil,


The time zone is correct in the web-host. Any other ideas?


Thank you.


RE: Installation Issue - ionous - 03-20-2012 05:42 PM

Hi Phil,


Is there any updates on this?


Actually, I got the error when we tried to do a "Process Recurring Order" after the "enter recurring" is done, we found
"the error Recurring order 14 for QUICK - SLOW is being processed Date calculated for the next recurrence was: 2011-12-24" also under that error we found this:
"SUCCESS Report : Recurring order was created for Quick Brown PLC with order Number 58", Actually the number 58 is the number of process we created, but the company shouldn't be "Quick Brown PLC".

Do you know how it becomes like that? Have you find out the solution for the time format Phil?


Appreciate for your big help.


RE: Installation Issue - Exsonqu_Qu - 03-20-2012 07:45 PM

Hi, Sir,

What kind of errors are you reporting. It seems normal reminder messages.

Regards!

Exson

(03-20-2012 05:42 PM)ionous Wrote:  Hi Phil,


Is there any updates on this?


Actually, I got the error when we tried to do a "Process Recurring Order" after the "enter recurring" is done, we found
"the error Recurring order 14 for QUICK - SLOW is being processed Date calculated for the next recurrence was: 2011-12-24" also under that error we found this:
"SUCCESS Report : Recurring order was created for Quick Brown PLC with order Number 58", Actually the number 58 is the number of process we created, but the company shouldn't be "Quick Brown PLC".

Do you know how it becomes like that? Have you find out the solution for the time format Phil?


Appreciate for your big help.



RE: Installation Issue - BruceB - 03-31-2012 01:57 AM

Hi. I too was experiencing the issue of a different time displaying in the footer. I messed around with a few different timezone settings in config.php but the time always come up consistently as 6 hours ahead of my current time zone.

Looking at phpinfo() I was able to see that my PHP default timezone setting was for Europe/Berlin. After setting date.timezone in php.ini to America/Chicago and re-starting the web server the correct time displayed in the footer.

So basically the timezone setting in the config.php file is not over ridding the date.timezone setting.