Please check if the MySQL module is loaded in the PHP ini file (/etc/php4/cli/php.ini and
/etc/php4/apache2/php.ini).

Search for the line:

extension=mysql.so

If it was commented uncomment it and restart apache.

Also, please install "php4-gd" and "imagemagick" packages. Make sure the gd module is loaded in
PHP:

extension=gd.so

Mugur

--- Joseph Donth wrote:
> Paul,
>
> Thanks. That worked. Then I received the following error after "Installing
> CAMPSITE 2.6.1 "Joey"
>
> Checking install dependencies...PHP MySQL extension was not installed.
> Please install it.
>
> Thoughts,
> Joe
>
>
> ----- Original Message -----
> From: "Paul Baranowski"
> To:
> Sent: Monday, October 02, 2006 5:37 PM
> Subject: Re: [campsite-support] Debian 3.1 installation
>
>
> > Try installing "php4-cli"...looks like we forgot to add that to the
> > manual.
> >
> >
> > jdonth@donth.com wrote:
> >> Hello,
> >>
> >> I am attempting to evaluate the Campsite system (2.6.1) and can not get
> >> the installation script to work.
> >>
> >> I have purchased a virtual server from Linode.com and have installed a
> >> Debian 3.1 OS.
> >>
> >> I then performed the following updates:
> >> apt-get upgrade
> >> apt-get update
> >> apt-get apache
> >> apt-get php4
> >> apt-get mysql-server
> >> apt-get gcc
> >> apt-get xml-core
> >>
> >> followed by the dependency listed in the Campsite manual:
> >> apt-get install libdbd-mysql-perl libmysqlclient12 \
> >> libmysqlclient12-dev mysql-client mysql-common mysql-server \
> >> zlib1g-dev php4-mysql libxml2-dev libidn11-dev libcurl3-dev libssl-dev
> >>
> >> then
> >> wget
> >> http://easynews.dl.sourceforge.net/sourceforge/campsite/campsite-2.6.1.tar.gz
> >> tar xzvf campsite-2.6.1.tar.gz
> >> cd campsite
> >> ./install.sh
> >>
> >> And received the following error:
> >> Preparing install scripts...PHP CLI (Command Line Interface) not found.
> >> Please install this package
> >>
> >> Any idea where I am going wrong?
> >>
> >> Thanks,
> >> Joe Donth
> >>
> >>
> >
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

I forgot to include all the info from the screen:

Campsite create instance utility
--------------------------------
Create instance script version: 2.6.1 "Joey"
Creating instance: campsite
* Creating the database configuration...done.
* Creating the template engine configuration...done.
* Creating the email notifiers configuration...done.
* Creating the Apache configuration...done.
* Setting privileges to the configuration files...done.
* Creating site directories...done.
* Creating the site structure...done.
* Creating the Apache virtual host configuration file...done.
* Setting privileges for the site directories...done.
* Creating the database...There were ERRORS!!!\n
Unable to create the database campsite

Campsite parameters:
APACHE_USER = www-data
APACHE_GROUP = www-data
CAMPSITE_DIR = /usr/local/campsite
BIN_DIR = /usr/local/campsite/bin
SBIN_DIR = /usr/local/campsite/sbin
ETC_DIR = /usr/local/campsite/etc
WWW_DIR = /usr/local/campsite/www
WWW_COMMON_DIR = /usr/local/campsite/www-common
DEFAULT_SMTP_SERVER_ADDRESS = localhost
DEFAULT_SMTP_SERVER_PORT = 25
DEFAULT_DATABASE_SERVER_ADDRESS = localhost.localdomain
PARSER_START_PORT = 2000
VERSION = 2.6.1 "Joey"
DATABASE_NAME = campsite
DATABASE_SERVER_ADDRESS = localhost
DATABASE_SERVER_PORT = 0
DATABASE_USER = root
DATABASE_PASSWORD =
PARSER_PORT = 2001
PARSER_MAX_THREADS = 0
SMTP_SERVER_ADDRESS = localhost
SMTP_SERVER_PORT = 25
There were errors creating the default instance
Do you want to try again? (Y/N) [Y]:

----- Original Message -----
From: "Mugur Rus"
To:
Sent: Monday, October 02, 2006 11:54 PM
Subject: Re: [campsite-support] Debian 3.1 installation


