fofredux-devel

[Fofredux-devel] Clean install problem

[Miles B. <mil...@gm...>]

I've done a clean install of Debian and FoFR. But now am getting the
below error when I try and run install.php.

Fatal error: Call to undefined function: mysql_connect() in
/var/www/fofredux/init.php on line 34

I think config.php is set up correctly but am at a loss now as what to try =
now.

Below is the php packages
ii  php4-common           4.3.10-16 Common files for packages built
from the php4 source
ii  php4-mysql            4.3.10-16 MySQL module for php4
ii  php4                     4.3.10-16                server-side,
HTML-embedded scripting language (meta-package)

Below is the mysql packages I have installed.
ii  mysql-client-4.1      4.1.11a-4sarge2       mysql database client binar=
ies
ii  mysql-common-4.1      4.1.11a-4sarge2       mysql database common
files (e.g. /etc/mysql/my.cnf)

ii  mysql-server-4.1      4.1.11a-4sarge2       mysql database server binar=
ies

Do I need anything else for this to work?

Re: [Fofredux-devel] Clean install problem

[Kevin <ke...@dr...>]

Miles Beck wrote:

>I've done a clean install of Debian and FoFR. But now am getting the
>below error when I try and run install.php.
>
>Fatal error: Call to undefined function: mysql_connect() in
>/var/www/fofredux/init.php on line 34
>
>
>  
>
Check to make sure the mysql module is loaded.   In php.ini, you should 
have a line like this:

extension=mysql.so

If this exists already, try restarting your webserver.

Are you using the apache module, or CGI version of php?   The php.ini 
file is in different locations for each.  You may have the extension 
loaded in one place but not the other.

-Kevin.

Re: [Fofredux-devel] Clean install problem

[Miles B. <mil...@gm...>]

On 12/29/05, Kevin <ke...@dr...> wrote:
> Check to make sure the mysql module is loaded.   In php.ini, you should
> have a line like this:
>
> extension=3Dmysql.so
>
> If this exists already, try restarting your webserver.
>
> Are you using the apache module, or CGI version of php?   The php.ini
> file is in different locations for each.  You may have the extension
> loaded in one place but not the other.
>
> -Kevin.

Thanks. That did the trick.

Now I have a question on whether or not I backed up the right database
files in case there was a problem with my server. The last backup I
did was on Friday. If I got the right files I'd like to restore the
database using them. The files I have are:

-rw-r--r--  1 mysql mysql    8660 2005-12-29 15:57 px_feeds.frm
-rw-r--r--  1 mysql mysql    9204 2005-12-29 15:57 px_feeds.MYD
-rw-r--r--  1 mysql mysql    2048 2005-12-29 15:57 px_feeds.MYI
-rw-r--r--  1 mysql mysql    8874 2005-12-29 15:57 px_items.frm
-rw-r--r--  1 mysql mysql 8722160 2005-12-29 15:57 px_items.MYD

If those are the right files what is the best way to restore the database?

-Miles

Re: [Fofredux-devel] Clean install problem

[Andrew T. (nilspace) <nil...@us...>]

The easiest way to 'backup' a mysql database, if you still have access
to the db, is to use mysqldump:

$> mysqldump -u username -p dbname -h hostname > dbname_backup_YYYYMMDD.sql

or something similar.

On 12/30/05, Miles Beck <mil...@gm...> wrote:
> On 12/29/05, Kevin <ke...@dr...> wrote:
> > Check to make sure the mysql module is loaded.   In php.ini, you should
> > have a line like this:
> >
> > extension=3Dmysql.so
> >
> > If this exists already, try restarting your webserver.
> >
> > Are you using the apache module, or CGI version of php?   The php.ini
> > file is in different locations for each.  You may have the extension
> > loaded in one place but not the other.
> >
> > -Kevin.
>
> Thanks. That did the trick.
>
> Now I have a question on whether or not I backed up the right database
> files in case there was a problem with my server. The last backup I
> did was on Friday. If I got the right files I'd like to restore the
> database using them. The files I have are:
>
> -rw-r--r--  1 mysql mysql    8660 2005-12-29 15:57 px_feeds.frm
> -rw-r--r--  1 mysql mysql    9204 2005-12-29 15:57 px_feeds.MYD
> -rw-r--r--  1 mysql mysql    2048 2005-12-29 15:57 px_feeds.MYI
> -rw-r--r--  1 mysql mysql    8874 2005-12-29 15:57 px_items.frm
> -rw-r--r--  1 mysql mysql 8722160 2005-12-29 15:57 px_items.MYD
>
> If those are the right files what is the best way to restore the database=
?
>
> -Miles
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_idv37&alloc_id=16865&opclick
> _______________________________________________
> Fofredux-devel mailing list
> Fof...@li...
> https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>


--
Andrew Turner
ajt...@hi...        42.4266N x 83.4931W
http://highearthorbit.com              Northville, Michigan, USA