Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive /

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Used recommended web host SERVAGE but cant setup MySQL


Reply


6 Posts   2889 Views

Avatar
dille4

Community Member, 14 Posts

24 January 2008 at 2:20pm

Edited: 24/01/2008 3:37pm

I have chosen SERVAGE as a web host because it was recommended by the Silverstripe team. After paying my domain and copying all files to the /www folder I was ready to setup MySQL. Attached picture shows the database I have created within SERVAGE. The only thing I can set is the username and password. In my case username: "peadmin". Automatically MySQL creates a database with the same name. Hmm, I thought, that's a bit odd. On another web host I could create a database name and an admin seperately.
Everything seemed alright and I could even create a test table. So I could access "pereport" with phpMyAdmin which is preinstalled on SERVAGE.
The next step was to install Silverstripe. The attached picture shows the right settings but SERVAGE doesn't know "peadmin" anymore.

Has someone experienced the same problem and what is the solution. Please help!

Avatar
DaveP

Community Member, 48 Posts

24 January 2008 at 2:51pm

Your image is trying to talk to database called peadmin, but in the details you discuss you are referring to a database called pereport ?

I'd double check all your settings...

HTH - Dave Porter

Avatar
dille4

Community Member, 14 Posts

24 January 2008 at 3:29pm

Edited: 24/01/2008 3:35pm

Sorry my mistake ... There is only ONE database "peadmin" (see attachment)

So I meant to say:

So I could access "peadmin" with phpMyAdmin which is preinstalled on SERVAGE.

Comment to the attachment:

Picture above: Screen dump of SERVAGE MySQL setup page
Picture below: Screen dump of Silverstripe install.php

Avatar
DaveP

Community Member, 48 Posts

24 January 2008 at 3:40pm

Is your database name and user name actually the same ?
This would be rather unusual ?

cheers, Dave
@ DJ Software, Dave

Avatar
dille4

Community Member, 14 Posts

24 January 2008 at 3:57pm

Edited: 24/01/2008 3:58pm

Thanks Dave,

That is my problem with SERVAGE. Have a look at the screen shot of the database management. I can only setup "db user name" and "password". The database name will be created automatically with the same name as the "db user name".

This is actually not the problem because I can create tables and everything with phpMyAdmin inside my domain but the Silverstripe installer can't get access to the database.

Cheers,
Tom

Avatar
dille4

Community Member, 14 Posts

24 January 2008 at 4:28pm

Edited: 24/01/2008 4:29pm

PROBLEM SOLVED!!!

Picture "error.jpg" shows the screen shot of my test database on the SERVAGE MySQL database management site. The test server address in my case is:

mysql1058.servage.net (Changes ever time a new db is created)

Of course I have to put this address into the "My SQL Server" field as stated in picture allgood2.jpg.

As I said - all good.

Cheers,
Tom