+1 to that! -Jim
On Friday, December 5, 2014 9:22:22 AM UTC-6, Ramos wrote: > > Hello Omi, > > Have you ever tried to install web2py inside iseries using PASE subsistem ? > > Ruby folks made powerruby, we need power2py? > > Regards > > > > 2011-09-07 19:39 GMT+01:00 Omi Chiba <[email protected] <javascript:>>: > >> Antonio, >> >> You can contact me personally to solve the issue because it's really a >> setting on your AS400. Are you AS400 guy ? If so, you can send me the >> screen shot for the following. >> >> WRKOBJ QSYS/MYLIB >> Opt 2=Edit authority >> >> By default, *public shulld be *CHANGE and authorization list = *NONE. >> >> If you're secofr, you can also connect with QSECOFR. >> >> >> >> On Sep 7, 9:18 am, Jim Steil <[email protected]> wrote: >> > No journaling is required if you change the commit mode to Commit >> > Immediate (*NONE) as shown in the blog post. >> > >> > -Jim >> > >> > On 9/7/2011 9:06 AM, DenesL wrote: >> > >> > >> > >> > >> > >> > >> > >> > > If I remember correctly from my tests a couple of years ago, the AS400 >> > > for some reason wants to journal the files (tables) created thru ODBC. >> > > No journal is required when reading from existing tables. >> > >> > > Looking at the files in my WEB2PY library I see a data area specifying >> > > the name of the journal: >> > >> > > Data area . . . . . . . : QDFTJRN >> > > Library . . . . . . . : WEB2PY >> > > Type . . . . . . . . . : *CHAR >> > > Length . . . . . . . . : 100 >> > > Text . . . . . . . . . : >> > >> > > Value >> > > Offset *...+....1....+....2....+....3....+....4....+....5 >> > > 0 'WEB2PY QDFTJRN *FILE ' >> > > 50 ' ' >> > >> > > and the journal and journal receiver files: >> > >> > > Object Type Library >> > > QDFTJRNRCV *JRNRCV WEB2PY >> > > QSQJRNRCV *JRNRCV WEB2PY >> > > QDFTJRN *JRN WEB2PY >> > > QSQJRN *JRN WEB2PY >> > > QDFTJRN *DTAARA WEB2PY >> > >> > > Obviously your user has to be authorized to use these objects. >> > > Hope it helps, >> > > Denes. >> > >> > > On Sep 7, 7:07 am, Ant nio Ramos<[email protected]> wrote: >> > >> ProgrammingError: ('42000', '[42000] [IBM][Controlador ODBC do >> iSeries >> > >> Access][DB2 UDB]SQL0551 - Not authorized to object AUTH_USER in >> MYLIB type >> > >> *FILE. (-551) (SQLExecDirectW)') >> > >> > >> 2011/9/7 Omi Chiba<[email protected]> >> > >> > >>>> How about using auth with as400 users. Is it possible? >> > >>> I'm not sure about it since I'm still new for web2py but your >> problem >> > >>> should be related to the permission just like your error says. >> > >>> My library is like... >> > >>> Object secured by authorization list . . . . . . . . . . . . >> > >>> *NONE >> > >>> Object >> > >>> User Group >> > >>> Authority >> > >>> *PUBLIC >> > >>> *CHANGE >> > >>> QSECOFR >> > >>> *ALL >> > >>> and my user has... >> > >>> Special authority . . . . . . . SPCAUT *ALLOBJ >> > >>> Maybe create new library and connect with the most high authority >> user >> > >>> might help. >> > >>> On Sep 6, 4:49 pm, Ant nio Ramos<[email protected]> wrote: >> > >>>> Ok, seems to get someting now. >> > >>>> I have to change in AS400 the permissions to allow my username to >> create >> > >>> a >> > >>>> table >> > >>>> ProgrammingError: ('42000', '[42000] [IBM][Controlador ODBC do >> iSeries >> > >>>> Access][DB2 UDB]SQL0551 - Not authorized to object **** in *N type >> > >>> *USRPRF. >> > >>>> (-551) (SQLExecDirectW)') >> > >>>> How about using auth with as400 users. Is it possible? >> > >>>> Thank you >> > >>>> Em 6 de setembro de 2011 22:07, Ant nio Ramos<[email protected] >> > >>>> escreveu: >> > >>>>> I tried the DAL Example and i could not connect to my AS400 >> > >>>>> does the DAL only works with db2 on windows or linux? >> > >>>>> i have my db2 in a OS400 machine >> > >>>>> Thank you >> > >>>>> Ant nio >> > >>>>> Em 6 de setembro de 2011 21:56, Ant nio Ramos< >> [email protected] >> > >>>> escreveu: >> > >>>>> Great >> > >>>>>> i tested the example from the python shell and i connected to my >> > >>> company >> > >>>>>> AS400 with success. >> > >>>>>> FANTASTIC!!!! >> > >>>>>> Tomorrow i will kick the ass of the RPG guy. >> > >>>>>> :) >> > >>>>>> 2011/9/6 Massimo Di Pierro<[email protected]> >> > >>> >> http://ochiba77.blogspot.com/2011/09/how-to-connect-db2-with-python-p... >> > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
