DB driver question

HI Again

Read on the Internet that Drupal was written in PHP. So you probably need to
setup your PHP to work with MySQL.

You should check out the manuals for PHP how to setup connections to MySQL.

Lars


"Mr. R" <jon.doe.DeleteThis@xxxxxxxxxxxxxxxxxx.xxx> skrev i meddelandet
news:XYsqj.3539$R_4.2457@newsb.telia.net...
> Hi
>
> This is some wild shots from me but they might work.
>
> What do you use to access the database? Do you use Java, PHP, ASP or what?
> IS Drupal what you use to connect to the database. I've never heard about
> it.
>
> I'm not that familiar with MySQL on a PC but I manage to install it bit I
> haven't got it to work iwith PHP yet.
>
> If you use PHP to access a MySQL database you usually have to call like
>
> $conn = mysql_connect( "localhost", "username", "password")
> // Note that you have to tell MySQL that you are connecting from the local
> hoast.
>
> if ($conn)
> {
> // If you get a Connection
> $db = mysql_select_db("MyDatabase",$conn);
> if ($db)
> {
> // Coonnected
> }
> else
> {
> // Not Connected
> }
> }
> else
> {
> // No connection established
> }
>
> You also have to make shure that the user and his/hers password to MySQL.
>
>
>
> NOTE
> I fyou are using PHP you must set PHP to support MySQL.
>
> For using the new configuration I think it's required to restart the
> server. That is unless you have made any newtwork changes that affects the
> Windows drivers.
>
> Lars
>
>
>
>
>
> "Jonathan Sachs" <js070717.DeleteThis@sbcglobal.net> skrev i meddelandet
> news:8kekq3hbkhs6v1mriv8u76lofpao9osfnf@4ax.com...
>> I'm installing Apache as infrastructure for Drupal, and I'm not very
>> familiar with it yet. My immediate problem is how to configure Apache
>> to use MySQL as its database server. I can't find an example to copy.
>> From my study of the reference documentation, I think this will do it,
>> in httpd.conf:
>>
>> DBDriver mysql
>> DBDParams user=<username>, pass=<password>, dbname=<dbname>
>>
>> Is that correct?
>>
>> A second question: in Windows, what must I do to make Apache recognize
>> changed config parameters? I found instructions which say that "Like
>> many UNIX-style programs, Apache will not re-read the .conf files
>> after the Web server starts running. After making changes, an
>> administrator must restart Apache for the new settings to take
>> effect." If I stop and restart Apache with Windows's Services applet,
>> will that do it? Or must I reboot?
>
>
 >> Stay informed about: DB driver question 

On Thu, 07 Feb 2008 01:15:35 GMT, "Mr. R" wrote:

>What do you use to access the database? Do you use Java, PHP, ASP or what?
>IS Drupal what you use to connect to the database. I've never heard about

Drupal is a content management application written in PHP.

http://drupal.org/

PHP is on the server, and is working. I haven't learned how to use it
yet, though -- job #1 is to get Drupal to the "kick it and it moves"
stage so that I'll have a framework to learn in.

I got the message I mentioned while running a configuration script
written in PHP. I suspect that the script is accessing the database
through an API provided by Apache, which is why I'm getting an error
message from Apache instead of MySQL.

>NOTE
>I fyou are using PHP you must set PHP to support MySQL.

I'll look into that, but I think that Drupal refers to the database
only through the Apache API, making it unnecessary to set PHP to
support MySQL. The instructions didn't say anything about that.

BTW, I found the answers to my original questions:

>> DBDriver mysql
>> DBDParams user=<username>, pass=<password>, dbname=<dbname>
>>
>> Is that correct?

It's not. Apache won't start with those directives in the conf file.
Something else, or something more, is needed.

>> If I stop and restart Apache with Windows's Services applet,
>> will that do it?

Yes -- at least well enough to make Apache fail to start when the conf
file contains an error.

