Mailing List Archive


Back to the month index Back to the list index
Alvin Oga (alvin@planet.fef.com)
Sun, 19 Jan 1997 03:02:04 -0800 (PST) 

Message-Id: <m0vlv0n-00046GC@planet>
From: alvin@planet.fef.com (Alvin Oga)
Subject: [mSQL] w3-msql Error: Couldn't create temporary table (fwd)
Date: Sun, 19 Jan 1997 03:02:04 -0800 (PST)

>
>
> Hi All
>
> I just downloaded and installed msql-2.0B3 and copied w3-msql into /cgi-bin
> ( I'm running linux-2.0.27 with Apache-1.2b4
>
> I can load up the homepage of the bookmark db demo with
> http://planet.fef.com/cgi-bin/w3-msql/mSQL/Welcome.html
>
> but when I click on "Browse the Bookmarks Database", I get the error:
>
> Current Folder = /
>
> Error : Couldn't create temporary table
> --->>> Error at line 49
>
> QUESTION: Where is it trying to create this temporary table ??
> ( is it a permission problem ?? )
>
> Anybody have any idea on what causes the error ?
>
> I also dowloaded and searched the latest *.9612 and *.9701 archives and did not
> find any reference/solutions to this error
>
> and I can add/select/drop/create databases when I run msql manually...
>
> Exceprts from msql.acl ( for testing )
> #
> database=bookmarks
> read=alvin,root,WebMaster WebMaster is the UID of apache
> write=root,WebMaster
> access=local
>
> #
> database=w3-msql
> read=alvin,root,WebMaster
> write=root,WebMaster
> access=local
>
> And the directory and files should be writtable by "apache" which is group "wheel"
>
> planet:/usr/local/Hughes# ls -la msqldb
> drwxrwx--- 2 msql wheel 1024 Jan 19 00:53 bookmarks/
> drwx------ 2 msql root 1024 Jan 18 23:11 test/
> drwxrwx--- 2 msql wheel 1024 Jan 19 00:52 w3-msql/
>
> planet:/usr/local/Hughes# ls -la msqldb/bookmarks/
> -rw-rw---- 1 msql wheel 33105 Jan 19 02:05 bookmarks.dat
> -rw-rw---- 1 msql wheel 1092 Jan 19 00:53 bookmarks.def
> -rw-rw---- 1 msql wheel 0 Jan 19 00:53 bookmarks.idx
> -rw-rw---- 1 msql wheel 4 Jan 19 00:53 bookmarks.ofl
>
>
> planet:/usr/local/Hughes# bin/msqladmin version
>
> Version Details :-
>
> msqladmin version 2.0 Beta 3
> mSQL server version 2.0 Beta 3
> mSQL protocol version 22
> mSQL connection Localhost via UNIX socket
> Target platform Linux-2.0.27-i586
>
> Configuration Details :-
>
> Default config file /usr/local/Hughes/msql.conf
> TCP socket 1114
> UNIX socket /usr/local/Hughes/msql2.sock
> mSQL user msql
> Admin user root
> Install directory /usr/local/Hughes
> PID file location /usr/local/Hughes/msql2d.pid
>
> any hints would be appreciated...
> alvin
>

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!