> Please check if the MySQL module is loaded in the PHP ini file
> (/etc/php4/cli/php.ini and
> /etc/php4/apache2/php.ini).
>
> Search for the line:
>
> extension=mysql.so
>
> If it was commented uncomment it and restart apache.
>
> Also, please install "php4-gd" and "imagemagick" packages. Make sure the
> gd module is loaded in
> PHP:
>
> extension=gd.so
>
> Mugur
>
> --- Joseph Donth wrote:
>> Paul,
>>
>> Thanks. That worked. Then I received the following error after
>> "Installing
>> CAMPSITE 2.6.1 "Joey"
>>
>> Checking install dependencies...PHP MySQL extension was not installed.
>> Please install it.
>>
>> Thoughts,
>> Joe
>>
>>
>> ----- Original Message -----
>> From: "Paul Baranowski"
>> To:
>> Sent: Monday, October 02, 2006 5:37 PM
>> Subject: Re: [campsite-support] Debian 3.1 installation
>>
>>
>> > Try installing "php4-cli"...looks like we forgot to add that to the
>> > manual.
>> >
>> >
>> > jdonth@donth.com wrote:
>> >> Hello,
>> >>
>> >> I am attempting to evaluate the Campsite system (2.6.1) and can not
>> >> get
>> >> the installation script to work.
>> >>
>> >> I have purchased a virtual server from Linode.com and have installed a
>> >> Debian 3.1 OS.
>> >>
>> >> I then performed the following updates:
>> >> apt-get upgrade
>> >> apt-get update
>> >> apt-get apache
>> >> apt-get php4
>> >> apt-get mysql-server
>> >> apt-get gcc
>> >> apt-get xml-core
>> >>
>> >> followed by the dependency listed in the Campsite manual:
>> >> apt-get install libdbd-mysql-perl libmysqlclient12 \
>> >> libmysqlclient12-dev mysql-client mysql-common mysql-server \
>> >> zlib1g-dev php4-mysql libxml2-dev libidn11-dev libcurl3-dev
>> >> libssl-dev
>> >>
>> >> then
>> >> wget
>> >> http://easynews.dl.sourceforge.net/sourceforge/campsite/campsite-2.6.1.tar.gz
>> >> tar xzvf campsite-2.6.1.tar.gz
>> >> cd campsite
>> >> ./install.sh
>> >>
>> >> And received the following error:
>> >> Preparing install scripts...PHP CLI (Command Line Interface) not
>> >> found.
>> >> Please install this package
>> >>
>> >> Any idea where I am going wrong?
>> >>
>> >> Thanks,
>> >> Joe Donth
>> >>
>> >>
>> >
>>
>>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

Hi Joseph,

Please verify if you can connect to MySQL database with user root and empty password. You need to
specify a valid user and password when running the campsite-create-instance script.

Regards,
Mugur