I'm somewhat surprised that when Apache finds an error in the conf
file, it doesn't give a clue to what is wrong. It displayed an error
message which referred me to the system event log, but the message in
the log said in effect, "I found an error, and I'm going home now."
No clue to what was wrong. Is that information hiding somewhere else?
 >> Stay informed about: DB driver question 

"Jonathan Sachs" <js070717 RemoveThis @sbcglobal.net> skrev i meddelandet
news:sotkq3dpn47tfjm1e8fgageug99lrah905@4ax.com...
> On Thu, 07 Feb 2008 01:15:35 GMT, "Mr. R" wrote:
>
>>What do you use to access the database? Do you use Java, PHP, ASP or what?
>>IS Drupal what you use to connect to the database. I've never heard about
>
> Drupal is a content management application written in PHP.
>
> http://drupal.org/
>
> PHP is on the server, and is working. I haven't learned how to use it
> yet, though -- job #1 is to get Drupal to the "kick it and it moves"
> stage so that I'll have a framework to learn in.
>
> I got the message I mentioned while running a configuration script
> written in PHP. I suspect that the script is accessing the database
> through an API provided by Apache, which is why I'm getting an error
> message from Apache instead of MySQL.

Actually I think it is the PHP script that creates the access to the
database then it passes the information back to the web server.

>
>>NOTE
>>I fyou are using PHP you must set PHP to support MySQL.
>
> I'll look into that, but I think that Drupal refers to the database
> only through the Apache API, making it unnecessary to set PHP to
> support MySQL. The instructions didn't say anything about that.

I haven't seen any html code so far athat accesses a database. I think you
have to go through PHP, Java, VB Script or (ASP or ASP.NET but ASP is
difficult to set with Apache).

>
> BTW, I found the answers to my original questions:
>
>>> DBDriver mysql
>>> DBDParams user=<username>, pass=<password>, dbname=<dbname>
>>>
>>> Is that correct?
>
> It's not. Apache won't start with those directives in the conf file.
> Something else, or something more, is needed.
>
>>> If I stop and restart Apache with Windows's Services applet,
>>> will that do it?
>
> Yes -- at least well enough to make Apache fail to start when the conf
> file contains an error.
>
> I'm somewhat surprised that when Apache finds an error in the conf
> file, it doesn't give a clue to what is wrong. It displayed an error
> message which referred me to the system event log, but the message in
> the log said in effect, "I found an error, and I'm going home now."
> No clue to what was wrong. Is that information hiding somewhere else?

Usually you get a line number where the Apache server fails.

Make sure you have support for PHP in "httpd.conf". Search for php4

Here's some lines from an old PHP.INI file I found on my "client" PC

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
; extension=modulename.extension
;
; For example, on Windows:
;
; extension=msql.dll
;
; ... or under UNIX:
;
; extension=msql.so
;
; Note that it should be the name of the module only; no directory
information
; needs to go here. Specify the location of the extension with the
; extension_dir directive above.


; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP
5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

Also make sure that Apache loads the PHP module
# * = I don't know the exact file name it differs between Linuz and Windows
I think.
LoadModule php4*.so
# or
LoadModule php5*.dll

And there are other PHP options you must chek is there.


As a work arroung you could try to.

Uninstall MySQL, PHP and Apache. Then install them in the following order.

MySQL, Apache and last PHP.

The PHP install need Apache to be installed to add the LoadModule commands
automaticly. Don't know how to configure PHP automaticly under Windows as
you do in Linux. That's much easier done in Linux.

Lars
 >> Stay informed about: DB driver question 

