. .
pragmaMx Support Forum 09 Februar 2012, 11:39:47 *
Willkommen Gast. Bitte einloggen oder registrieren.


Einloggen mit Benutzername und Passwort
News:
Brauchen Sie Hilfe? Bitte nutzen Sie unsere Suchfunktion bevor Sie Beiträge oder Fragen ins Board schreiben! Viele Fragen wurden bereits gestellt und beantwortet. Danke!
 
Übersicht Hilfe Forenregeln / Boardrules
 
Suche
Seiten: [1]   Nach unten
Drucken
Autor Thema: multiple db user connection  (Gelesen 1818 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
ahura
öfter hier
**
Offline Offline

Geschlecht: Männlich
Beiträge: 62


WWW
« am: 27 Januar 2010, 11:44:08 »

hi all.

how to connect mysql with one db and two dbuser for pragmamx.

sometimes my site give 500 internal server error. i asked my host server. they said me if you connect with two or more db user connection it will be fixed.

but how to?
Gespeichert
martin b
Gast
« Antworten #1 am: 27 Januar 2010, 22:10:57 »

hi ahura

as i've understood it well, you will use one database for two websites!? it is possible under some cirumstances. you need a webspace, where you can host multiple domains, or you can rent a server to host multiple domains. the other question is: can you trust the other user? the database is the most important thing of a website. both users need the same password and username to access the databese! think twice before you share it.

best regards
martin b
Gespeichert
ahura
öfter hier
**
Offline Offline

Geschlecht: Männlich
Beiträge: 62


WWW
« Antworten #2 am: 27 Januar 2010, 23:39:44 »

hi martin b.

no not for 2 websites. i will add 2 db user for 1 db. on my server i can add more db user (with different pass) for a db.

on my host plan there is a limit for db user connection. when 8 website user request for sql at the moment the db lock itself so it gives internal server error.

they send me this mail.

Zitat

We would like to inform you that your database connection gets locked whenever your site reached simultaneous connection limit of 8 users. To resolve this issue, we suggest that you add more admin users to your database and edit your script to connect to multiple users simultaneously rather than connecting to one database user only.
Gespeichert
martin b
Gast
« Antworten #3 am: 28 Januar 2010, 10:51:24 »

hi again

we can't help you in this case, because it's a thing between yourself and the hoster. normaly hosters are helpful and tell you how to change the setting, or the hoster will do it for you. if your host plan is to small and the hoster don't offer something for your needs, you have to change the hoster.

regards
martin b
Gespeichert
Seiten: [1]   Nach oben
Drucken
 
Gehe zu:  

Powered by SMF 1.1.16 | SMF © 2011, Simple Machines
design by hENNE, layout based on YAML