[gentoo-user] php & mysql problem

[gentoo-user] php & mysql problem

[Martin S]

[-- Attachment #1: Type: text/plain, Size: 977 bytes --]

Hi all,

I'm installing Apach2, Mysql 5.0.18 and PHP 5 on my laptop for a project.
However, when I install the main CMS system (Typo3 4.0) I keep getting
various

supplied argument is not a valid MySQL result resource

So I did a test page to see that PHP was actually emerged with the correct
USE flags

'--with-mysql=/usr/lib/mysql'
'--with-mysql-sock=/var/run/mysqld/mysqld.sock'

And did a check that I have the socket in the correct place

martoni@SuicidalPuppy ~ $ ls -l /var/run/mysqld/mysqld.sock
'srwxrwxrwx  1 mysql mysql 0 Jan  3 05:35 /var/run/mysqld/mysqld.sock
martoni@SuicidalPuppy ~ $

I've tried with PHP4 and PHP5, with MySQL 4.x and 5.x

I still can't get the system up. And the code is valid, as others are
running the beta code, and I had a Typo3 system
before my forced reinstallation.

I've read contless articles on Gentoo and Typo3 forums/lists but still...

Any suggestions how to get past this?


Regards,

Martin S

[-- Attachment #2: Type: text/html, Size: 1072 bytes --]

Re: [gentoo-user] php & mysql problem

[Alexander Kirillov]

> I'm installing Apach2, Mysql 5.0.18 and PHP 5 on my laptop for a project.
> However, when I install the main CMS system (Typo3 4.0) I keep getting
> various
> 
> supplied argument is not a valid MySQL result resource
> 
> So I did a test page to see that PHP was actually emerged with the 
> correct USE flags
> 
> '--with-mysql=/usr/lib/mysql' 
> '--with-mysql-sock=/var/run/mysqld/mysqld.sock'
>  
> And did a check that I have the socket in the correct place
> 
> martoni@SuicidalPuppy ~ $ ls -l /var/run/mysqld/mysqld.sock
> 'srwxrwxrwx  1 mysql mysql 0 Jan  3 05:35 /var/run/mysqld/mysqld.sock
> martoni@SuicidalPuppy ~ $
> 
> I've tried with PHP4 and PHP5, with MySQL 4.x and 5.x
> 
> I still can't get the system up. And the code is valid, as others are 
> running the beta code, and I had a Typo3 system
> before my forced reinstallation.
> 
> I've read contless articles on Gentoo and Typo3 forums/lists but still...
> 
> Any suggestions how to get past this?

There should be enough information in PHP and MySQL logs
to troubleshoot problems of this sort. Don't know anything about Typo3
but an app of this kind should come with a script which creates
databases, tables, users and grants privileges needed.
So I'd suggest to stop playing with PHP and MySQL versions -
they're pretty much backward compatible and dig into Typo3-related issues.

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] php & mysql problem

[Martin S]

[-- Attachment #1: Type: text/plain, Size: 1739 bytes --]

Yes, everything installs fine with Typo3. At least it looks like it.
Only thing is that after the installation routine I get the error messages.

2006/1/5, Alexander Kirillov <nevis2us@infoline.su>:
>
> > I'm installing Apach2, Mysql 5.0.18 and PHP 5 on my laptop for a
> project.
> > However, when I install the main CMS system (Typo3 4.0) I keep getting
> > various
> >
> > supplied argument is not a valid MySQL result resource
> >
> > So I did a test page to see that PHP was actually emerged with the
> > correct USE flags
> >
> > '--with-mysql=/usr/lib/mysql'
> > '--with-mysql-sock=/var/run/mysqld/mysqld.sock'
> >
> > And did a check that I have the socket in the correct place
> >
> > martoni@SuicidalPuppy ~ $ ls -l /var/run/mysqld/mysqld.sock
> > 'srwxrwxrwx  1 mysql mysql 0 Jan  3 05:35 /var/run/mysqld/mysqld.sock
> > martoni@SuicidalPuppy ~ $
> >
> > I've tried with PHP4 and PHP5, with MySQL 4.x and 5.x
> >
> > I still can't get the system up. And the code is valid, as others are
> > running the beta code, and I had a Typo3 system
> > before my forced reinstallation.
> >
> > I've read contless articles on Gentoo and Typo3 forums/lists but
> still...
> >
> > Any suggestions how to get past this?
>
> There should be enough information in PHP and MySQL logs
> to troubleshoot problems of this sort. Don't know anything about Typo3
> but an app of this kind should come with a script which creates
> databases, tables, users and grants privileges needed.
> So I'd suggest to stop playing with PHP and MySQL versions -
> they're pretty much backward compatible and dig into Typo3-related issues.
>
> --
> gentoo-user@gentoo.org mailing list
>
>


--
Regards,

Martin S

[-- Attachment #2: Type: text/html, Size: 2156 bytes --]

Re: [gentoo-user] php & mysql problem

[Alexander Kirillov]

Try to locate the first line in a php script which triggers the error
and use /usr/bin/mysql tool to either test connection parameters or
the query in question. You can also turn on MySQL query log.

> Yes, everything installs fine with Typo3. At least it looks like it.
> Only thing is that after the installation routine I get the error messages.
> 
> 2006/1/5, Alexander Kirillov < nevis2us@infoline.su 
> <mailto:nevis2us@infoline.su>>:
> 
>      > I'm installing Apach2, Mysql 5.0.18 and PHP 5 on my laptop for a
>     project.
>      > However, when I install the main CMS system (Typo3 4.0) I keep
>     getting
>      > various
>      >
>      > supplied argument is not a valid MySQL result resource
>      >
>      > So I did a test page to see that PHP was actually emerged with the
>      > correct USE flags
>      >
>      > '--with-mysql=/usr/lib/mysql'
>      > '--with-mysql-sock=/var/run/mysqld/mysqld.sock'
>      >
>      > And did a check that I have the socket in the correct place
>      >
>      > martoni@SuicidalPuppy ~ $ ls -l /var/run/mysqld/mysqld.sock
>      > 'srwxrwxrwx  1 mysql mysql 0 Jan  3 05:35 /var/run/mysqld/mysqld.sock
>      > martoni@SuicidalPuppy ~ $
>      >
>      > I've tried with PHP4 and PHP5, with MySQL 4.x and 5.x
>      >
>      > I still can't get the system up. And the code is valid, as others are
>      > running the beta code, and I had a Typo3 system
>      > before my forced reinstallation.
>      >
>      > I've read contless articles on Gentoo and Typo3 forums/lists but
>     still...
>      >
>      > Any suggestions how to get past this?
> 
>     There should be enough information in PHP and MySQL logs
>     to troubleshoot problems of this sort. Don't know anything about Typo3
>     but an app of this kind should come with a script which creates
>     databases, tables, users and grants privileges needed.
>     So I'd suggest to stop playing with PHP and MySQL versions -
>     they're pretty much backward compatible and dig into Typo3-related
>     issues.

-- 
gentoo-user@gentoo.org mailing list