"Jonathan Sachs" <js070717 RemoveThis @sbcglobal.net> schreef in bericht
news:8kekq3hbkhs6v1mriv8u76lofpao9osfnf@4ax.com...
> I'm installing Apache as infrastructure for Drupal, and I'm not very
> familiar with it yet. My immediate problem is how to configure Apache
> to use MySQL as its database server. I can't find an example to copy.
> From my study of the reference documentation, I think this will do it,
> in httpd.conf:
>
> DBDriver mysql
> DBDParams user=<username>, pass=<password>, dbname=<dbname>
>
> Is that correct?
>
> A second question: in Windows, what must I do to make Apache recognize
> changed config parameters? I found instructions which say that "Like
> many UNIX-style programs, Apache will not re-read the .conf files
> after the Web server starts running. After making changes, an
> administrator must restart Apache for the new settings to take
> effect." If I stop and restart Apache with Windows's Services applet,
> will that do it? Or must I reboot?

on http://drupal.org/getting-started/5 is a page called: "Install Drupal
5.x"
it has some lines about "Create database with MySQL"

this should clarify your problem..
 >> Stay informed about: DB driver question 

On Thu, 07 Feb 2008 04:03:59 GMT, "Mr. R" wrote:


>I haven't seen any html code so far athat accesses a database. I think you
>have to go through PHP, Java, VB Script or (ASP or ASP.NET but ASP is
>difficult to set with Apache).

I think I was not sufficiently clear -- I did not mean to suggest that
something in HTML was accessing the database. I assume that the PHP
script is making a call to the Apache API which causes Apache to
access the database.

I really think this is an Apache issue, not a PHP issue. First, the
whole purpose of the script is to prompt me for the database
name/user/password, and presumably store them for later use. But the
script fails before it even displays the prompt. It would make no
sense for the script to try to access the database before prompting me
for the information that would enable it to do so.

Also, there's that message from the script which says, "Your _web
server_ does not appear to support any common database types"
(emphasis added). Finally, I looked at the script and could not find
anything outside a comment that contained the string 'connect'.

If someone can give me an example of how Apache 2.2 is configured to
use MySQL, that ought to solve the problem.

>> I'm somewhat surprised that when Apache finds an error in the conf
>> file, it doesn't give a clue to what is wrong....
>
>Usually you get a line number where the Apache server fails.

In this case I didn't. I got what appears to be a generic message
from Windows Services which says that "Windows could not start the
Apache2.2..." It refers me to the System Event Log and mentions
"service-specific error code 1." The event log contains two messages,
but one just says "The Apache2.2 service entered the stopped state,"
and the other says "The Apache2.2 service terminated with
service-specific error 1 (0x1)."

>Make sure you have support for PHP in "httpd.conf". Search for php4

As a point of information, I installed PHP 5.2.5.5. I don't think
this matters, but I can't be sure.

>As a work arroung you could try to.
>
>Uninstall MySQL, PHP and Apache. Then install them in the following order.
>
>MySQL, Apache and last PHP.

I'm reluctant to do that because I've already done additional setup
work which I'd have to repeat (for example, defining the database and
users). I'll try it if I can't solve the problem more directly,
though. Thank you for the suggestion.
 >> Stay informed about: DB driver question 

"Jonathan Sachs" <js070717.TakeThisOut@sbcglobal.net> schreef in bericht
news:8kekq3hbkhs6v1mriv8u76lofpao9osfnf@4ax.com...
> I'm installing Apache as infrastructure for Drupal, and I'm not very
> familiar with it yet. My immediate problem is how to configure Apache
> to use MySQL as its database server. I can't find an example to copy.
> From my study of the reference documentation, I think this will do it,
> in httpd.conf:
>
> DBDriver mysql
> DBDParams user=<username>, pass=<password>, dbname=<dbname>
>
> Is that correct?
>
> A second question: in Windows, what must I do to make Apache recognize
> changed config parameters? I found instructions which say that "Like
> many UNIX-style programs, Apache will not re-read the .conf files
> after the Web server starts running. After making changes, an
> administrator must restart Apache for the new settings to take
> effect." If I stop and restart Apache with Windows's Services applet,
> will that do it? Or must I reboot?

maybe this post can help you configuring Apache with your setup
http://www.apachelounge.com/forum/viewtopic.php?p=9869

they use ODBC to connect Apache to MySQL5...

