Setting up PHP and MySQL

Support for webhosts that use CentOS
Xaroth
Posts: 8
Joined: 2008/01/25 15:53:40

Re: Setting up PHP and MySQL

Post by Xaroth » 2008/02/11 15:41:08

So I made (a little) progress by finding:
http://www.centos.org/docs/5/html/5.1/Deployment_Guide/s2-secureserver-generatingkey.html

I assume this is the "key" that needs to be generated before MySQL can be installed and configured... please correct me if I am wrong.

But only 10 lines down the doc, I run into a prompt asking me to type "genkey www.example.com"
And I am stuck again. >_>

I am looking to set up a server on a closed network -for- the closed network (small scale, really). Eventually, 4-5 computers will be connected to the network and will access the server for basic http services (so far). What should I use as the name of my server - and what all do I need to do before other computers on the network will be able to browse web pages hosted on the apache server?
But that is long term - right now I need to know how to generate a "public key" >_>

markkuk
Posts: 739
Joined: 2007/09/07 10:56:28
Location: Finland

Re: Setting up PHP and MySQL

Post by markkuk » 2008/02/15 12:24:34

Generating a SSL key for your own secure Web server has nothing to with installing the GPG keys used to sign the packages in the CentOS distribution. The CentOS public keys are included on the ditribution media and should be installed automatically. Please quote the exact error message you get (including the package name and the id of the missing key).

Xaroth
Posts: 8
Joined: 2008/01/25 15:53:40

Re: Setting up PHP and MySQL

Post by Xaroth » 2008/02/19 15:54:23

warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID e8562897

Public key for mysql-connector-odbc-3.51.12-2.2.i386.rpm is not installed

is the error when doing a "groupinstall 'MySQL Database'"

markkuk
Posts: 739
Joined: 2007/09/07 10:56:28
Location: Finland

Re: Setting up PHP and MySQL

Post by markkuk » 2008/02/20 09:10:49

Run the following command to install the GPG keys:
[code]rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*[/code]

User avatar
AlanBartlett
Forum Moderator
Posts: 9324
Joined: 2007/10/22 11:30:09
Location: ~/Earth/UK/England/Suffolk
Contact:

Re: Setting up PHP and MySQL

Post by AlanBartlett » 2008/02/20 17:52:03

[quote]Generating a SSL key for your own secure Web server has nothing to with installing the GPG keys used to sign the packages in the CentOS distribution. The CentOS public keys are included on the ditribution media and should be installed automatically. Please quote the exact error message you get (including the package name and the id of the missing key).[/quote]

[quote]warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID e8562897

Public key for mysql-connector-odbc-3.51.12-2.2.i386.rpm is not installed

is the error when doing a "groupinstall 'MySQL Database'"[/quote]

The installation (or more correctly, non-installation) of the public gpg key is a FAQ. Please note that is is not a bug but a feature.

This should help http://wiki.centos.org/FAQ/General#q10 (Granted, it needs to be updated with a reference to CentOS 5).

You might like to read this thread to its conclusion http://www.centos.org/modules/newbb/viewtopic.php?topic_id=12731&forum=37&post_id=41931#forumpost41931

HTH.
Alan.

User avatar
toracat
Forum Moderator
Posts: 7425
Joined: 2006/09/03 16:37:24
Location: California, US
Contact:

Re: Setting up PHP and MySQL

Post by toracat » 2008/02/21 02:58:47

[quote]
This should help http://wiki.centos.org/FAQ/General#q10 (Granted, it needs to be updated with a reference to CentOS 5).
[/quote]
Updated to include CentOS 5. :-)

User avatar
AlanBartlett
Forum Moderator
Posts: 9324
Joined: 2007/10/22 11:30:09
Location: ~/Earth/UK/England/Suffolk
Contact:

Re: Setting up PHP and MySQL

Post by AlanBartlett » 2008/02/21 13:02:12

[quote]Updated to include CentOS 5. [/quote]

Thanks, Akemi. :-D

Alan.

harold
Posts: 1
Joined: 2008/03/15 01:13:02
Contact:

Setting up PHP and MySQL

Post by harold » 2008/03/15 02:27:48

How can one Reset the MYSQL like it was freshly installed (maiden)

because - PhPBB 'finds' the MYSQL but cannot connect (localhost) access denied

(PhPBB doesn't cover your field, but is just a client..)

gerald_clark
Posts: 10642
Joined: 2005/08/05 15:19:54
Location: Northern Illinois, USA

Re: Setting up PHP and MySQL

Post by gerald_clark » 2008/03/17 14:17:34

Harold, do not hijack someone else's thread.
Read your PhPBB docs for setup instructions.
Read your MySQL manuals for login and security instructions.
Then start your own thread with specific questions.

Post Reply

Return to “CentOS 5 - Webhosting Support”