Okay, I consider myself kinda a guru of sorts, and I don't really know how to fix this problem.. I do not know if I can even explain this right but I'll try.

I have installed apache, cause for sum reason I never thought I would need sql, so then I did an install of sql and needed, (hopefully all) librarys etc that php/sql, and apache needed to work together...now I get everything running.

I have added admin account password to mysql. I do not know if I have to add more users other than the one user 'shop' and my database called shop.

Now when I try and make a call from apache with any phpbackend etc, I get no responce from the sql server.

It' seems to me apache and the sql server are not talking correctly. Do I need to recompile apache?

Hope someone can help, thanx.

no, u dont need to recompile apache. is the mysqld running? check
ps -e | grep mysqld
that should display the process number if running
how did u install mysql. rpm? how did u start it and what error messages do u receive.
u can find info in my.cnf where to find an error-log of mysql. might be in var/lib/mysql/mysqld.log

hope that helps
j.

Just curious, how are you making the mysql "call from apache"? Are you using perl or some other scripting language?

Is it possible to login into mysql without the mysqld daemon running?

going to ckeck a few things, I did install sql with rpm, and I am trying to use perl, sql, apache.

I have set up a machine to do this before, and I am having troubles now.

I used to beable to type ;/

mysqladmin create testdatabase

and it would make but now I have to login etc. at terminal to use data base functions. hope this explains more while I ponder.

did u install the perl Mysql package? u need that to make the database connection with perl. if not go
http://search.cpan.org
and get it. If u ve installed the module there'll be a documentation available on your box by typing
perldoc Mysql

cheers, j

Yes,this must be installed, because I have the perldoc Mysql on the server..

so... what is wrong hehe, this problem has gotten the better of me.

did u place the perl script in the cgi-bin of the server? did u
chmod 0755 file.cgi
or chmod 0777 file.cgi ?
What does the server say? Any error messages?

I beleive perl isn't working cause I try .pl files in web browser and apache reports only an error...

this could be the root of my problem.

u have to configure the server to execute cgi scripts. if u have apache installed on your box there maybe a manual at
http://localhost/manual

to execute scripts ending with .pl
u should add a line in httpd.conf like this
AddHandler cgi-script .cgi .pl

well what I would like to happen is apache2 and mysql work together.

there must be something I am over looking, when any user on the machine can not just type:

mysqladmin create thedatabasename

and it creates for you... so mysql is working though I know this much, but apache isn't ? .pl I have done that.. anything else, cgi I have working have had for awhile now.

I can not seem to connect to data base the usuall way, and this is why I am confused..

perl -MCPAN -e "install DBD::MySql"

I can not install because it can not connect properly to the data base..

there must be something I am over looking, dejavu...

well i got perl-dbd-mysql installed, and now i get a little more from apache2 to mysql, but still things are not working correctly.

There is again 'something I am missing'