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) 454-5900

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 ! :-(

  ----- Original Message -----=20
  From: Roman Yashin=20
  To: llasher.com=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

  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

-------------------------------------------------------------------------=
-----

  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=20

  To: Roman Yashin=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
      =20
          a.. Version: 4.3.8=20
          b.. OS: Linux=20
          c.. SAPI: apache2handler=20
          d.. register_globals: No=20
          e.. magic_quotes_gpc: No=20
          f.. magic_quotes_runtime: No=20
          g.. safe_mode: Yes=20
          h.. open_basedir: /home/httpd/vhosts/docdope.com/httpdocs:/tmp =

      =20
        PHP Extensions
      =20
          a.. dBase: No=20
          b.. GD: Yes -- bundled (2.0.23 compatible)=20
          c.. GNU Gettext: Yes=20
          d.. LDAP: No=20
          e.. MySQL: Yes=20
          f.. PHP Extension Dir (compiled): /usr/lib/php4=20
          g.. PHP Extension Dir (run time): /usr/lib/php4=20
      =20
        phpESP Settings
      =20
          a.. Expected ESP_BASE: =
/home/httpd/vhosts/docdope.com/httpdocs/phpESP-1.6.1/=20
          b.. Expected base_url: http://www.docdope.com/phpESP-1.6.1/=20
          c.. Loading phpESP.ini.php ...=20
          d.. ESP_BASE: =
/home/httpd/vhosts/docdope.com/httpdocs/phpESP-1.6.1/=20
          e.. base_url: http://www.docdope.com/phpESP-1.6.1/=20
          f.. Version: 1.6.1=20
          g.. Debug: No=20
      =20
        phpESP Language Settings
      =20
          a.. GNU Gettext: Real=20
          b.. default_lang: en_US=20
          c.. current lang: en_US=20
          d.. 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
          e.. GNU Gettext test: Passed=20
          f.. Catalog Open Test: Yes=20
      =20
        PHP Session Test
      =20
          a.. session.save_path: /var/lib/php/session=20
          b.. Counter: 32=20
      =20

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

    From: Roman Yashin=20

    To: llasher.com=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

-------------------------------------------------------------------------=
---

    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=20

      To: llasher.com=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

-------------------------------------------------------------------------=
-

      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