Forums: Discussions for entrepreneurs and small business.

Not familiar with Freehostia but had a quick look at their site. They support php and mysql database so it should be okay. It sounds like your install isn`t configured correctly.  When you extracted drupal, there are a few text files "install.txt" and "install.mysql.txt" that you need to refer to to tell you how to install drupal and setup the database to connect to. There`s also a database script (in the /database folder) that you also have to run after you`ve created the database. This will load the default values to get the default drupal running.

As for Bluehost, its pretty good. Haven`t had any issues with them so far. The drupal site that we just implemented is hosted on it right now.

The one WYSIWYG editor for drupal that I have used is "TinyMCE". It can be found here http://drupal.org/project/Modules

You`ll also see lots of other modules that you can add on to your site. But of course you need to get the thing running first before you start to add modules! :)






-------------------------

Brandon Eng, Owner, Lead Studios

Play sports? Find other Toronto players @ www.sportaholik.com

I`m not sure what I did wrong though..

• I extracted the drupal.tr.gz into /www/mydomain.com/drupal
• I went to the MySQLDatabase and created an account on PhpMyAdmin
• The database extracted into my account in PhpMyAdmin
• I configured the settings.php in /sites/default

Must be in the values I put in the settings.php `cause I wasn`t sure about the username:password@localhost/databasename part.

Is the username and password there the same one I use to log into my admin account or is it the one I use to log into PhpMyAdmin? Also about that local host thing, how do I find out what my local host is?

Oh yeah, and does the fact that I have an index.html in my root folder have any effect on this? Is drupal supposed to be in the /www/mydomain.com/ or is it okay that I put it in the /www/mydomain.com/drupal/?

I suck hahahaha!


-------------------------

Dimitri Roleda, dimitriroleda@gmail.com

You are on the right track. No worries though, its not the easiest when just starting out.

The settings.php file is key:

username:password@localhost/databasename

When you created the drupal database, I assume you also created a mysql user that has permissions to access the database. That is the username:password you need to put. Leave localhost as is.

Also in the settings.php file, look for a line "base_url" or something like that. You need to uncomment it and put the path to your drupal installation since you didn`t put it in your root. So something like http://www.website.com/drupal

Its even more difficult sometimes when trying on a hosting server since you don`t have the same control as you would if you were working on your own computer. 

What I do is actually have websites running on my computer, fully functional by  creating everything locally, that is run my own web server and database. That way I can edit the files on the fly and test things without having to work off a hosting server. Maybe I`ll start a thread on that later.




-------------------------

Brandon Eng, Owner, Lead Studios

Play sports? Find other Toronto players @ www.sportaholik.com

That`s what I did but there`s this part that just keeps on bugging me:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
     ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
     ON databasename.*
     TO `username`@`localhost` IDENTIFIED BY `password`;

Every time I do it I get Error #1044..It keeps on sayng that I don`t have permission blahblahblah. I`m pretty sure the info I put in were all correct but it keeps on saying that I don`t have permission.

-------------------------

Dimitri Roleda, dimitriroleda@gmail.com

I`d be suprised if this worked. Every hosting company I`ve ever used requires you to create MySQL users using your admin control panel. Try looking in the control panel (probably the same place you created the database) for somewhere to create a user and associate it with the database.


-------------------------

Blog - http://www.buggy.id.au/

http://drupal.org/project/tinymce


-------------------------

Blog - http://www.buggy.id.au/

It`s weird actually.

I log in with the same username and password that I type into the TO `username`@`localhost` IDENTIFIED BY `password` but it always comes out as error #1044 where it says I`m not authorized.

How do you guys set up a MySQL database? Maybe I`m doing something wrong or something..


-------------------------

Dimitri Roleda, dimitriroleda@gmail.com

The usename/password you use to log in (i assume to phpmyadmin) shouldn`t be used as the username/password for the drupal database. That one is the "root" password to access phpmyadmin to manage your mysql dbs and for security, should only be used for such.

You may have already done this but when you are in phpmyadmin, you need to create a new database. Should be a button/menu item to do it. Database name is up to you.

Once that is done, create a new user and set password. When you create the user you will then specify what database they are assigned to and what permissions they have. Here is where you assign the new user to your drupal database and assign the appropriate permissions (SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES)

Once that is done, you then need to run the sql script from drupal to load the default values into the new drupal database you just created. When you select the new drupal database you created to manage, there is an IMPORT button or something like that. Use that to import the mysql data text file.

Change the settings in the settings.php file to match what you have done....and now hopefully it will all work....



-------------------------

Brandon Eng, Owner, Lead Studios

Play sports? Find other Toronto players @ www.sportaholik.com

All right, will do 

Thanks for all the help! I`ll post as soon as I encounter any problems..


-------------------------

Dimitri Roleda, dimitriroleda@gmail.com

This is something you might want to check out. You can create your own website and have it hosted for a very low price.

http://www.freedom.ws/mbrashad/show_dvd