RE: [phpesp-general] Error 503: Unable to load ACL Table survey.designer doesn't exist

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Well... read through CONFIGURING PHPESP, it's right there on your server

http://www.docdope.com/phpESP-1.6.1/docs/INSTALL

You mainly care about these two lines:
=20
         $ mysql -u root -p < scripts/db/mysql_create.sql
         $ mysql -u root -p phpesp < scripts/db/mysql_populate.sql

=20

However, this is what you would do in a shell (cmd), but there should be
a way to do it with mysqladmin.

=20

Let me know how it goes.

=20

Roman

=20

=20

________________________________

From: llasher.com [mailto:ll...@ll...]=20
Sent: Saturday, August 28, 2004 6:13 AM
To: Roman Yashin
Cc: php...@li...
Subject: Re: [phpesp-general] Error 503: Unable to load ACL Table
survey.designer doesn't exist

=20

Er, the database "survey" is created and I can see it in mysqladmin, but
there are "no tables found in database", which I presume means it is not
populated. Do I have to somehow manually "populate" the db, and if so,
how would I do that? I have tried creating a table called "designer"
without any luck, although I am stabbing in the dark a bit as I can't
find anything in the docs that suggests I should do this ! :-(

=20

=20

	----- Original Message -----=20

	From: Roman Yashin <mailto:Ro...@ss...> =20

	To: llasher.com <mailto:ll...@ll...> =20

	Sent: Friday, August 27, 2004 2:15 AM

	Subject: RE: [phpesp-general] Error 503: Unable to load ACL
Table survey.designer doesn't exist

	=20

	If the tables are created and populated (you should be able to
see it in mysqladmin) there problem could be with apache2handler. I can
reproduce your problem here because I am on more stable 1.3. You do see
survey.designer in mysqladmin with at least root account, correct?

	=20

=09
________________________________

	From: php...@li...
[mailto:php...@li...] On Behalf Of
llasher.com
	Sent: Friday, August 27, 2004 9:58 AM
	To: php...@li...
	Subject: Fw: [phpesp-general] Error 503: Unable to load ACL
Table survey.designer doesn't exist

	=20

	=20

	----- Original Message -----=20

	From: llasher.com <mailto:ll...@ll...> =20

	To: Roman Yashin <mailto:Ro...@ss...> =20

	Sent: Thursday, August 26, 2004 11:54 PM

	Subject: Re: [phpesp-general] Error 503: Unable to load ACL
Table survey.designer doesn't exist

	=20

	Here is test.php. It looks OK to me, but there may be something
obvious I am missing.=20

	=20

	CHeers

	=20

PHP Information

*	Version: 4.3.8=20
*	OS: Linux=20
*	SAPI: apache2handler=20
*	register_globals: No=20
*	magic_quotes_gpc: No=20
*	magic_quotes_runtime: No=20
*	safe_mode: Yes=20
*	open_basedir: /home/httpd/vhosts/docdope.com/httpdocs:/tmp=20

PHP Extensions

*	dBase: No=20
*	GD: Yes -- bundled (2.0.23 compatible)=20
*	GNU Gettext: Yes=20
*	LDAP: No=20
*	MySQL: Yes=20
*	PHP Extension Dir (compiled): /usr/lib/php4=20
*	PHP Extension Dir (run time): /usr/lib/php4=20

phpESP Settings

*	Expected ESP_BASE:
/home/httpd/vhosts/docdope.com/httpdocs/phpESP-1.6.1/=20
*	Expected base_url: http://www.docdope.com/phpESP-1.6.1/=20
*	Loading phpESP.ini.php ...=20
*	ESP_BASE: /home/httpd/vhosts/docdope.com/httpdocs/phpESP-1.6.1/=20
*	base_url: http://www.docdope.com/phpESP-1.6.1/=20
*	Version: 1.6.1=20
*	Debug: No=20

phpESP Language Settings

*	GNU Gettext: Real=20
*	default_lang: en_US=20
*	current lang: en_US=20
*	available langs: da_DK, de_DE, el_GR, en_US, es_ES, fr_FR,
it_IT, ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
	(da, de, el, en, es, fr, it, ja, nl, pt, sv)=20
*	GNU Gettext test: Passed=20
*	Catalog Open Test: Yes=20

PHP Session Test

*	session.save_path: /var/lib/php/session=20
*	Counter: 32=20

		----- Original Message -----=20

		From: Roman Yashin <mailto:Ro...@ss...> =20

		To: llasher.com <mailto:ll...@ll...> =20

		Sent: Thursday, August 26, 2004 6:45 AM

		Subject: RE: [phpesp-general] Error 503: Unable to load
ACL Table survey.designer doesn't exist

		=20

		Mysqladmin should be good enough. You don't need to run
scripts from shell (cmd line). Could you access test.php
(http://your.domain/PathTophpESP/admin/test.php) and send me the output.

		=20

		Roman

		=20

	=09
________________________________

		From: llasher.com [mailto:ll...@ll...]=20
		Sent: Friday, August 27, 2004 9:41 AM
		To: Roman Yashin
		Subject: Re: [phpesp-general] Error 503: Unable to load
ACL Table survey.designer doesn't exist

		=20

		I am a noob to mysql and php, and I have no idea how I
would execute a mysql script via a cmd line. Instead I created a db in
mysql myself using mysqladmin for my webspace server, which is how I am
accustomed to creating dbs in mysql.=20

		=20

		Do I have to run this script and if so, how do I run
this script and the script after it to populate the database using a
Plesk cpanel and mysql? I don't understand how to run a script for a
server side process like mysql.

		=20

		PS I have fixed the problem sort of, by changing a
setting in the ini file: by changing the designer authentication line to
"false" I can get rid of the 503 error and access the page to design the
survey form. However, I suspect that this gives access to anyone to
design surveys on my page (not good). But I thought maybe this would
give a clue about the problem.

		=20

		Thanks for your prompt reply Roman! Please help me.

		=20

		llasher

			----- Original Message -----=20

			From: Roman Yashin
<mailto:Ro...@ss...> =20

			To: llasher.com <mailto:ll...@ll...> =20

			Sent: Thursday, August 26, 2004 5:58 AM

			Subject: RE: [phpesp-general] Error 503: Unable
to load ACL Table survey.designer doesn't exist

			=20

			Did you follow INSTALL steps, i.e. did you mysql
-uuser -p database < scripts/mysql_create.sql?

			=20

			Roman

			=20

		=09
________________________________

			From: php...@li...
[mailto:php...@li...] On Behalf Of
llasher.com
			Sent: Friday, August 27, 2004 8:49 AM
			To: php...@li...
			Subject: [phpesp-general] Error 503: Unable to
load ACL Table survey.designer doesn't exist

			=20

			I am unable to get past the error above.
('survey' is the name of my Mysql db).  The Mysql database settings in
the phpESP.ini.php file all seem correct, I have checked them.

			=20

			Does anyone have any ideas on how I make this
table 'exist' so I can progress?

			=20

			THanks

			=20

			llasher