Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » Problems installing database on host

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

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

Page: 1 2
Go to End
Author Topic: 2539 Views
  • mschiefmaker
    Avatar
    Community Member
    187 Posts

    Problems installing database on host Link to this post

    Hi
    I am trying to install SilverStripe on a host provider but am striking problems with the database (see attached screenshot). When I create the database the install programme says it can't see it so I deleted it but then the installer says I don't have the permission to create a database even though that user had just been used to create one via the hosting interface. I am confused, I have logged a ticket with the host provider but I am wondering if I am missing something on the SS side

    Can you help?
    MM

  • Willr
    Avatar
    Forum Moderator
    5464 Posts

    Re: Problems installing database on host Link to this post

    That error as it says in the bottom corner - You have not got a database called 'SS_mysite' and your user can't create the database. So you will have to a) Use a different user which has CREATE rights b) Give your user CREATE rights so that SilverStripe can create the database for you or c) Use an existing database or create the database.

  • mschiefmaker
    Avatar
    Community Member
    187 Posts

    Re: Problems installing database on host Link to this post

    Hi Willr

    Thanks for the quick response.

    I am trying to get the host provider to hep me sort the permissions, for some reason I don't have access to this. I am using the database administrator shouldn't tis work?

    In the meantime I am wondering if I can get around the problem. The database has a prefix newzealandboutiq_-_ which the install script seems to change to newzealandboutiq__ (see attached ss)when I click Recheck Requirements which I am guessing is why it says the database doesn't exist when it actually does. Is there anyway to stop this?

    Thaks

    Catherine

  • LoZzA
    Avatar
    Community Member
    11 Posts

    Re: Problems installing database on host Link to this post

    I am having exactly the same problem with the '_-_' being turned into '___'. My hosting is with FreeParking.

  • mschiefmaker
    Avatar
    Community Member
    187 Posts

    Re: Problems installing database on host Link to this post

    The host has come back to me and said they don't think there is anything wrong with the permissions and the problem is being caused by the missing dash. Can I log tis as a bug and how do I do that?

    Cheers

    Catherine

  • mschiefmaker
    Avatar
    Community Member
    187 Posts

    Re: Problems installing database on host Link to this post

    Snap on the Freeparking thing. Have asked if the dash can be removed from the prefix as a work around.

    Catherine

  • LoZzA
    Avatar
    Community Member
    11 Posts

    Re: Problems installing database on host Link to this post

    I've just fixed it. If you edit your install.php file and change the name of your database there it recognises the '_-_'. You can even put your username and password in there to to make it quicker!

    Apparently you can't change the prefix, which is a bit of a bugger!

  • mschiefmaker
    Avatar
    Community Member
    187 Posts

    Re: Problems installing database on host Link to this post

    Hey LoZza

    Thank you very much you have made my Friday morning

    MM

    2539 Views
Page: 1 2
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.