473,573 Members | 2,510 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Considering Linux PHP App Deployment, Part 2, The Database Configuration

On Linux, I need to ask what your favorite installation options are for
a PHP app as a kind of poll. In Part 1, I discussed the Install Wizard
preference that you might have. In Part 2, here, I'm trying to decide
which options you prefer for the Database Configuration.

Consider SugarCRM. It's really an SDK that you customize. Knowing that,
you might want to download about 4 to 30 different PHP/CRM products,
try out which one you like, and then try to customize 3-4 of your top
choices, before you finally decide on which one is your favorite and go
with that. Most of these will also need to auto-detect the way you have
your MySQL or PGSQL database and try to create a database automatically
for you. If there is any false move or false assumption by one of these
organizations trying to pitch their app to you and you might be turned
off not to use it. About the only thing known on Linux is that you
might have PHP 4.x installed and a MySQL and PGSQL database.

Without getting into a war here over database choices, I really prefer
PostgreSQL for many reasons but want to make my app such that a
developer could customize it fairly easily for MySQL in about 1 to 2
weeks, single-handedly.

Different from MySQL, PostgreSQL has this notoriously wonderful
security feature in that it isn't connectable, right out of the box,
until you edit a couple of files and bounce the daemon. Even at that,
one file in particular, the pg_hba.conf, may be edited in about 4 to 8
different ways, depending on the type of choices a developer wants to
make. If you've played with PGSQL before, you might know that you can
enable the PHP app to connect only via local access under a certain
username, local access/any username, remote access/certain username,
remote/any username, and all of the above with or without a password.
(There are other options, but I've predicted that these are the most

Another concern is that some developers may prefer that the app connect
to the database under a different account than "root".

Knowing this, what kinds of things should the install wizard do and say
in trying to set up a database on Linux with PHP and PostgreSQL?

Aug 6 '05 #1
0 1195

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: DB developer | last post by:
Hello friends I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment toolkit (release candidate) to achieve this. I am facing the following problems I am deploying the database by copying to .MDF and .LDF files in destination folders using deployment...
by: Simon | last post by:
I'm doing a survey. When do you think GNU/Linux will be ready for the average Joe? What obstacles must it overcome first?
by: Google Mike | last post by:
On Linux, I need to ask what your favorite installation options are for a PHP app as a kind of poll. In this first part, I discuss the Install Wizard choices. In Part 2, I discuss the database configuration choices. Consider SugarCRM. It's really an SDK that you customize. Knowing that, you might want to download about 4 to 30 different...
by: srihari | last post by:
Hai, I am trying to install IBM DB2 8.1 on Red Hat linux 8.0. My machine is Intel XEON 64bit. The installation went well except for the creation of tools catalog. When I tried to install the tools catalog as a post installation task I get some java error. $ db2 CREATE TOOLS CATALOG SYSTOOLS USE EXISTING DATABASE TOOLSDB FORCE SQL22209N The...
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The objective in utilizing this new deployment method is to reduce the maintenance overhead as well as making it easier for my users to setup and run the...
by: Benny Ng | last post by:
Dear All, Now I just finished my winform application. And a part of that is to send email reminder to the users. It's working fine in the server that with SMTP service in Windows 2003. But now the user wants to used the Linux server to send email messages. (already installed the SMTP service in that). Unfortunatelly one error shown after...
by: Bruno LIVERNAIS | last post by:
Hi, We are currently installing a DB2 V9 ESE on a Linux server (RHEL4U4-x86_64). Installation runs successfully on each node. Database user environment is OK and the instance is well created. To be sure, we've started the database with db2start =successfull. And then shut it down again successfully too. The tricks appears when we switch...
by: Jeff Rush | last post by:
I'm down to the wire here on answering the Forrester survey but am stumped on a few questions I hope someone can help me out with. 1) What -existing- examples of the use of Python to create social web applications are there? These include chat, collaboration, forum boards, and editable content pages, RSS feeds. I know I use a lot of...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.