--
Luuk
 >> Stay informed about: DB driver question 

"Jonathan Sachs" <js070717.DeleteThis@sbcglobal.net> wrote in message
news:n91mq35oq2cad7daut6mqinu9a78q2qv3r@4ax.com...
> On Thu, 07 Feb 2008 04:03:59 GMT, "Mr. R" wrote:
>
>
>>I haven't seen any html code so far athat accesses a database. I think you
>>have to go through PHP, Java, VB Script or (ASP or ASP.NET but ASP is
>>difficult to set with Apache).
>
> I think I was not sufficiently clear -- I did not mean to suggest that
> something in HTML was accessing the database. I assume that the PHP
> script is making a call to the Apache API which causes Apache to
> access the database.

You assume wrong, php will access the database through its own database api.

> I really think this is an Apache issue, not a PHP issue. First, the
> whole purpose of the script is to prompt me for the database
> name/user/password, and presumably store them for later use. But the
> script fails before it even displays the prompt. It would make no
> sense for the script to try to access the database before prompting me
> for the information that would enable it to do so.
>
> Also, there's that message from the script which says, "Your _web
> server_ does not appear to support any common database types"
> (emphasis added). Finally, I looked at the script and could not find
> anything outside a comment that contained the string 'connect'.

Your web server is apache _with_ php

> If someone can give me an example of how Apache 2.2 is configured to
> use MySQL, that ought to solve the problem.
>
>>> I'm somewhat surprised that when Apache finds an error in the conf
>>> file, it doesn't give a clue to what is wrong....
>>
>>Usually you get a line number where the Apache server fails.
>
> In this case I didn't. I got what appears to be a generic message
> from Windows Services which says that "Windows could not start the
> Apache2.2..." It refers me to the System Event Log and mentions
> "service-specific error code 1." The event log contains two messages,
> but one just says "The Apache2.2 service entered the stopped state,"
> and the other says "The Apache2.2 service terminated with
> service-specific error 1 (0x1)."

You need to look in apache's error log for more information, you should find
this in the logs sub directory inside the directory where you installed
apache
for windows usually somewhere like:
C:\Program Files\Apache Group\Apache2\logs
 >> Stay informed about: DB driver question 

Hi

See the replies

"Jonathan Sachs" <js070717.TakeThisOut@sbcglobal.net> skrev i meddelandet
news:n91mq35oq2cad7daut6mqinu9a78q2qv3r@4ax.com...
> On Thu, 07 Feb 2008 04:03:59 GMT, "Mr. R" wrote:
>
>
>>I haven't seen any html code so far athat accesses a database. I think you
>>have to go through PHP, Java, VB Script or (ASP or ASP.NET but ASP is
>>difficult to set with Apache).
>
> I think I was not sufficiently clear -- I did not mean to suggest that
> something in HTML was accessing the database. I assume that the PHP
> script is making a call to the Apache API which causes Apache to
> access the database.

The way I use PHP is like a CGI script. Apache calls PHP scrips. Then the
PHP scripts gives a page back to the Apache server. Simply an HTML file to
send to the user. I undertand that you want to get around working direct
with PHP scripting. That's old HTML programming.

>
> I really think this is an Apache issue, not a PHP issue. First, the
> whole purpose of the script is to prompt me for the database
> name/user/password, and presumably store them for later use. But the
> script fails before it even displays the prompt. It would make no
> sense for the script to try to access the database before prompting me
> for the information that would enable it to do so.
>
> Also, there's that message from the script which says, "Your _web
> server_ does not appear to support any common database types"
> (emphasis added). Finally, I looked at the script and could not find
> anything outside a comment that contained the string 'connect'.

I read at the homepage for Drupal since I'm interestingin finding new ways
of creating homepages or should I say database pages over the Internet. The
homepage said some thing about ODBC, the common interface most databases
uses to help programs access the databases. Could this be the missing part?

If you don't have any ODBC connection you can't access the MySQL. That's the
Windows way to access databases. Borland has its own ODBC

