 | |
Re: [Info-ingres] Re: Remote Command Does not Start
comp.databases.ingres comp.databases.ingres
 |
| | Thread Tools | Search this Thread | Display Modes |
#1
 
| |||
| |||
|
Re: [Info-ingres] Re: Remote Command Does not Start -
10-23-2006
, 08:39 AM
|
Hi Jean, I didn't notice any complain during the installation. Below the command output: C:\Documents and Settings\alessandro.azzone>echo select dbmsinfo('username')\g | sql iidbdb INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation Ingres 2006 Microsoft Windows 32-bit Version II 9.0.4 (int.w32/105) login Mon Oct 23 13:18:01 2006 continue * Executing . . . +----------------------------------------------------------------+ |col1 | +----------------------------------------------------------------+ |alessandro.azzone | +----------------------------------------------------------------+ (1 row) * Ingres 2006 Version II 9.0.4 (int.w32/105) logout Mon Oct 23 13:18:01 2006 tnx Alessandro C:\Documents and Settings\alessandro.azzone C:\Documents and Settings\alessandro.azzone From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "aleazzone (AT) hotmail (DOT) com" <aleazzone (AT) hotmail (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:11:00 +0200 Hello, It depend on some differents things. please first ask to those 2 questions : - when you install ingres (with your username with a dot), did the installation process complain about it ? - when you run the following echo select dbmsinfo('username')\g | sql iidbdb what is the value returned by Ingres ? Thx 23 Oct 2006 03:46:56 -0700, aleazzone (AT) hotmail (DOT) com <aleazzone (AT) hotmail (DOT) com : Hi Jean-Pierre, thanks for your answer, it is enlightening. Is there any way in Windows to separate the Ingred account from the OS one? The problem is I do not have the administrator permission on my laptop and it seems I am in a cul de sac, as I can't see any of the remote command tables, views or procedures Rgds Alessandro Jean-Pierre Zuate wrote: Hello Allessandro, Don't you have a dot (.) in your username ? Not sure Ingres like that very much ... 1/ Your first error (E_RE0006) come from a lake of grant 2/ You have a lake of grant because rmcmdgen could not give it to your user After a short look in source code (rmcmdgen.sc) : - No grant mentionned in the source code (array affectation) have dot. - The grant is modified by adding the user name (probably something like %USERNAME% on W2K) - Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt) - and the message "Create rmcmd objects failed" is provided if return code is not OK Hope this help, Jean-Pierre ZUATE La Fage Conseil +33(0)6 1140 1109 23 Oct 2006 01:24:04 -0700, aleazzone (AT) hotmail (DOT) com aleazzone (AT) hotmail (DOT) com : Hi, I just installed INGRES on my window laptop but I noticed the Remote Command does not start and display the error: E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL error code was -30100. I tried the commands: "rmcmdrmv" followed by "rmcmdgen" But on the second one I get the following error: Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The correct syntax is: GRAN I really don't know how to proceed , please help. Many Thanks Alessandro _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres ------=_Part_54401_27296939.1161596406125 Content-Type: text/html; charset=ISO-8859-1 X-Google-AttachSize: 1998 Hello Allessandro,<br><br>Don't you have a dot (.) in your username ? Not sure Ingres like that very much ...<br><br>1/ Your first error (E_RE0006) come from a lake of grant<br>2/ You have a lake of grant because rmcmdgen could not give it to your user br><br>After a short look in source code (<a href="http://rmcmdgen.sc" rmcmdgen.sc</a>) :<br>- No grant mentionned in the source code (array affectation) have dot.<br>- The grant is modified by adding the user name (probably something like %USERNAME% on W2K) br>- Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt)<br>- and the message "Create rmcmd objects failed" is provided if return code is not OK<br><br>Hope this help,<br>Jean-Pierre ZUATE<br>La Fage Conseil br>+33(0)6 1140 1109<br><br><div><span class="gmail_quote">23 Oct 2006 01:24:04 -0700, <a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a> <<a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a :</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi, I just installed INGRES on my window laptop but I noticed the<br>Remote Command does not start and display the error: br><br>E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL<br>error code was -30100.<br><br> I tried the commands: "rmcmdrmv" followed by "rmcmdgen"<br><br>But on the second one I get the following error: br><br>Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The<br>correct syntax is: GRAN<br><br>I really don't know how to proceed , please help.<br><br>Many Thanks<br><br>Alessandro<br><br>__________________ _____________________________ br>Info-ingres mailing list<br><a href="mailto: Info-ingres (AT) cariboulake (DOT) c...lake (DOT) com</a><br><a href=" http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres" http://mailman.cariboulake.com/mailm...py/info-ingres /a><br></blockquote></div ------=_Part_54401_27296939.1161596406125-- _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 __________________________________________________ _______________ MSN Hotmail, la casella di posta elettronica da 250 MB! http://join.msn.com/hotmail/features |
--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
#2
| |||
| |||
|
|
From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "Alessandro Azzone" <aleazzone (AT) hotmail (DOT) com CC: Info-ingres (AT) cariboulake (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:39:33 +0200 Hello again ... I think I have a solution for you ... As mentionned in the documentation : System Administrator Guide Chapter 2 : Understanding Ingres components Visual Tools Remote Command Server : Grant access to Remote Users you must issue some grants (mentionned in the doc), as follow : grant select,insert,update,delete on $ingres.remotecmdinview to user grant select,insert,update,delete on $ingres.remotecmdoutview to user grant select,insert,update,delete on $ingres.remotecmdview to user grant execute on procedure $ingres.launchremotecmd to user grant execute on procedure $ingres.sendrmcmdinput to user grant register, raise on dbevent $ingres.rmcmdcmdend to user grant register, raise on dbevent $ingres.rmcmdnewcmd to user grant register, raise on dbevent $ingres.rmcmdnewinputline to user grant register, raise on dbevent $ingres.rmcmdnewoutputline to user grant register, raise on dbevent $ingres.rmcmdstp to user In your case you must enclose your username with double quote ("), as we can do know for table name with space in the name ... It's look like this (ready to run with sql command line) : grant select,insert,update,delete on $ingres.remotecmdinview to " alessandro.azzone"\p\g grant select,insert,update,delete on $ingres.remotecmdoutview to " alessandro.azzone"\p\g grant select,insert,update,delete on $ingres.remotecmdview to " alessandro.azzone"\p\g grant execute on procedure $ingres.launchremotecmd to "alessandro.azzone "\p\g grant execute on procedure $ingres.sendrmcmdinput to "alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdcmdend to "alessandro.azzone "\p\g grant register, raise on dbevent $ingres.rmcmdnewcmd to "alessandro.azzone "\p\g grant register, raise on dbevent $ingres.rmcmdnewinputline to " alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdnewoutputline to " alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdstp to "alessandro.azzone"\p\g Note for Ingres developpers (my favorite community :-) And to correct this bug in rmcmdgen the solution is perhap's to enclose systematicly username by double quote Hope this solve your issue ;-) Jean-Pierre 2006/10/23, Alessandro Azzone <aleazzone (AT) hotmail (DOT) com>: Hi Jean, I didn't notice any complain during the installation. Below the command output: C:\Documents and Settings\alessandro.azzone>echo select dbmsinfo('username')\g | sql iidbdb INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation Ingres 2006 Microsoft Windows 32-bit Version II 9.0.4 (int.w32/105) login Mon Oct 23 13:18:01 2006 continue * Executing . . . +----------------------------------------------------------------+ |col1 | +----------------------------------------------------------------+ |alessandro.azzone | +----------------------------------------------------------------+ (1 row) * Ingres 2006 Version II 9.0.4 (int.w32/105) logout Mon Oct 23 13:18:01 2006 tnx Alessandro C:\Documents and Settings\alessandro.azzone C:\Documents and Settings\alessandro.azzone From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "aleazzone (AT) hotmail (DOT) com" <aleazzone (AT) hotmail (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:11:00 +0200 Hello, It depend on some differents things. please first ask to those 2 questions : - when you install ingres (with your username with a dot), did the installation process complain about it ? - when you run the following echo select dbmsinfo('username')\g | sql iidbdb what is the value returned by Ingres ? Thx 23 Oct 2006 03:46:56 -0700, aleazzone (AT) hotmail (DOT) com <aleazzone (AT) hotmail (DOT) com : Hi Jean-Pierre, thanks for your answer, it is enlightening. Is there any way in Windows to separate the Ingred account from the OS one? The problem is I do not have the administrator permission on my laptop and it seems I am in a cul de sac, as I can't see any of the remote command tables, views or procedures Rgds Alessandro Jean-Pierre Zuate wrote: Hello Allessandro, Don't you have a dot (.) in your username ? Not sure Ingres like that very much ... 1/ Your first error (E_RE0006) come from a lake of grant 2/ You have a lake of grant because rmcmdgen could not give it to your user After a short look in source code (rmcmdgen.sc) : - No grant mentionned in the source code (array affectation) have dot. - The grant is modified by adding the user name (probably something like %USERNAME% on W2K) - Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt) - and the message "Create rmcmd objects failed" is provided if return code is not OK Hope this help, Jean-Pierre ZUATE La Fage Conseil +33(0)6 1140 1109 23 Oct 2006 01:24:04 -0700, aleazzone (AT) hotmail (DOT) com aleazzone (AT) hotmail (DOT) com : Hi, I just installed INGRES on my window laptop but I noticed the Remote Command does not start and display the error: E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL error code was -30100. I tried the commands: "rmcmdrmv" followed by "rmcmdgen" But on the second one I get the following error: Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The correct syntax is: GRAN I really don't know how to proceed , please help. Many Thanks Alessandro _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres ------=_Part_54401_27296939.1161596406125 Content-Type: text/html; charset=ISO-8859-1 X-Google-AttachSize: 1998 Hello Allessandro,<br><br>Don't you have a dot (.) in your username ? Not sure Ingres like that very much ...<br><br>1/ Your first error (E_RE0006) come from a lake of grant<br>2/ You have a lake of grant because rmcmdgen could not give it to your user br><br>After a short look in source code (<a href="http://rmcmdgen.sc" rmcmdgen.sc</a>) :<br>- No grant mentionned in the source code (array affectation) have dot.<br>- The grant is modified by adding the user name (probably something like %USERNAME% on W2K) br>- Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt)<br>- and the message "Create rmcmd objects failed" is provided if return code is not OK<br><br>Hope this help,<br>Jean-Pierre ZUATE<br>La Fage Conseil br>+33(0)6 1140 1109<br><br><div><span class="gmail_quote">23 Oct 2006 01:24:04 -0700, <a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a> <<a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a :</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi, I just installed INGRES on my window laptop but I noticed the<br>Remote Command does not start and display the error: br><br>E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL<br>error code was -30100.<br><br> I tried the commands: "rmcmdrmv" followed by "rmcmdgen"<br><br>But on the second one I get the following error: br><br>Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The<br>correct syntax is: GRAN<br><br>I really don't know how to proceed , please help.<br><br>Many Thanks<br><br>Alessandro<br><br>__________________ _____________________________ br>Info-ingres mailing list<br><a href="mailto: Info-ingres (AT) cariboulake (DOT) c...lake (DOT) com</a><br><a href=" http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres" http://mailman.cariboulake.com/mailm...py/info-ingres /a><br></blockquote></div ------=_Part_54401_27296939.1161596406125-- _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 __________________________________________________ _______________ MSN Hotmail, la casella di posta elettronica da 250 MB! http://join.msn.com/hotmail/features -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 |
Windows Live Messenger:E’ arrivato.Scopri la nuova versione!
http://get.live.com/messenger/features
#3
| |||
| |||
|
|
Hi Jean, do you mean executing the grants as Administrator? From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "Alessandro Azzone" <aleazzone (AT) hotmail (DOT) com CC: Info-ingres (AT) cariboulake (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:39:33 +0200 Hello again ... I think I have a solution for you ... As mentionned in the documentation : System Administrator Guide Chapter 2 : Understanding Ingres components Visual Tools Remote Command Server : Grant access to Remote Users you must issue some grants (mentionned in the doc), as follow : grant select,insert,update,delete on $ingres.remotecmdinview to user grant select,insert,update,delete on $ingres.remotecmdoutview to user grant select,insert,update,delete on $ingres.remotecmdview to user grant execute on procedure $ingres.launchremotecmd to user grant execute on procedure $ingres.sendrmcmdinput to user grant register, raise on dbevent $ingres.rmcmdcmdend to user grant register, raise on dbevent $ingres.rmcmdnewcmd to user grant register, raise on dbevent $ingres.rmcmdnewinputline to user grant register, raise on dbevent $ingres.rmcmdnewoutputline to user grant register, raise on dbevent $ingres.rmcmdstp to user In your case you must enclose your username with double quote ("), as we can do know for table name with space in the name ... It's look like this (ready to run with sql command line) : grant select,insert,update,delete on $ingres.remotecmdinview to " alessandro.azzone"\p\g grant select,insert,update,delete on $ingres.remotecmdoutview to " alessandro.azzone"\p\g grant select,insert,update,delete on $ingres.remotecmdview to " alessandro.azzone"\p\g grant execute on procedure $ingres.launchremotecmd to "alessandro.azzone "\p\g grant execute on procedure $ingres.sendrmcmdinput to "alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdcmdend to " alessandro.azzone "\p\g grant register, raise on dbevent $ingres.rmcmdnewcmd to " alessandro.azzone "\p\g grant register, raise on dbevent $ingres.rmcmdnewinputline to " alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdnewoutputline to " alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdstp to "alessandro.azzone"\p\g Note for Ingres developpers (my favorite community :-) And to correct this bug in rmcmdgen the solution is perhap's to enclose systematicly username by double quote Hope this solve your issue ;-) Jean-Pierre 2006/10/23, Alessandro Azzone <aleazzone (AT) hotmail (DOT) com>: Hi Jean, I didn't notice any complain during the installation. Below the command output: C:\Documents and Settings\alessandro.azzone>echo select dbmsinfo('username')\g | sql iidbdb INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation Ingres 2006 Microsoft Windows 32-bit Version II 9.0.4 (int.w32/105) login Mon Oct 23 13:18:01 2006 continue * Executing . . . +----------------------------------------------------------------+ |col1 | +----------------------------------------------------------------+ |alessandro.azzone | +----------------------------------------------------------------+ (1 row) * Ingres 2006 Version II 9.0.4 (int.w32/105) logout Mon Oct 23 13:18:01 2006 tnx Alessandro C:\Documents and Settings\alessandro.azzone C:\Documents and Settings\alessandro.azzone From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "aleazzone (AT) hotmail (DOT) com" <aleazzone (AT) hotmail (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:11:00 +0200 Hello, It depend on some differents things. please first ask to those 2 questions : - when you install ingres (with your username with a dot), did the installation process complain about it ? - when you run the following echo select dbmsinfo('username')\g | sql iidbdb what is the value returned by Ingres ? Thx 23 Oct 2006 03:46:56 -0700, aleazzone (AT) hotmail (DOT) com aleazzone (AT) hotmail (DOT) com : Hi Jean-Pierre, thanks for your answer, it is enlightening. Is there any way in Windows to separate the Ingred account from the OS one? The problem is I do not have the administrator permission on my laptop and it seems I am in a cul de sac, as I can't see any of the remote command tables, views or procedures Rgds Alessandro Jean-Pierre Zuate wrote: Hello Allessandro, Don't you have a dot (.) in your username ? Not sure Ingres like that very much ... 1/ Your first error (E_RE0006) come from a lake of grant 2/ You have a lake of grant because rmcmdgen could not give it to your user After a short look in source code (rmcmdgen.sc) : - No grant mentionned in the source code (array affectation) have dot. - The grant is modified by adding the user name (probably something like %USERNAME% on W2K) - Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt) - and the message "Create rmcmd objects failed" is provided if return code is not OK Hope this help, Jean-Pierre ZUATE La Fage Conseil +33(0)6 1140 1109 23 Oct 2006 01:24:04 -0700, aleazzone (AT) hotmail (DOT) com aleazzone (AT) hotmail (DOT) com : Hi, I just installed INGRES on my window laptop but I noticed the Remote Command does not start and display the error: E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL error code was -30100. I tried the commands: "rmcmdrmv" followed by "rmcmdgen" But on the second one I get the following error: Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The correct syntax is: GRAN I really don't know how to proceed , please help. Many Thanks Alessandro _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres ------=_Part_54401_27296939.1161596406125 Content-Type: text/html; charset=ISO-8859-1 X-Google-AttachSize: 1998 Hello Allessandro,<br><br>Don't you have a dot (.) in your username ? Not sure Ingres like that very much ...<br><br>1/ Your first error (E_RE0006) come from a lake of grant<br>2/ You have a lake of grant because rmcmdgen could not give it to your user br><br>After a short look in source code (<a href="http://rmcmdgen.sc" rmcmdgen.sc</a>) :<br>- No grant mentionned in the source code (array affectation) have dot.<br>- The grant is modified by adding the user name (probably something like %USERNAME% on W2K) br>- Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt)<br>- and the message "Create rmcmd objects failed" is provided if return code is not OK<br><br>Hope this help,<br>Jean-Pierre ZUATE<br>La Fage Conseil br>+33(0)6 1140 1109<br><br><div><span class="gmail_quote">23 Oct 2006 01:24:04 -0700, <a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a> <<a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a :</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi, I just installed INGRES on my window laptop but I noticed the<br>Remote Command does not start and display the error: br><br>E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL<br>error code was -30100.<br><br> I tried the commands: "rmcmdrmv" followed by "rmcmdgen"<br><br>But on the second one I get the following error: br><br>Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The<br>correct syntax is: GRAN<br><br>I really don't know how to proceed , please help.<br><br>Many Thanks<br><br>Alessandro<br><br>__________________ _____________________________ br>Info-ingres mailing list<br><a href="mailto: Info-ingres (AT) cariboulake (DOT) c...lake (DOT) com</a><br><a href=" http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres" http://mailman.cariboulake.com/mailm...py/info-ingres /a><br></blockquote></div ------=_Part_54401_27296939.1161596406125-- _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 __________________________________________________ _______________ MSN Hotmail, la casella di posta elettronica da 250 MB! http://join.msn.com/hotmail/features -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 __________________________________________________ _______________ Windows Live Messenger:E' arrivato.Scopri la nuova versione! http://get.live.com/messenger/features |
--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
#4
| |||
| |||
|
|
From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "Alessandro Azzone" <aleazzone (AT) hotmail (DOT) com CC: Info-ingres (AT) cariboulake (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:52:01 +0200 Administrator in the Ingres way yes, in the windows way, no. Issue your grant on imadb via sql or isql as follow : [isql|sql] imadb -u$ingres all system objects are owned by the particular user "$ingres". If you try the same on linux or unix, you must enclose $ingres by single quotes ('), because $ mean variable 2006/10/23, Alessandro Azzone <aleazzone (AT) hotmail (DOT) com>: Hi Jean, do you mean executing the grants as Administrator? From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "Alessandro Azzone" <aleazzone (AT) hotmail (DOT) com CC: Info-ingres (AT) cariboulake (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:39:33 +0200 Hello again ... I think I have a solution for you ... As mentionned in the documentation : System Administrator Guide Chapter 2 : Understanding Ingres components Visual Tools Remote Command Server : Grant access to Remote Users you must issue some grants (mentionned in the doc), as follow : grant select,insert,update,delete on $ingres.remotecmdinview to user grant select,insert,update,delete on $ingres.remotecmdoutview to user grant select,insert,update,delete on $ingres.remotecmdview to user grant execute on procedure $ingres.launchremotecmd to user grant execute on procedure $ingres.sendrmcmdinput to user grant register, raise on dbevent $ingres.rmcmdcmdend to user grant register, raise on dbevent $ingres.rmcmdnewcmd to user grant register, raise on dbevent $ingres.rmcmdnewinputline to user grant register, raise on dbevent $ingres.rmcmdnewoutputline to user grant register, raise on dbevent $ingres.rmcmdstp to user In your case you must enclose your username with double quote ("), as we can do know for table name with space in the name ... It's look like this (ready to run with sql command line) : grant select,insert,update,delete on $ingres.remotecmdinview to " alessandro.azzone"\p\g grant select,insert,update,delete on $ingres.remotecmdoutview to " alessandro.azzone"\p\g grant select,insert,update,delete on $ingres.remotecmdview to " alessandro.azzone"\p\g grant execute on procedure $ingres.launchremotecmd to "alessandro.azzone "\p\g grant execute on procedure $ingres.sendrmcmdinput to "alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdcmdend to " alessandro.azzone "\p\g grant register, raise on dbevent $ingres.rmcmdnewcmd to " alessandro.azzone "\p\g grant register, raise on dbevent $ingres.rmcmdnewinputline to " alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdnewoutputline to " alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdstp to "alessandro.azzone"\p\g Note for Ingres developpers (my favorite community :-) And to correct this bug in rmcmdgen the solution is perhap's to enclose systematicly username by double quote Hope this solve your issue ;-) Jean-Pierre 2006/10/23, Alessandro Azzone <aleazzone (AT) hotmail (DOT) com>: Hi Jean, I didn't notice any complain during the installation. Below the command output: C:\Documents and Settings\alessandro.azzone>echo select dbmsinfo('username')\g | sql iidbdb INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation Ingres 2006 Microsoft Windows 32-bit Version II 9.0.4 (int.w32/105) login Mon Oct 23 13:18:01 2006 continue * Executing . . . +----------------------------------------------------------------+ |col1 | +----------------------------------------------------------------+ |alessandro.azzone | +----------------------------------------------------------------+ (1 row) * Ingres 2006 Version II 9.0.4 (int.w32/105) logout Mon Oct 23 13:18:01 2006 tnx Alessandro C:\Documents and Settings\alessandro.azzone C:\Documents and Settings\alessandro.azzone From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "aleazzone (AT) hotmail (DOT) com" <aleazzone (AT) hotmail (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:11:00 +0200 Hello, It depend on some differents things. please first ask to those 2 questions : - when you install ingres (with your username with a dot), did the installation process complain about it ? - when you run the following echo select dbmsinfo('username')\g | sql iidbdb what is the value returned by Ingres ? Thx 23 Oct 2006 03:46:56 -0700, aleazzone (AT) hotmail (DOT) com aleazzone (AT) hotmail (DOT) com : Hi Jean-Pierre, thanks for your answer, it is enlightening. Is there any way in Windows to separate the Ingred account from the OS one? The problem is I do not have the administrator permission on my laptop and it seems I am in a cul de sac, as I can't see any of the remote command tables, views or procedures Rgds Alessandro Jean-Pierre Zuate wrote: Hello Allessandro, Don't you have a dot (.) in your username ? Not sure Ingres like that very much ... 1/ Your first error (E_RE0006) come from a lake of grant 2/ You have a lake of grant because rmcmdgen could not give it to your user After a short look in source code (rmcmdgen.sc) : - No grant mentionned in the source code (array affectation) have dot. - The grant is modified by adding the user name (probably something like %USERNAME% on W2K) - Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt) - and the message "Create rmcmd objects failed" is provided if return code is not OK Hope this help, Jean-Pierre ZUATE La Fage Conseil +33(0)6 1140 1109 23 Oct 2006 01:24:04 -0700, aleazzone (AT) hotmail (DOT) com aleazzone (AT) hotmail (DOT) com : Hi, I just installed INGRES on my window laptop but I noticed the Remote Command does not start and display the error: E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL error code was -30100. I tried the commands: "rmcmdrmv" followed by "rmcmdgen" But on the second one I get the following error: Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The correct syntax is: GRAN I really don't know how to proceed , please help. Many Thanks Alessandro _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres ------=_Part_54401_27296939.1161596406125 Content-Type: text/html; charset=ISO-8859-1 X-Google-AttachSize: 1998 Hello Allessandro,<br><br>Don't you have a dot (.) in your username ? Not sure Ingres like that very much ...<br><br>1/ Your first error (E_RE0006) come from a lake of grant<br>2/ You have a lake of grant because rmcmdgen could not give it to your user br><br>After a short look in source code (<a href="http://rmcmdgen.sc" rmcmdgen.sc</a>) :<br>- No grant mentionned in the source code (array affectation) have dot.<br>- The grant is modified by adding the user name (probably something like %USERNAME% on W2K) br>- Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt)<br>- and the message "Create rmcmd objects failed" is provided if return code is not OK<br><br>Hope this help,<br>Jean-Pierre ZUATE<br>La Fage Conseil br>+33(0)6 1140 1109<br><br><div><span class="gmail_quote">23 Oct 2006 01:24:04 -0700, <a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a> <<a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a :</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi, I just installed INGRES on my window laptop but I noticed the<br>Remote Command does not start and display the error: br><br>E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL<br>error code was -30100.<br><br> I tried the commands: "rmcmdrmv" followed by "rmcmdgen"<br><br>But on the second one I get the following error: br><br>Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The<br>correct syntax is: GRAN<br><br>I really don't know how to proceed , please help.<br><br>Many Thanks<br><br>Alessandro<br><br>__________________ _____________________________ br>Info-ingres mailing list<br><a href="mailto: Info-ingres (AT) cariboulake (DOT) c...lake (DOT) com</a><br><a href=" http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres" http://mailman.cariboulake.com/mailm...py/info-ingres /a><br></blockquote></div ------=_Part_54401_27296939.1161596406125-- _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 __________________________________________________ _______________ MSN Hotmail, la casella di posta elettronica da 250 MB! http://join.msn.com/hotmail/features -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 __________________________________________________ _______________ Windows Live Messenger:E' arrivato.Scopri la nuova versione! http://get.live.com/messenger/features -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 |
Condivi le tue emozioni ! http://discoverspaces.live.com/?loc=it-IT
#5
| |||
| |||
|
|
From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "Alessandro Azzone" <aleazzone (AT) hotmail (DOT) com CC: Info-ingres (AT) cariboulake (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:52:01 +0200 Administrator in the Ingres way yes, in the windows way, no. Issue your grant on imadb via sql or isql as follow : [isql|sql] imadb -u$ingres all system objects are owned by the particular user "$ingres". If you try the same on linux or unix, you must enclose $ingres by single quotes ('), because $ mean variable 2006/10/23, Alessandro Azzone <aleazzone (AT) hotmail (DOT) com>: Hi Jean, do you mean executing the grants as Administrator? From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "Alessandro Azzone" <aleazzone (AT) hotmail (DOT) com CC: Info-ingres (AT) cariboulake (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:39:33 +0200 Hello again ... I think I have a solution for you ... As mentionned in the documentation : System Administrator Guide Chapter 2 : Understanding Ingres components Visual Tools Remote Command Server : Grant access to Remote Users you must issue some grants (mentionned in the doc), as follow : grant select,insert,update,delete on $ingres.remotecmdinview to user grant select,insert,update,delete on $ingres.remotecmdoutview to user grant select,insert,update,delete on $ingres.remotecmdview to user grant execute on procedure $ingres.launchremotecmd to user grant execute on procedure $ingres.sendrmcmdinput to user grant register, raise on dbevent $ingres.rmcmdcmdend to user grant register, raise on dbevent $ingres.rmcmdnewcmd to user grant register, raise on dbevent $ingres.rmcmdnewinputline to user grant register, raise on dbevent $ingres.rmcmdnewoutputline to user grant register, raise on dbevent $ingres.rmcmdstp to user In your case you must enclose your username with double quote ("), as we can do know for table name with space in the name ... It's look like this (ready to run with sql command line) : grant select,insert,update,delete on $ingres.remotecmdinview to " alessandro.azzone"\p\g grant select,insert,update,delete on $ingres.remotecmdoutview to " alessandro.azzone"\p\g grant select,insert,update,delete on $ingres.remotecmdview to " alessandro.azzone"\p\g grant execute on procedure $ingres.launchremotecmd to "alessandro.azzone "\p\g grant execute on procedure $ingres.sendrmcmdinput to "alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdcmdend to " alessandro.azzone "\p\g grant register, raise on dbevent $ingres.rmcmdnewcmd to " alessandro.azzone "\p\g grant register, raise on dbevent $ingres.rmcmdnewinputline to " alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdnewoutputline to " alessandro.azzone"\p\g grant register, raise on dbevent $ingres.rmcmdstp to "alessandro.azzone"\p\g Note for Ingres developpers (my favorite community :-) And to correct this bug in rmcmdgen the solution is perhap's to enclose systematicly username by double quote Hope this solve your issue ;-) Jean-Pierre 2006/10/23, Alessandro Azzone <aleazzone (AT) hotmail (DOT) com>: Hi Jean, I didn't notice any complain during the installation. Below the command output: C:\Documents and Settings\alessandro.azzone>echo select dbmsinfo('username')\g | sql iidbdb INGRES TERMINAL MONITOR Copyright 2005 Ingres Corporation Ingres 2006 Microsoft Windows 32-bit Version II 9.0.4 (int.w32/105) login Mon Oct 23 13:18:01 2006 continue * Executing . . . +----------------------------------------------------------------+ |col1 | +----------------------------------------------------------------+ |alessandro.azzone | +----------------------------------------------------------------+ (1 row) * Ingres 2006 Version II 9.0.4 (int.w32/105) logout Mon Oct 23 13:18:01 2006 tnx Alessandro C:\Documents and Settings\alessandro.azzone C:\Documents and Settings\alessandro.azzone From: "Jean-Pierre Zuate" <jpzuate (AT) gmail (DOT) com To: "aleazzone (AT) hotmail (DOT) com" <aleazzone (AT) hotmail (DOT) com Subject: Re: [Info-ingres] Re: Remote Command Does not Start Date: Mon, 23 Oct 2006 14:11:00 +0200 Hello, It depend on some differents things. please first ask to those 2 questions : - when you install ingres (with your username with a dot), did the installation process complain about it ? - when you run the following echo select dbmsinfo('username')\g | sql iidbdb what is the value returned by Ingres ? Thx 23 Oct 2006 03:46:56 -0700, aleazzone (AT) hotmail (DOT) com aleazzone (AT) hotmail (DOT) com : Hi Jean-Pierre, thanks for your answer, it is enlightening. Is there any way in Windows to separate the Ingred account from the OS one? The problem is I do not have the administrator permission on my laptop and it seems I am in a cul de sac, as I can't see any of the remote command tables, views or procedures Rgds Alessandro Jean-Pierre Zuate wrote: Hello Allessandro, Don't you have a dot (.) in your username ? Not sure Ingres like that very much ... 1/ Your first error (E_RE0006) come from a lake of grant 2/ You have a lake of grant because rmcmdgen could not give it to your user After a short look in source code (rmcmdgen.sc) : - No grant mentionned in the source code (array affectation) have dot. - The grant is modified by adding the user name (probably something like %USERNAME% on W2K) - Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt) - and the message "Create rmcmd objects failed" is provided if return code is not OK Hope this help, Jean-Pierre ZUATE La Fage Conseil +33(0)6 1140 1109 23 Oct 2006 01:24:04 -0700, aleazzone (AT) hotmail (DOT) com aleazzone (AT) hotmail (DOT) com : Hi, I just installed INGRES on my window laptop but I noticed the Remote Command does not start and display the error: E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL error code was -30100. I tried the commands: "rmcmdrmv" followed by "rmcmdgen" But on the second one I get the following error: Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The correct syntax is: GRAN I really don't know how to proceed , please help. Many Thanks Alessandro _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres ------=_Part_54401_27296939.1161596406125 Content-Type: text/html; charset=ISO-8859-1 X-Google-AttachSize: 1998 Hello Allessandro,<br><br>Don't you have a dot (.) in your username ? Not sure Ingres like that very much ...<br><br>1/ Your first error (E_RE0006) come from a lake of grant<br>2/ You have a lake of grant because rmcmdgen could not give it to your user br><br>After a short look in source code (<a href="http://rmcmdgen.sc" rmcmdgen.sc</a>) :<br>- No grant mentionned in the source code (array affectation) have dot.<br>- The grant is modified by adding the user name (probably something like %USERNAME% on W2K) br>- Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt)<br>- and the message "Create rmcmd objects failed" is provided if return code is not OK<br><br>Hope this help,<br>Jean-Pierre ZUATE<br>La Fage Conseil br>+33(0)6 1140 1109<br><br><div><span class="gmail_quote">23 Oct 2006 01:24:04 -0700, <a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a> <<a href="mailto:aleazzone (AT) hotmail (DOT) com" aleazzone (AT) hotmail (DOT) com</a :</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi, I just installed INGRES on my window laptop but I noticed the<br>Remote Command does not start and display the error: br><br>E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL<br>error code was -30100.<br><br> I tried the commands: "rmcmdrmv" followed by "rmcmdgen"<br><br>But on the second one I get the following error: br><br>Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The<br>correct syntax is: GRAN<br><br>I really don't know how to proceed , please help.<br><br>Many Thanks<br><br>Alessandro<br><br>__________________ _____________________________ br>Info-ingres mailing list<br><a href="mailto: Info-ingres (AT) cariboulake (DOT) c...lake (DOT) com</a><br><a href=" http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres" http://mailman.cariboulake.com/mailm...py/info-ingres /a><br></blockquote></div ------=_Part_54401_27296939.1161596406125-- _______________________________________________ Info-ingres mailing list Info-ingres (AT) cariboulake (DOT) com http://mailman.cariboulake.com/mailm...py/info-ingres -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 __________________________________________________ _______________ MSN Hotmail, la casella di posta elettronica da 250 MB! http://join.msn.com/hotmail/features -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 __________________________________________________ _______________ Windows Live Messenger:E' arrivato.Scopri la nuova versione! http://get.live.com/messenger/features -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 |
Condivi le tue emozioni ! http://discoverspaces.live.com/?loc=it-IT
#6
| |||
| |||
|
|
« Previous Thread
|
Next Thread »
| Thread Tools | Search this Thread |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.