Register forum user name Search FAQ

Gammon Forum

Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the password reset link.

Due to spam on this forum, all posts now need moderator approval.

 Entire forum ➜ Forum software ➜ Installation ➜ Root access to mysql?
Root access to mysql?

It is now over 60 days since the last post. This thread is closed.     Refresh page

Posted by Nick Cash   USA  (626 posts)  Bio
Date Mon 30 Jun 2003 01:06 AM (UTC)
Message
Alright, I was trying to set up the forum, and just a little ways into it when I was using mysql to create the forum database (eg. create database forum;) it hit me with this error:

ERROR 1044: Access denied for user: 'odis@localhost' to database 'forum'

Reading through the install file I had already seen something about needing root access to mysql, so I just decided to try anyway.

So, do I need my system admin to do this for me? Or can I bypass that in someway?

Thanks!
~Nick Cash
http://www.nick-cash.com
Top
Posted by Loki   (44 posts)  Bio
Date Reply #1 on Mon 30 Jun 2003 01:14 AM (UTC)
Message
You will need to get your system Admin's assistance,
but it will be easy enough for the admin to set
Grant All permissions to 'odis@localhost' for
for that database only.
-LºKi_
Founder
Endless Dreams
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #2 on Mon 30 Jun 2003 03:28 AM (UTC)
Message
There are two roots here - you don't need system (Unix) root access, you need mySQL root access. It depends how mySQL was installed. If you installed it yourself you may well have a blank root password, you could type:

mysql -u root

If not, and if you don't control the mysql root account then you need whoever does to grant you rights to that database. From memory they need to type something like:

grant all on forum.* to odis@localhost identified by "yourpassword"

They may need to actually create the database for you too. (ie. create database forum)
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Nick Cash   USA  (626 posts)  Bio
Date Reply #3 on Mon 30 Jun 2003 07:13 AM (UTC)
Message
Alright, after I got my database setup everything went without a hitch! Horray! Except for one thing, when I look at my forum the little pictures don't show up on my computer. Since I'm running this off of here, I know I must have something wrong since I see the pictures on here and on Kris' forums. What shall I do?

Take a look, perhaps its just my comp:
http://ew.xidus.net/forum/

Thanks for all the help.
~Nick Cash
http://www.nick-cash.com
Top
Posted by Nick Cash   USA  (626 posts)  Bio
Date Reply #4 on Mon 30 Jun 2003 10:24 AM (UTC)
Message
Never mind, I got it. Turns out I had to chmod the gif files to 755. Anyways, works fine now.

Check it out if you want:
http://ew.xidus.net/forum

But its nothing you haven't seen (considering it looks almost exactly the same as this..).

Thanks for the help.
~Nick Cash
http://www.nick-cash.com
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #5 on Mon 30 Jun 2003 09:19 PM (UTC)
Message
Glad it's working for you. BTW - you don't need to be a moderator as well as administrator, administrators can do all a moderator can, and more.

You can change the look and feel somewhat by editing the control entries for the standard header and footer, and in particular by changing the GIFs (eg. do your own with different colour buttons, and change the background GIF to something else). That way it doesn't look exactly like this one.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Nick Cash   USA  (626 posts)  Bio
Date Reply #6 on Mon 30 Jun 2003 10:59 PM (UTC)
Message
Alright, its all working, except some of the pictures still won't show up (refresh, reply_to_subject, and new_subject, as well as bio) even if I chmod them to 755. Should I chmod them to something else?

I will be changing it, but right now (with my game opening on the 1st) I just had to stick it up and modify it a bit. I'll change it later when all my work/troubles die down.
~Nick Cash
http://www.nick-cash.com
Top
Posted by Nick Cash   USA  (626 posts)  Bio
Date Reply #7 on Sat 05 Jul 2003 10:26 PM (UTC)
Message
Any suggestions?
~Nick Cash
http://www.nick-cash.com
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #8 on Sat 05 Jul 2003 11:11 PM (UTC)
Message
The one that seems to be working - the background GIF is at:

http://ew.xidus.net/forum/images/background.gif

One that isn't is at:

/images/refresh.gif

Are you sure you have the images directory set up correctly?


One thing you might need to do is change the httpd.conf file to alias the images directory, like this:

Alias /images/ "/var/www/forum/images/"

Alternatively you could change the PHP source to point to a different spot.

Or, you could make a soft link to create a link from where the images should be to where they are.

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Nick Cash   USA  (626 posts)  Bio
Date Reply #9 on Sun 06 Jul 2003 12:22 AM (UTC)
Message
I don't have root access to anything, or w/e it is, so I'm not sure exactly where it is looking for the images, but as for soft links, where do I need to go to set them up, because otherwise I'll have to do it by hand..
~Nick Cash
http://www.nick-cash.com
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #10 on Sun 06 Jul 2003 01:17 AM (UTC)

Amended on Sun 06 Jul 2003 01:18 AM (UTC) by Nick Gammon

Message
It depends how your web server is set up, but currently to resolve /images/blah.gif it needs to find the image directory in the HTTP "root" directory.

You clearly have a "forum" directory somewhere because I can see that you get the background gif from the subdirectory "images" of it. You need an "images" directory at the same level as the forum directory, and the images in it. Then it should work.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Nick Cash   USA  (626 posts)  Bio
Date Reply #11 on Sun 06 Jul 2003 10:46 PM (UTC)
Message
The forum directory is located at:
/home/odis/public_html/forum

The images directory is at:
/home/odis/public_html/forum/images

Shouldn't that work if it specifies the image src as /images?
~Nick Cash
http://www.nick-cash.com
Top
Posted by Nick Cash   USA  (626 posts)  Bio
Date Reply #12 on Mon 07 Jul 2003 12:07 AM (UTC)
Message
Alright, once again I ask the question before I fiddle with it myself. I just needed to stick the images directory in public_html since /images refers to the top directory for my web stuff. Anyways, its working, I'll work on customizing it once I get my mud squared away. Anyways, thanks.
~Nick Cash
http://www.nick-cash.com
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #13 on Mon 07 Jul 2003 07:04 AM (UTC)
Message
Yes, I think you've got it. The images directory was a subdirectory of forum, but it was expected to be a root directory (from the HTML root level).
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

40,771 views.

It is now over 60 days since the last post. This thread is closed.     Refresh page

Go to topic:           Search the forum

[Go to top] top

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.

Home