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

There must be a way to do it, but I'm not sure I know how!=20

It looks like the populate info for mysql could be entered manually =
using mysqladmin from looking at the content of mysql_populate.sql, but =
that seems like a lot of work. I will look into how it could be done on =
my server more economically and elegantly.

Thanks
  ----- Original Message -----=20
  From: Roman Yashin=20
  To: llasher.com=20
  Cc: php...@li...=20
  Sent: Friday, August 27, 2004 3:19 AM
  Subject: RE: [phpesp-general] Error 503: Unable to load ACL Table =
survey.designer doesn't exist

Well. read through CONFIGURING PHPESP, it's right there on your =
serverhttp://www.docdope.com/phpESP-1.6.1/docs/INSTALL

You mainly care about these two lines:          $ 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=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

    =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

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

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