I'm Installing MySQL, let's see if I can get back to you about ODBC
problems.

>
> If someone can give me an example of how Apache 2.2 is configured to
> use MySQL, that ought to solve the problem.

I have tried to use Apache 2.2 but as I found out Apache 2.0 works better
with PHP4 and PHP5. Don't know why.

>
>>> I'm somewhat surprised that when Apache finds an error in the conf
>>> file, it doesn't give a clue to what is wrong....
>>
>>Usually you get a line number where the Apache server fails.
>
> In this case I didn't. I got what appears to be a generic message
> from Windows Services which says that "Windows could not start the
> Apache2.2..." It refers me to the System Event Log and mentions
> "service-specific error code 1." The event log contains two messages,
> but one just says "The Apache2.2 service entered the stopped state,"
> and the other says "The Apache2.2 service terminated with
> service-specific error 1 (0x1)."
>
>>Make sure you have support for PHP in "httpd.conf". Search for php4
>
> As a point of information, I installed PHP 5.2.5.5. I don't think
> this matters, but I can't be sure.
>
>>As a work arroung you could try to.
>>
>>Uninstall MySQL, PHP and Apache. Then install them in the following order.
>>
>>MySQL, Apache and last PHP.
>
> I'm reluctant to do that because I've already done additional setup
> work which I'd have to repeat (for example, defining the database and
> users). I'll try it if I can't solve the problem more directly,
> though. Thank you for the suggestion.

Then leave MySQL installed and install Apache 2.0 and PHP5. I had problems
getting Apache 2.2 work with PHP as mentioned above.

At least in Linux its easy to backup the databases in my SQL. You sinply
store the the folder for example "MyDatabase". Then when you have
reinstalled MySQL you create the database MySQL and copy the old files to
the ceated MyDatabase files.

The discussion trigger a thought in my mind. I have to convert od MySQL
files to SQL Windows database. I might not have to. I'm going to install
MySQL and try to access NySQL from ASP.NET. Hopefully all old data are
there! Thank you for heloing me trigger that thought.

I also let you know whtn I have transferred my old database.


Lars
 >> Stay informed about: DB driver question 

I asked about my problem in the Drupal web site's forum and learned
what was wrong. You were correct that it was a PHP configuration
issue, but you couldn't have guessed what it was. PHP didn't even
have the MySQL extension, because the Drupal documentation didn't warn
me that with PHP 5 I would have to enable it explicitly in the
install.

I reinstalled PHP with the extension, and I now have a functioning
Drupal system. I can proceed to learn to use Drupal, which means that
I can proceed to learn PHP.
 >> Stay informed about: DB driver question 

Hi Jonathan

It's always good to know that it helps when we chat. Some times it also help
me helping others. I got to know about Drupal. Maybe some thing for my next
project.

PHP isn't really that hard to learn. I bought a Swedish book actually
written by a guy from my town with only 70.000 citizen, cool. www.asp.net is
a great site as referense when it comes to PHP.

THe fact that Drupal didn't warn you about PHP is probably due to the fact
that it encapsulates PHP for the user (programmer). That's the whole ide
with such tools. The same way ASP.NET encapsulates every connection, select.
edit or update command sent to the database.


Lars

"Jonathan Sachs" <js070717.DeleteThis@sbcglobal.net> skrev i meddelandet
news:m7jnq357hfoi0hbuejkiqj19no3cnpauc0@4ax.com...
>I asked about my problem in the Drupal web site's forum and learned
> what was wrong. You were correct that it was a PHP configuration
> issue, but you couldn't have guessed what it was. PHP didn't even
> have the MySQL extension, because the Drupal documentation didn't warn
> me that with PHP 5 I would have to enable it explicitly in the
> install.
>
> I reinstalled PHP with the extension, and I now have a functioning
> Drupal system. I can proceed to learn to use Drupal, which means that
> I can proceed to learn PHP.
 >> Stay informed about: DB driver question