Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Installation Issue
03-13-2012, 07:22 PM,
#1
Installation Issue
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.
Reply
03-14-2012, 10:09 AM,
#2
RE: Installation Issue
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
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
03-15-2012, 06:55 PM,
#3
RE: Installation Issue
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.
Reply
03-15-2012, 07:33 PM, (This post was last modified: 03-15-2012, 07:37 PM by phil.)
#4
RE: Installation Issue
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
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
03-16-2012, 12:25 AM,
#5
RE: Installation Issue
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
Reply
03-16-2012, 05:48 AM,
#6
RE: Installation Issue
Is the clock of the web-server incorrect? You will need to advise your web-host.
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
03-16-2012, 11:01 AM,
#7
RE: Installation Issue
Hi Phil,


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


Thank you.
Reply
03-20-2012, 05:42 PM, (This post was last modified: 03-20-2012, 05:45 PM by ionous.)
#8
RE: Installation Issue
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.


Attached Files Thumbnail(s)
   
Reply
03-20-2012, 07:45 PM,
#9
RE: Installation Issue
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.

Reply
03-31-2012, 01:57 AM,
#10
RE: Installation Issue
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.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)