[web2py] Can 2 apps use 1 database ?
I currently have 2 apps which i would like to share one database. one app is for authentication the other is the main app. When I run the app1 it creates the auth tables along with another table called *base_tags* when I run app2 I get the following error. (the base_tags table in app1 is referenced in app2 - same database). *In App2* type 'exceptions.KeyError' 'base_tags' Traceback (most recent call last): File C:\web2py\gluon\restricted.py, line 205, in restricted exec ccode in environment File C:/web2py/applications/app2/models/db.py http://127.0.0.1:8000/admin/edit/histreet/models/db.py, line 433, in module Field('tag_id', db.base_tags, label='Tag', required=True, notnull=True, writable=False, readable=False) File C:\web2py\gluon\dal.py, line 6343, in __getattr__ return self[key] File C:\web2py\gluon\dal.py, line 6337, in __getitem__ return dict.__getitem__(self, str(key)) KeyError: 'base_tags' db.define_table('places_tags', Field('place_id', db.places, label='Place', required=True, notnull=True, writable=False, readable=False), *line 433*:Field('tag_id', *db.base_tags*, label='Tag', required=True, notnull=True, writable=False, readable=False) ) I am assuming that place_tags isn't seeing db.base_tags (no reference). May be I don't understand DAL. 1. Isn't DAL an interface to the database? 2. If the database exist why wouldn't I be able to access it from another app and reference tables that already exist? 3. Should I assume that unless *base_tags* was defined in app2 I cannot access it?
[web2py] Re: Can 2 apps use 1 database ?
Found this Was having trouble but i guess this -- https://docs.google.com/viewer?a=vq=cache:v2lgkygxA_cJ:www.packtpub.com/sites/default/files/5467OS-Chapter-3-Database-Abstraction-Layer.pdf+hl=enpid=blsrcid=ADGEESgEeuJ9YUV1Lwvy1CubPMg-92-ZM0Rtdvc14RQhuwGE32cSVmd-p35Tw21hW2R4PB9UcXbXLwTVrGRcthvusLvcdRDhnz8B2g-LsohKy64TyJcMX0yuCw5qiypnsPSxUyWHHoPTsig=AHIEtbQPUlFmojpWCTBBJKHdwdR34aZeuw explained it. DRY is broken however, which isn't a good thing as the database gets bigger. On Saturday, July 7, 2012 2:15:58 PM UTC-4, Horus wrote: I currently have 2 apps which i would like to share one database. one app is for authentication the other is the main app. When I run the app1 it creates the auth tables along with another table called *base_tags* when I run app2 I get the following error. (the base_tags table in app1 is referenced in app2 - same database). *In App2* type 'exceptions.KeyError' 'base_tags' Traceback (most recent call last): File C:\web2py\gluon\restricted.py, line 205, in restricted exec ccode in environment File C:/web2py/applications/app2/models/db.py http://127.0.0.1:8000/admin/edit/histreet/models/db.py, line 433, in module Field('tag_id', db.base_tags, label='Tag', required=True, notnull=True, writable=False, readable=False) File C:\web2py\gluon\dal.py, line 6343, in __getattr__ return self[key] File C:\web2py\gluon\dal.py, line 6337, in __getitem__ return dict.__getitem__(self, str(key)) KeyError: 'base_tags' db.define_table('places_tags', Field('place_id', db.places, label='Place', required=True, notnull=True, writable=False, readable=False), *line 433*:Field('tag_id', *db.base_tags*, label='Tag', required=True, notnull=True, writable=False, readable=False) ) I am assuming that place_tags isn't seeing db.base_tags (no reference). May be I don't understand DAL. 1. Isn't DAL an interface to the database? 2. If the database exist why wouldn't I be able to access it from another app and reference tables that already exist? 3. Should I assume that unless *base_tags* was defined in app2 I cannot access it?
[web2py] can CAS provider use a different database to apps?
I desire to have multiple apps. one of them will be a CAS provider My questions are: 1. Can these app have different databases i.e db = DAL('postgres://user:password@localhost:5432/cas', migrate=True), db = DAL('postgres://user:password@localhost:5432/db1', migrate=True), db = DAL('postgres://user:password@localhost:5432/db2', migrate=True) 2. How do I access these database tables across applications? i.e how can app1 access CAS database OR how can app2 database to access app1 database *Auth migration if disabled for all except CAS provider
[web2py] Re: can CAS provider use a different database to apps?
Additionally... I currently have three apps, including CAS server the case server app also contain other tables db.define_table('base_tags', Field('name', 'string', label='Tag', length=64, required=True, notnull=True), format='%(name)s' ) and many more some of these tables in the CAS server db model is accessed by the other apps. db.define_table('places_tags', Field('place_id', db.places, label='Place', required=True, notnull=True, writable=False, readable=False), Field('tag_id', *db.base_tags*, label='Tag', required=True, notnull=True, writable=False, readable=False) ) I am getting this error: Traceback (most recent call last): File C:\web2py\gluon\restricted.py, line 205, in restricted exec ccode in environment File C:/web2py/applications/histreet/models/db.py http://127.0.0.1:8000/admin/default/edit/histreet/models/db.py, line 374, in module Field('tag_id', db.base_tags, label='Tag', required=True, notnull=True, writable=False, readable=False) File C:\web2py\gluon\dal.py, line 6343, in __getattr__ return self[key] File C:\web2py\gluon\dal.py, line 6337, in __getitem__ return dict.__getitem__(self, str(key)) KeyError: 'base_tags' *Does anyone know why this is happening?* ***Migrate is off for auth ** Migrate is on for all other tables (changed it to off got the same error) * On Friday, July 6, 2012 10:02:53 AM UTC-4, Horus wrote: I desire to have multiple apps. one of them will be a CAS provider My questions are: 1. Can these app have different databases i.e db = DAL('postgres://user:password@localhost:5432/cas', migrate=True), db = DAL('postgres://user:password@localhost:5432/db1', migrate=True), db = DAL('postgres://user:password@localhost:5432/db2', migrate=True) 2. How do I access these database tables across applications? i.e how can app1 access CAS database OR how can app2 database to access app1 database *Auth migration if disabled for all except CAS provider
[web2py] Re: can CAS provider use a different database to apps?
Yes I understand CAS is for central auth, so i have let the cas provider be the app that takes care of login, registration, signup, what have you; as it should the tables are being created, so I am assuming that the other apps should be able to access the tables if they exist all in the same database. The underlying question, as I had added. * how does web2py perform multiple database information exchange?* On Friday, July 6, 2012 12:45:16 PM UTC-4, David Marko wrote: Well CAS is for central authentication, not for sharing database tables ... . The error you got simply says that your second app cant see tables from cas provider app.
Re: [web2py] Re: can CAS provider use a different database to apps?
Right viniciusban i agree. i don't want to perform joins across databases explicitly i have never seen that in SQL BUT I can use the user id from the CAS provider to refer to other tables in a database let's say the *CAS* provider has this table called *auth_user* with a field called *id*. let's say I have another app called *APP1* with a table called* user_exams*with a field called *user_id* To make a relationship I can manually get the id from the auth_user table (db.auth_user) and then apply it to the user_exams. the *CAS* provider contains this table db.define_table('base_tags', Field('name', 'string', label='Tag', length=64, required=True, notnull=True), format='%(name)s' ) *APP1* contains a this table db.define_table('places_tags', Field('place_id', db_app1.places, label='Place', required=True, notnull=True, writable=False, readable=False), Field('tag_id', *db_cas.base_tags*, label='Tag', required=True, notnull=True, writable=False, readable=False) ) *Are you saying that Web2Py will not get id from base tags and make that relationship?* On Friday, July 6, 2012 1:56:47 PM UTC-4, viniciusban wrote: Short answer: manually. You cannot connect (join or make a relation) fields among different databases. On 07/06/2012 02:16 PM, Horus wrote: Yes I understand CAS is for central auth, so i have let the cas provider be the app that takes care of login, registration, signup, what have you; as it should the tables are being created, so I am assuming that the other apps should be able to access the tables if they exist all in the same database. The underlying question, as I had added. * how does web2py perform multiple database information exchange?* On Friday, July 6, 2012 12:45:16 PM UTC-4, David Marko wrote: Well CAS is for central authentication, not for sharing database tables ... . The error you got simply says that your second app cant see tables from cas provider app.
Re: [web2py] Re: can CAS provider use a different database to apps?
*I will put all my tables in one app and call it a day!* On Friday, July 6, 2012 2:40:32 PM UTC-4, Horus wrote: Right viniciusban i agree. i don't want to perform joins across databases explicitly i have never seen that in SQL BUT I can use the user id from the CAS provider to refer to other tables in a database let's say the *CAS* provider has this table called *auth_user* with a field called *id*. let's say I have another app called *APP1* with a table called* user_exams * with a field called *user_id* To make a relationship I can manually get the id from the auth_user table (db.auth_user) and then apply it to the user_exams. the *CAS* provider contains this table db.define_table('base_tags', Field('name', 'string', label='Tag', length=64, required=True, notnull=True), format='%(name)s' ) *APP1* contains a this table db.define_table('places_tags', Field('place_id', db_app1.places, label='Place', required=True, notnull=True, writable=False, readable=False), Field('tag_id', *db_cas.base_tags*, label='Tag', required=True, notnull=True, writable=False, readable=False) ) *Are you saying that Web2Py will not get id from base tags and make that relationship?* On Friday, July 6, 2012 1:56:47 PM UTC-4, viniciusban wrote: Short answer: manually. You cannot connect (join or make a relation) fields among different databases. On 07/06/2012 02:16 PM, Horus wrote: Yes I understand CAS is for central auth, so i have let the cas provider be the app that takes care of login, registration, signup, what have you; as it should the tables are being created, so I am assuming that the other apps should be able to access the tables if they exist all in the same database. The underlying question, as I had added. * how does web2py perform multiple database information exchange?* On Friday, July 6, 2012 12:45:16 PM UTC-4, David Marko wrote: Well CAS is for central authentication, not for sharing database tables ... . The error you got simply says that your second app cant see tables from cas provider app.
[web2py] unsigned DAL integer
Is there a way to get unsigned DAL integers ? Is there a way to represent BIGINT using DAL? --
[web2py] Re: unsigned DAL integer
Thanks Anthony. On Monday, June 25, 2012 2:27:19 PM UTC-4, Anthony wrote: Is there a way to get unsigned DAL integers ? I don't think so. If you have created the table outside the DAL, perhaps telling the DAL it's a regular integer field will still work, though. Is there a way to represent BIGINT using DAL? I'm not sure if this is in current stable, but in trunk, you can do: Field('mybigint', 'bigint') And to get the DAL to use bigint's for all ID fields, do: DAL(..., bigint_id=True) Anthony --
[web2py] Adding reference tables to auth
is there a way to add other tables to the current auth table setup ? I am aware of customizing existing tables but not adding tables to the database structure. e.g. Is it VALID to add other tables such at a country table and have auth_user reference this table without breaking web2py internals? How can this be done if possible? --
[web2py] type 'exceptions.ValueError' invalid literal for int() with base 10: ''
I am currently getting this error working with DAL based on db.define_table('base_tags', Field('name', 'string', length=64, required=True, notnull=True), format='%(name)' ) db.define_table('base_timezones', Field('name', 'string', length=64, required=True, notnull=True), Field('offset_time', 'integer', required=True, notnull=True), format='%(name)' ) db.define_table('base_types', Field('name', 'string', length=64, required=True, notnull=True), format='%(name)' ) db.define_table('base_sexes', Field('name', 'string', length=16, required=True, notnull=True), format='%(name)' ) db.define_table('base_countries', Field('name', 'string', length=64, required=True, notnull=True), Field('latitude', 'decimal', required=True, notnull=True), Field('longitude', 'decimal', required=True, notnull=True), format='%(name)s' ) db.define_table('base_states', Field('country_id', db.base_countries), Field('name', 'string', length=64, required=True, notnull=True), Field('latitude', 'decimal', required=True, notnull=True), Field('longitude', 'decimal', required=True, notnull=True), format='%(name)' ) db.define_table('base_cities', Field('state_id', db.base_states), Field('name', 'string', length=64, required=True, notnull=True), Field('latitude', 'decimal', required=True, notnull=True), Field('longitude', 'decimal', required=True, notnull=True), format='%(name)' ) type 'exceptions.ValueError' invalid literal for int() with base 10: '' VERSIONweb2py™(1, 99, 7, datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable') PythonPython 2.7.2: C:\Python27\python.exeTRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. Traceback (most recent call last): File C:\web2py\gluon\restricted.py, line 205, in restricted exec ccode in environment File C:/web2py/applications/histreet/models/db.py http://127.0.0.1:8000/admin/default/edit/histreet/models/db.py, line 79, in module format='%(name)s' File C:\web2py\gluon\dal.py, line 6320, in define_table polymodel=polymodel) File C:\web2py\gluon\dal.py, line 633, in create_table precision, scale = map(int,field.type[8:-1].split(',')) ValueError: invalid literal for int() with base 10: '' ERROR SNAPSHOT [image: help] type 'exceptions.ValueError'(invalid literal for int() with base 10: '') --
[web2py] Re: Adding reference tables to auth
I saw that in the documentation. Can auth_user reference a table I create? so... auth.settings.extra_fields['auth_user']= [ Field('timezone_id',db.base_timezones), Field('type_id',db.base_types), Field('sex_id',db.base_sexes), Field('photo', uploadfolder=os.path.join(request.folder,'uploads/users')), Field('ip', 'string', length=40), Field('agent', 'text'), Field('phone', 'string', length=16), Field('zip', 'string', length=16), Field('city', 'string', length=64), Field('state' 'string', length=64), Field('country', 'string', length=64), Field('latitude', 'decimal', required=True, notnull=True), Field('longitude', 'decimal', required=True, notnull=True) ] where Field('timezone_id',db.base_timezones), Field('type_id',db.base_types), Field('sex_id',db.base_sexes), are other tables On Monday, June 25, 2012 10:33:47 PM UTC-4, Massimo Di Pierro wrote: You can defined your own auth_user before auth.define_table and your own will be used. Or you can use auth.settings.extra_fields['auth_user'] = [Field(...),Field(...),Field(...), ... ] before auth.define_tables() On Monday, 25 June 2012 18:43:33 UTC-5, Horus wrote: is there a way to add other tables to the current auth table setup ? I am aware of customizing existing tables but not adding tables to the database structure. e.g. Is it VALID to add other tables such at a country table and have auth_user reference this table without breaking web2py internals? How can this be done if possible? --
[web2py] Re: type 'exceptions.ValueError' invalid literal for int() with base 10: ''
additional info... Function argument list (self=gluon.dal.PostgreSQLAdapter object, table=Table {'ALL': gluon.dal.SQLALL object at 0x035..., 'id': gluon.dal.Field object at 0x0359A230}, migrate=True, fake_migrate=False, polymodel=None) Code listing 628. 629. 630. 631. 632. 633. 634. 635. 636. 637. foreign_key=referenced + ('(%s)' % id_fieldname), on_delete_action=field.ondelete) elif field.type.startswith('list:reference'): ftype = self.types[field.type[:14]] elif field.type.startswith('decimal'): precision, scale = map(int,field.type[8:-1].split(',')) ftype = self.types[field.type[:7]] % \ dict(precision=precision,scale=scale) elif not field.type in self.types: raise SyntaxError, 'Field: unknown field type: %s for %s' % \ On Monday, June 25, 2012 10:39:38 PM UTC-4, Horus wrote: I am currently getting this error working with DAL based on db.define_table('base_tags', Field('name', 'string', length=64, required=True, notnull=True), format='%(name)' ) db.define_table('base_timezones', Field('name', 'string', length=64, required=True, notnull=True), Field('offset_time', 'integer', required=True, notnull=True), format='%(name)' ) db.define_table('base_types', Field('name', 'string', length=64, required=True, notnull=True), format='%(name)' ) db.define_table('base_sexes', Field('name', 'string', length=16, required=True, notnull=True), format='%(name)' ) db.define_table('base_countries', Field('name', 'string', length=64, required=True, notnull=True), Field('latitude', 'decimal', required=True, notnull=True), Field('longitude', 'decimal', required=True, notnull=True), format='%(name)s' ) db.define_table('base_states', Field('country_id', db.base_countries), Field('name', 'string', length=64, required=True, notnull=True), Field('latitude', 'decimal', required=True, notnull=True), Field('longitude', 'decimal', required=True, notnull=True), format='%(name)' ) db.define_table('base_cities', Field('state_id', db.base_states), Field('name', 'string', length=64, required=True, notnull=True), Field('latitude', 'decimal', required=True, notnull=True), Field('longitude', 'decimal', required=True, notnull=True), format='%(name)' ) type 'exceptions.ValueError' invalid literal for int() with base 10: '' VERSIONweb2py™(1, 99, 7, datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable')PythonPython 2.7.2: C:\Python27\python.exeTRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. Traceback (most recent call last): File C:\web2py\gluon\restricted.py, line 205, in restricted exec ccode in environment File C:/web2py/applications/histreet/models/db.py http://127.0.0.1:8000/admin/default/edit/histreet/models/db.py, line 79, in module format='%(name)s' File C:\web2py\gluon\dal.py, line 6320, in define_table polymodel=polymodel) File C:\web2py\gluon\dal.py, line 633, in create_table precision, scale = map(int,field.type[8:-1].split(',')) ValueError: invalid literal for int() with base 10: '' ERROR SNAPSHOT [image: help] type 'exceptions.ValueError'(invalid literal for int() with base 10: '') --
[web2py] Re: Web2Py + library.zip
I think I got this from the website where is the source located? On Wednesday, May 30, 2012 10:12:22 PM UTC-4, Massimo Di Pierro wrote: You must be using the binary distribution. If you use the source distribution there is a web2py/gluon/ folder. On Wednesday, 30 May 2012 20:00:32 UTC-5, Horus wrote: I have been going through the book and I have been seeing gluon imports. Don't say this is crazy but is Web2Py Pulling from this library.zip, this is where the gluon import are coming from?
[web2py] Re: Web2Py + library.zip
OK, I saw my error. Thank You! On Wednesday, May 30, 2012 10:12:22 PM UTC-4, Massimo Di Pierro wrote: You must be using the binary distribution. If you use the source distribution there is a web2py/gluon/ folder. On Wednesday, 30 May 2012 20:00:32 UTC-5, Horus wrote: I have been going through the book and I have been seeing gluon imports. Don't say this is crazy but is Web2Py Pulling from this library.zip, this is where the gluon import are coming from?
[web2py] replacing router.example.py or routes.example.py
#1 I am assuming that when you replace router.example.py or routes.example.py with router.py or routes.py, respectively, in the base folder they should take over? #2 Can they be added to app folder? if they are added will they take precedence ? I am not finding a lot about this online
[web2py] Web2Py + library.zip
I have been going through the book and I have been seeing gluon imports. Don't say this is crazy but is Web2Py Pulling from this library.zip, this is where the gluon import are coming from?
Re: [web2py] replacing router.example.py or routes.example.py
I removed the .example from routes.example.py to make it routes.py, changed the values but noting happened? On Wednesday, May 30, 2012 9:07:40 PM UTC-4, Jonathan Lundell wrote: On May 30, 2012, at 5:56 PM, Horus wrote: #1 I am assuming that when you replace router.example.py or routes.example.py with router.py or routes.py, respectively, in the base folder they should take over? No, always routes.py. #2 Can they be added to app folder? if they are added will they take precedence ? There needs to be a routes.py at the web2py root, necessary to route to an app. Then there can be additional copies in the app folder that will override for that app.
Re: [web2py] replacing router.example.py or routes.example.py
Additionally, if routes.py is the main file what is the purpose of router.py? On Wednesday, May 30, 2012 9:07:40 PM UTC-4, Jonathan Lundell wrote: On May 30, 2012, at 5:56 PM, Horus wrote: #1 I am assuming that when you replace router.example.py or routes.example.py with router.py or routes.py, respectively, in the base folder they should take over? No, always routes.py. #2 Can they be added to app folder? if they are added will they take precedence ? There needs to be a routes.py at the web2py root, necessary to route to an app. Then there can be additional copies in the app folder that will override for that app.
Re: [web2py] replacing router.example.py or routes.example.py
understood! On Wednesday, May 30, 2012 10:13:43 PM UTC-4, Jonathan Lundell wrote: On May 30, 2012, at 7:08 PM, Horus wrote: I have attached a screenshot to show you what i am seeing. I started python 4 weeks ago and web2py for the last 2 so this is completely new to me. I downloaded a windows copy in this copy there are the two files I mentioned I got it to work after restarting web2py as you had pointed out From what you are saying *router.py* shouldn't be there or is obsolete I am using the system for the first time I was assume it was there for a reason. There are two flavors of the routing logic. The older and more general one is a regex-based pattern-matching router, and it has an example in routes.example.py. There's a newer parametric router that's much easier to configure, but not quite as general. It has an example in router.example.py. You want to pick which router to use, and copy its example file to routes.py. The name router.example.py is misleading in that respect, and there's been some discussion of changing the names, but it's embedded in a lot of documentation, so it has some inertia.
Re: [web2py] Re: Web2Py + OAuth2 Server
I am doing a bit on research on it and looking to wrap my head around it to build a server and client in Web2Py however, there isn't a lot of documentation and some implementations differ from other (I guess that is getting back to what Massimo said). Essentially, I will build a core system and have my apps built around that core (API Centric). I think that will be a little project to start in coming weeks. On Tuesday, May 29, 2012 9:16:44 AM UTC-4, mcm wrote: Yes it is definitely possible. OAuth2.0 was born because OAuth1.0 had all sort of hashing to do on both client and server side. That was to allow for better security, on a clear channel, but failed since OAuth1.0a is deprecated on non TSL channels. They really simplified things in OAuth2.0 so it is much easier to implement, but as Massimo points out the spec is still a bit rough and does just a little more than OpenID. Anyway OAuth2.0 is now adopted by Twitter, Linkedin, Google and Facebook (actually with some little differences, but nothing serious). This means that having OAuth2.0 service is now seen as an important feature. It is something on my TODO list so if you go ahead I can give you some support. mic 2012/5/29 Massimo Di Pierro massimo.dipie...@gmail.com: Theoretically yes. In fact I may even have somewhere a Oauth 1.0 server. The problem is that the Oauth 2.0 specs are very poor. They specify how a the client asks the server if a user is authenticated but do not say anything about what information the server should provide to the client (user name? email?). This means a client written for one server will only work with that server and vice versa. The facebook Oath 2.0 follows its own rules. You can build a client that works with it. You can build a server that mimics them but there is very little in the Oauth 2.0 spects that tells you how to. Moreover your app is unlikely to provide the same services as facebook and therefore clients written for facebook will not work for it. I would stay away from Oauth 2.0 unless you need it as a client to authenticate to third party services. Massimo On Monday, 28 May 2012 20:25:52 UTC-5, Horus wrote: I have seen that web2py supports integration with Facebook + Twitter. What if I want to create my own OAuth2 Server like what is offered by Facebook and Twitter? Is this possible with Web2Py?
[web2py] Re: Wep2Py Database Tables
Having authentication as a core and apps built around it rather than every app having its own admin/CAS On Monday, May 28, 2012 9:38:51 PM UTC-4, Anthony wrote: Not sure what you mean. On Monday, May 28, 2012 9:16:27 PM UTC-4, Horus wrote: ok understood. what do you think about having auth outside of the app? On Sunday, May 27, 2012 9:16:17 PM UTC-4, Anthony wrote: By default, instantiating Auth() automatically makes the application a CAS provider, whether or not you actually use the app as a CAS provider. So, if the app is not used as a provider, that table will simply remain empty. If you want to prevent it from being created in the first place, before calling auth.define_tables(), you can do: auth.settings.cas_domains = None Anthony On Sunday, May 27, 2012 2:13:25 PM UTC-4, Horus wrote: I know a bit about CAS single sign-on, however if each app is giving a different ACL database. Is the concept still being adhered to? I was under the assumption the single sign-on meant one (1) authentication gateway i.e. one auth database used by many applications. On Saturday, May 26, 2012 1:37:09 PM UTC-4, Niphlod wrote: it's for Central Authentication Services http://web2py.com/books/default/chapter/29/9#Central-Authentication-Service Il giorno sabato 26 maggio 2012 18:46:26 UTC+2, Horus ha scritto: In the administrative section of your app there are the usual ACL tables. I realise there is a *acl_cas* table along with these tables. I am curious as to what this tables does?
[web2py] Re: Wep2Py Database Tables
ok understood. what do you think about having auth outside of the app? On Sunday, May 27, 2012 9:16:17 PM UTC-4, Anthony wrote: By default, instantiating Auth() automatically makes the application a CAS provider, whether or not you actually use the app as a CAS provider. So, if the app is not used as a provider, that table will simply remain empty. If you want to prevent it from being created in the first place, before calling auth.define_tables(), you can do: auth.settings.cas_domains = None Anthony On Sunday, May 27, 2012 2:13:25 PM UTC-4, Horus wrote: I know a bit about CAS single sign-on, however if each app is giving a different ACL database. Is the concept still being adhered to? I was under the assumption the single sign-on meant one (1) authentication gateway i.e. one auth database used by many applications. On Saturday, May 26, 2012 1:37:09 PM UTC-4, Niphlod wrote: it's for Central Authentication Services http://web2py.com/books/default/chapter/29/9#Central-Authentication-Service Il giorno sabato 26 maggio 2012 18:46:26 UTC+2, Horus ha scritto: In the administrative section of your app there are the usual ACL tables. I realise there is a *acl_cas* table along with these tables. I am curious as to what this tables does?
[web2py] Web2Py + OAuth2 Server
I have seen that web2py supports integration with Facebook + Twitter. What if I want to create my own OAuth2 Server like what is offered by Facebook and Twitter? Is this possible with Web2Py?
[web2py] Re: Wep2Py Database Tables
I know a bit about CAS single sign-on, however if each app is giving a different ACL database. Is the concept still being adhered to? I was under the assumption the single sign-on meant one (1) authentication gateway i.e. one auth database used by many applications. On Saturday, May 26, 2012 1:37:09 PM UTC-4, Niphlod wrote: it's for Central Authentication Services http://web2py.com/books/default/chapter/29/9#Central-Authentication-Service Il giorno sabato 26 maggio 2012 18:46:26 UTC+2, Horus ha scritto: In the administrative section of your app there are the usual ACL tables. I realise there is a *acl_cas* table along with these tables. I am curious as to what this tables does?
[web2py] Wep2Py Database Tables
In the administrative section of your app there are the usual ACL tables. I realise there is a *acl_cas* table along with these tables. I am curious as to what this tables does?