--- Joseph Donth wrote:
> I forgot to include all the info from the screen:
>
> Campsite create instance utility
> --------------------------------
> Create instance script version: 2.6.1 "Joey"
> Creating instance: campsite
> * Creating the database configuration...done.
> * Creating the template engine configuration...done.
> * Creating the email notifiers configuration...done.
> * Creating the Apache configuration...done.
> * Setting privileges to the configuration files...done.
> * Creating site directories...done.
> * Creating the site structure...done.
> * Creating the Apache virtual host configuration file...done.
> * Setting privileges for the site directories...done.
> * Creating the database...There were ERRORS!!!\n
> Unable to create the database campsite
>
> Campsite parameters:
> APACHE_USER = www-data
> APACHE_GROUP = www-data
> CAMPSITE_DIR = /usr/local/campsite
> BIN_DIR = /usr/local/campsite/bin
> SBIN_DIR = /usr/local/campsite/sbin
> ETC_DIR = /usr/local/campsite/etc
> WWW_DIR = /usr/local/campsite/www
> WWW_COMMON_DIR = /usr/local/campsite/www-common
> DEFAULT_SMTP_SERVER_ADDRESS = localhost
> DEFAULT_SMTP_SERVER_PORT = 25
> DEFAULT_DATABASE_SERVER_ADDRESS = localhost.localdomain
> PARSER_START_PORT = 2000
> VERSION = 2.6.1 "Joey"
> DATABASE_NAME = campsite
> DATABASE_SERVER_ADDRESS = localhost
> DATABASE_SERVER_PORT = 0
> DATABASE_USER = root
> DATABASE_PASSWORD =
> PARSER_PORT = 2001
> PARSER_MAX_THREADS = 0
> SMTP_SERVER_ADDRESS = localhost
> SMTP_SERVER_PORT = 25
> There were errors creating the default instance
> Do you want to try again? (Y/N) [Y]:
>
> ----- Original Message -----
> From: "Mugur Rus"
> To:
> Sent: Monday, October 02, 2006 11:54 PM
> Subject: Re: [campsite-support] Debian 3.1 installation
>
>
> > Please check if the MySQL module is loaded in the PHP ini file
> > (/etc/php4/cli/php.ini and
> > /etc/php4/apache2/php.ini).
> >
> > Search for the line:
> >
> > extension=mysql.so
> >
> > If it was commented uncomment it and restart apache.
> >
> > Also, please install "php4-gd" and "imagemagick" packages. Make sure the
> > gd module is loaded in
> > PHP:
> >
> > extension=gd.so
> >
> > Mugur
> >
> > --- Joseph Donth wrote:
> >> Paul,
> >>
> >> Thanks. That worked. Then I received the following error after
> >> "Installing
> >> CAMPSITE 2.6.1 "Joey"
> >>
> >> Checking install dependencies...PHP MySQL extension was not installed.
> >> Please install it.
> >>
> >> Thoughts,
> >> Joe
> >>
> >>
> >> ----- Original Message -----
> >> From: "Paul Baranowski"
> >> To:
> >> Sent: Monday, October 02, 2006 5:37 PM
> >> Subject: Re: [campsite-support] Debian 3.1 installation
> >>
> >>
> >> > Try installing "php4-cli"...looks like we forgot to add that to the
> >> > manual.
> >> >
> >> >
> >> > jdonth@donth.com wrote:
> >> >> Hello,
> >> >>
> >> >> I am attempting to evaluate the Campsite system (2.6.1) and can not
> >> >> get
> >> >> the installation script to work.
> >> >>
> >> >> I have purchased a virtual server from Linode.com and have installed a
> >> >> Debian 3.1 OS.
> >> >>
> >> >> I then performed the following updates:
> >> >> apt-get upgrade
> >> >> apt-get update
> >> >> apt-get apache
> >> >> apt-get php4
> >> >> apt-get mysql-server
> >> >> apt-get gcc
> >> >> apt-get xml-core
> >> >>
> >> >> followed by the dependency listed in the Campsite manual:
> >> >> apt-get install libdbd-mysql-perl libmysqlclient12 \
> >> >> libmysqlclient12-dev mysql-client mysql-common mysql-server \
> >> >> zlib1g-dev php4-mysql libxml2-dev libidn11-dev libcurl3-dev
> >> >> libssl-dev
> >> >>
> >> >> then
> >> >> wget
> >> >> http://easynews.dl.sourceforge.net/sourceforge/campsite/campsite-2.6.1.tar.gz
> >> >> tar xzvf campsite-2.6.1.tar.gz
> >> >> cd campsite
> >> >> ./install.sh
> >> >>
> >> >> And received the following error:
> >> >> Preparing install scripts...PHP CLI (Command Line Interface) not
> >> >> found.
> >> >> Please install this package
> >> >>
> >> >> Any idea where I am going wrong?
> >> >>
> >> >> Thanks,
> >> >> Joe Donth
> >> >>
> >> >>
> >> >
> >>
> >>
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Mugur,

Thank you for your response. Here is what I get when I connect to mysql:


li9-198:~/campsite# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 41 to server version: 4.0.24_Debian-10sarge2-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> status;
--------------
mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)

Connection id: 41
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.24_Debian-10sarge2-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 49 min 7 sec

Threads: 1 Questions: 81 Slow queries: 0 Opens: 12 Flush tables: 1 Open
tables: 6 Queries per second avg: 0.027
--------------

Paul,

This is the result of your suggestion. does this help?

Thanks,
Joe



Last login: Fri Oct 6 09:33:45 2006 from adsl-11-48-73.mia.bellsouth.net
li9-198:~# mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.24_Debian-10sarge2-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> status;
--------------
mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)

Connection id: 5
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.24_Debian-10sarge2-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 28 sec

Threads: 1 Questions: 18 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.643
--------------

Mugur,

I ran the script you sent me and received the following error:

Can not create a database, please check if you have the privilege to create a database. ERROR: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8 COLLATE utf8_bin' at line 1

I commented out the characterset part (see below):

//$res = mysql_query("CREATE DATABASE `$dbName` CHARACTER SET utf8 COLLATE utf8_bin");
$res = mysql_query("CREATE DATABASE `$dbName`");

and it worked!

We're getting closer.

Thanks,
Joe