Topic: Seti@home phpMySetiSTats

[Eric]

i'm trying to setup the phpMySetiStats for my seti@home.  I have everything correct..i think...except for the $dbuser and $dbpass.

I don't know which user and password it wants.  I've tried the ones for my server, but I believe it's asking for the one from mysql.  

I just don't know...I'd appreciate any input from the awesome people out there....

And PLEASE don't tell me to RTFM...  Here's what the manual says:

#Edit config.php to fit your needs
[root@server seti]# pico config.php

That's it, pretty lame, huh?

[Jon Blakely]

Try using 'root' as the username and get the root mysql password from

/root/.my.cnf

The password is around 75 characters long. Make sure you copy it all.

Jon

[Charlie Brady]

Jon Blakely wrote:

> Try using 'root' as the username

No, that's not a good idea. Seti only needs access to its own table, so you should create a seti user with its own password and table, and grant that user access to that table.

Charlie

[Eric]

I've created the user, how do I give that user rights to the phpMySetiStats table?

[miked]

Did you ever work out how to fix this? I have the same problem. (give setiuser rights to the table)

TIA,
miked

[Jan]

Hi,

If you've created the user I assume you've done that for mysql? If not you can use the example in the Post Nuke Howto on e-smith.org. If You have created a mysql user than you're looking for this:

# mysql -u root

mysql> grant all on seti.* to setiuser@localhost identified by 'password_for_seti;

Where seti.* is the name of your mysql-dbase  and setiuser the user you created. The password you can set to what you like.

Anyway, you should check out the howto on PostNuke0.7 on http://www.e-smith.org/docs/howto/contrib/postnuke-0.7-howto.html . It may give you the pointers you need.

Hope this helps

regards,

Jan