Monday, November 19, 2007

Apache, php, mysql continued

I added ServerName 127.0.0.1 to apache.conf in the /etc/apache2 directory ($APACHE_HOME ).
Changed the default port from 80 to 1080 in ports.conf. Note this is just so that http://localhost:1080 takes me to my home not http://localhost.

Stopping and starting apache
  • apache2ctl stop
  • apache2ctl start
Look up DocumentRoot in $APACHE_HOME/sites-available/default.Change the DocumentRoot to a directory that makes sense to you. Create an index.html file in this DocumentRoot directory.
Created a php file test.php in DocumentRoot.
Mine for instance has <?php phpinfo() ?>
Point your browser to http://localhost:1080/test.php to test.

http://localhost:1080/phpmyadmin takes you to the phpMyAdmin home page. Enter your userid and password that you created during the install.

Starting and Stopping mysql
mysqladmin -u root -p shutdown
mysqld & to startup.

Labels: , , ,

Saturday, November 10, 2007

How to Install Apache,PHP and Mysql on Ubuntu

Installing Apache , php and mysql was easy using the synaptic package manager.

  • Installed the database server mysql
  • Installed Apache server, apache2
  • Installed php (php5)
  • Installed libapache2-mod-auth-mysql
  • Installed php5-mysql
Next post, I will actually try using php to connect to mysql and build a page.

Labels: , ,

Wednesday, November 7, 2007

Oracle Min Max is not creating requisitions

Problem: Min Max is not generating requisitions. No errors.No data in po_requisitions_interface_all table.

Check the following item setup:

Inventory Item flag enabled
Stockable flag enabled
Transactable flag enabled


Purchased flag enabled
Purchasable flag enabled
Use Approved Supplier disabled

Inventory Planning Method is set to Min-Max
Source Type = Supplier
Make or Buy = Buy
Safety Stock = Non-MRP Planned

Profile : INV: Minmax Reorder Approval=Approved

Check to see if BOM Calendar / Workday Calendar is open for the demand dates in question. If not, open it and rebuild calendar.

Run MinMax with Restock=Yes

Labels: ,