[gold-users] Incomplete web interface

Scott Jackson scottmo at adaptivecomputing.com
Mon Jun 7 12:45:59 MDT 2010


Steve,

I am betting that this has to do with a recent change I made to 2.1, 
which was to always use aliases in support of SQLite wierdness.

Can you try making the following change, restart goldd and see if things 
improve?

Index: lib/Gold/Database.pm
===================================================================
--- lib/Gold/Database.pm    (revision 158)
+++ lib/Gold/Database.pm    (working copy)
@@ -497,7 +497,7 @@
         {
           $tmpSQL .= " AS " . toDBC($alias);
         }
-        else
+        elsif ($object)
         {
           $tmpSQL .= " AS " . toDBC($name);
         }

Thanks,

Scott

Crusan, Steve wrote:
> Scott,
>
> 	The script alias was the issue, (reading directions generally
> does help), but I was reluctant to change it since I had some other apps
> running on the server. I just setup a dedicated dev server for gold, and
> that fixed it.
>
> 	The only issue I'm having now is with the accounting section
> part of the web interface. I cannot list user accounts, modify or delete
> them (via the Web GUI anyway). 
>
> 	I get the following error from the web interface:
>
> <script type="text/javascript">//<![CDATA[
>   var searchValues = new Array();
>
>   function updateStatus(statusInfo) {
>     if (statusInfo)
>     {
>       parent.statusbar.document.location="status.cgi?" + statusInfo;
>     }
>   }
>
> //]]></script>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
> />
> </head>
> <body onload="updateStatus(&quot;message=DBD::Pg::st execute failed:
> ERROR:  syntax error at or near &quot;'g_a_n_y'&quot; at character 44
> &quot;)">
>
> </body>
> </html>
>
>
>
> Looking at the gold logs, I get the following:
>
> SQL Query: SELECT g_account.g_id AS g_id,'g_a_n_y' AS 'g_a_n_y','g_a_n_
> y' AS 'g_a_n_y','g_a_n_y' AS 'g_a_n_y' FROM g_account WHERE (  (
> g_account.g_id!='0' AND g_account.g_id!='0' )  ) AND g_delet
> ed!='True'
> 2010-06-07 14:04:40.072 TRACE Gold::Response::new  invoked with
> arguments: ()
> 2010-06-07 14:04:40.072 TRACE Gold::Response::failure  invoked with
> arguments: (720, DBD::Pg::st execute failed: ERROR:  syntax error at or
> near "'g_a_n_y'" at character 44
>
>
>
> Looking at the SELECT statement, it obv doesn't work when I connect to
> the DB and run it manually. I'm guessing the query is created from a few
> env variables such as the username that's connection to the web
> interface and such, but this happens no matter what user I use. 
>
> I this an error with my setup again? Everything else works well...
>
>
>  
> -----------------------------------------------
> Steve Crusan
> System Administrator
> Center for Research Computing
> University of Rochester
> (716) 239 - 0962
> -----Original Message-----
> From: Scott Jackson [mailto:scottmo at adaptivecomputing.com] 
> Sent: Friday, June 04, 2010 5:51 PM
> To: Crusan, Steve
> Cc: gold-users at supercluster.org
> Subject: Re: [gold-users] Incomplete web interface
>
> Steve,
>
> I am not certain from your description of things. Perhaps you need to 
> change ScriptAlias to Alias (removing all cgi-bin ScriptAlias entries) 
> in your httpd.conf files. Perhaps it is a role issue (have you 
> configured it so Anonymous can only see Users?). Have you restarted 
> goldd (sometimes gchpassword or role changes do not take until a 
> restart). If none of these seem to work, please send a screenshot of 
> what you are seeing.
>
> Thanks,
>
> Scott
>
>
> Steve Crusan wrote:
>   
>> Greetings,
>>
>>
>> I have installed gold (newest version in tree), setup it up, and ran 
>> run jobs and allocate funds w/ Maui/torque. Now, using the command 
>> line (as the gold user), I can view these statistics just fine.
>>
>> I can login to the web interface (as gold), but I only can see the 
>> users administration pane. I cannot open any of the other navigation 
>> panels, etc. Is there something else I need to enable and such, or is 
>> there a script that isn't working?
>>
>> Sorry if this is a dumb question...
>>
>> ----------------------
>> Steve Crusan
>> System Administrator
>> Center for Research Computing
>> University of Rochester
>> (716) 239 - 0962
>>
>>     
> ------------------------------------------------------------------------
>   
>> _______________________________________________
>> gold-users mailing list
>> gold-users at supercluster.org
>> http://www.supercluster.org/mailman/listinfo/gold-users
>>   
>>     


More information about the gold-users mailing list