Re: [Phpwebsite-developers] PostGRE blues

[Adam M. <ad...@tu...>]

This is a more secure solution in the long run since a lot of our users
are running on someone else's servers anyway and they are only assigned
one database to their one user account.  On the other hand, if the
administrator knows what he/she is doing, the admin should create a
database and user for each install of phpwebsite anyway (instead of using
the root account).  This prevents a malicious user from completely
trashing your database should they somehow get your config information
(they can only trash the one instance of phpws attached to the config
info).

This may just be me rambling...

Adam

> Unfortunately, the list of things that differ between MySQL and other
> databases begins to grow.
>
> PostGRE requires a database to connect. This database is connected with
> the username of the PostGRE account.
>
> What this means is that you can't connect, and then create a database as
> you can with MySQL. So that functionality is probably going to be
> removed from the setup. It will instead tell the user they must create a
> database before continuing installation.
>
> We also talked about ways we could make this easier on the user. We
> could, perhaps, echo instructions on how to create the database in their
> respective db choice.
>
> We shall see tomorrow as we try to get a PostGRE install to run.
>
>
> Matthew McNaney
> Internet Systems Architect
> Electronic Student Services
> Email: ma...@tu...
> URL: http://phpwebsite.appstate.edu
> Phone: 828-262-6493
> ICQ: 141057403
>
>
>
>
> -------------------------------------------------------
> This sf.net emial is sponsored by: Influence the future
> of Java(TM) technology. Join the Java Community
> Process(SM) (JCP(SM)) program now.
> http://ad.doubleclick.net/clk;4699841;7576301;v?http://www.sun.com/javavote
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers


---------------------------------
Adam Morton
Developer - Web Technology Group
Appalachian State University
http://phpwebsite.appstate.edu