Re: [fw-general] URL issue with multiple customers sharing the same application

Thank you Ryan for your answer. I found the right solution to this problem: $router->setGlobalParam('account', $this->_account); This way, the "account" parameter is added to every URL built. -- Guillaume Le 27/12/09 03:50, ryan.horn a écrit : Can you give an example of the URL

Re: [fw-general] URL issue with multiple customers sharing the same application

Can you give an example of the URL structure you are using to access your page, what you are passing to the url helper and what the helper is returning? Seems to work fine for me with the route definition you provided. Guillaume ORIOL wrote: > > Working on an application that is the same for m

Re: [fw-general] URL issue with multiple customers sharing the same application

I use a supervisor database to store db credentials to customer databases. Here is the schematic process (done in a plugin): - determine which account was used, either from subdomain (account1.webapp.domain.com/... ) or from the URL pa

Re: [fw-general] URL issue with multiple customers sharing the same application

Hi Guillaume, How do you handle passwords for your customer databases? do you have a look up list - be it a file, database .. ? For example if a sub-domain hits the server, how are db credentials gatherd/defined? We can determine username from subdomain part but what about passwords? I just ask a

Re: [fw-general] URL issue with multiple customers sharing the same application

The original question was fogotten in our discussion. Does anyone have a suggestion for building URL in that situation? Thanks for the replies Jake and Guillaume, they have made me think as I am currently adding somthing of the same to an app Im Implementing, I was thinking of having a one d

Re: [fw-general] URL issue with multiple customers sharing the same application

Thanks for the replies Jake and Guillaume, they have made me think as I am currently adding somthing of the same to an app Im Implementing, I was thinking of having a one database as I didn't want to optimise prematurley but the benefits mentioned here especialy in terms of scalability and

Re: [fw-general] URL issue with multiple customers sharing the same application

I do agree with Jake. It is not a big deal to manage 50 database if you have a good back-office to do it. On Mon, Dec 21, 2009 at 11:10 AM, Daniel Latter > wrote: OK thanks for the replies, I understand your reasons but this too seems unmanageable, say if

Re: [fw-general] URL issue with multiple customers sharing the same application

On Mon, Dec 21, 2009 at 11:10 AM, Daniel Latter wrote: > OK thanks for the replies, I understand your reasons but this too seems > unmanageable, say if you have 50 customers, thats 50 databases!!? or am I > missing somthing? > This isn't so terrible, sandboxing accounts to their own databases mak

Re: [fw-general] URL issue with multiple customers sharing the same application

OK thanks for the replies, I understand your reasons but this too seems unmanageable, say if you have 50 customers, thats 50 databases!!? or am I missing somthing? Thanks again. Dan 2009/12/21 Guillaume ORIOL > I had two reasons in mind: > - security (the db user has rights only on its da

Re: [fw-general] URL issue with multiple customers sharing the same application

I had two reasons in mind: - security (the db user has rights only on its database) - simplicity (no need to prefix table names or to add a customer column in every table PK) -- Guillaume Le 21/12/09 16:40, Daniel Latter a écrit : Thanks for the reply, What was your main reason for using sep

Re: [fw-general] URL issue with multiple customers sharing the same application

Thanks for the reply, What was your main reason for using separate databases instead of one single database? Dan 2009/12/21 Guillaume ORIOL > Yes, I have exactly one database per customer and one more for supervision > purpose (where access to customer databases are defined). > > Le 21/12/

Re: [fw-general] URL issue with multiple customers sharing the same application

Yes, I have exactly one database per customer and one more for supervision purpose (where access to customer databases are defined). Le 21/12/09 16:08, Daniel Latter a écrit : Hi, I have a situation very similar to yours, although I am not sure about the answer to your question, I have a qu

Re: [fw-general] URL issue with multiple customers sharing the same application

Hi, I have a situation very similar to yours, although I am not sure about the answer to your question, I have a quesiton for you: when you say you have several databases, what do you mean? do you mean one per customer/application? Thanks Dan 2009/12/21 Guillaume ORIOL > Working on an appl

[fw-general] URL issue with multiple customers sharing the same application

Working on an application that is the same for multiple customers, I had to face a design option. I wanted to avoid installing the application as many times as we had customers (for maintenance reasons). Therefore I chose to have a unique code installation but several databases. Each customer wo