[ic] Make a Catalog with SQL
delionsweb - minivend
Fri, 10 Nov 2000 16:56:43 -0500
First of all the Internal Server Error is NOT a catalog error per se ( >
90% of the time )
It is more likely that it is a link CGI error (tlink or vlink copy
installed in cgi-bin dir of the virtual web host.
So first you have to see if you can run the <home dir>/cgi-bin/construct
(This assumes that you told makecat that your cgi-bin directory is <home
You should get *nothing* when you run it like this: ./construct
You should get this if you run: ./construct test=1
Status: 404 Not Found
If you don't get this then you need to keep trying the bin/makecat with
different settings for the link CGI until you get a good result from the
Then you can try the browser.
Note that you should get the CGI working regardless of whether the
Interchange server is running or NOT. If the IC server is NOT running the
link program will tell you that it cannot connect. Command line and browser
also - note that the default timeout is 30 seconds and add the delay to the
web server to that for the browser test.
Until you get this working you will not know if you have a database problem
or not ... ;-)
Secondly, if you use the database option for the catalog, then you will see
lots of SQL statements fly past the FIRST time you start the interchange
server with the new catalog. That is a good clue that the SQL database
setup is working. You will NOT see these statements again UNLESS you drop
that database and create it blank and restart the interchange server.
Also, the makecat process for creating the catalog will complain about
database creation if that database exists so it is better in my opinion to
NOT create the database with the makecat if you know that it exists OR to
drop the database before you run makecat.
At 02:00 PM 11/10/2000, you wrote:
>Somebody knows why can't make a catalog that working with SQL?
>I'have made a catalog based on the construct catalog type, when makecat
>asked me what database i'wanted to use, i' answer mysql, i'gave the database
>name, created the database but empty, without tables, the tables definition
>were in dbconf/mysql/name.mysql, so when i'want to in the catalog as a user,
>it gave me an errormessage:
>"Internal Server Error"
>Thanks for help...
>Interchange-users mailing list