Geeklog Forums

Hey all, i'm trying to play around with a geeklog in hopes of eventually using to run a local youth theatre website. However before i fool around with it , i have to install it. heres where i get my error.

right after step 2 of 2 i get

"Warning: mysql_connect(): Access denied for user: 'testuser@localhost' (Using password: NO) in c:apachefriendsxamppsystemdatabasesmysql.class.php on line 108
Cannnot connect to DB server"

now this is in the help file , so it says to double check ur paths and ur config file, so i did , again , and again , and again , i even tried switching php versions but with no luck.

here is a sipet of the config file , i cant seem to find the error. ( i took out alot of the comments to try to decrease the size of this post)

$_DB_host = 'localhost'; // host name or IP address of your DB server
$_DB_name = 'geeklog'; // name of your database,
// must exist before running the installer!
$_DB_user = 'testuser'; // MySQL user name
$_DB_pass = ''; // MySQL password


// collisions with other tables that may already exist in your database.
$_DB_table_prefix = 'gl_'; // e.g. 'gl_'

// Note for Windows users: It's safe to use the forward slash '/' instead of
// the backslash '' in paths. Make sure each path starts with a drive letter!

// This should point to the directory where your config.php file resides.
$_CONF['path'] = 'c:/apachefriends/xampp/'; // should end in a slash

// directory (i.e. without the $_CONF['path']) like this:
// $_CONF['path_html'] = '/path/to/your/public_html/';
$_CONF['path_html'] = 'c:/apachefriends/xampp/htdocs/';


// index.php file resides (no trailing slash).
$_CONF['site_url'] = 'http://localhost/';

// problems accessing Geeklog's admin menu.
$_CONF['site_admin_url'] = $_CONF['site_url'] . '/admin';

// This is the return address for all email sent by Geeklog:
$_CONF['site_mail'] = 'blank@blank.com';

// Name and slogan of your site
$_CONF['site_name'] = 'Geeklog Site';
$_CONF['site_slogan'] = 'Another Nifty Geeklog Site';

http://www.geeklog.net/docs/install.html#access-denied

yes dirk i know , if u look at my orginal post u will see that i have seen that. but that doesn't help much. and by much i mean at all.

I don't think you really read what I pointed you to. You said that you were checking paths etc. but this problem is about your database. Everything that can be said about it is explained in the section of the installation instructions that I pointed you to ...

bye, Dirk

ok then miscomunication , when i mean paths i meant the config file , since there is only those 3 sections to edit i kinda classify them all as one.

basicly i did what that said as soon as i had a problem , i checked the privliges on my databaces on my sever , and all that good junk , and i cant seem to find the problem , hense y i'm posting here , i didn't just get a problem then post for help.

Sorry if this sounds grumpy but what exactly do you expect me to say now?

As the error message states (and the installation instructions explain), this is a problem with your database access. Check the database user name, password, server name, the permissions on the database, etc. for correctness (which is exactly what the installation instructions already said).

You'll have to figure those out yourself, as we can't know what your setup is. If you're new to all this, you may want to ask a friend for help or hire someone to look over your settings.

bye, Dirk

just throwing my in here if you don't mind.
You've been concentrating on paths and all that--good, but maybe you want to ask yourself, "did i actually create the user that my config is using to access this database?"
The config suggests that the database must exist before stuff will work; don't forget that the database user must also exist with proper permissions. If this is not the case--sorry.

// index.php file resides (no trailing slash).
$_CONF['site_url'] = 'http://localhost/';

maybe this is the problem...... ur not supposed to have a trailing slash after localhost

Machinari thanks for trying to help. I did make sure the database was there and the user. however that being said this is my first time running apache and i'm begining to think that my problems lie there. i'll keep looking into it.

Jordan, thank u too for trying to help , i tried ur sugestion but sadly nothing changed , thanks for trying.

I use a redhat 7.3 based distro, SME 6.01 and ran into exactly the same issue. I needed to add a mysql user the correct rights. I found that install help document, but kept getting an error:

mysql> GRANT ALL PRIVILEGES ON geeklog TO geeklog@localhost IDENTIFIED BY 'mypaswd';
ERROR 1046: No Database Selected

I ended up installing phpmyadmin from:
http://www.phpmyadmin.net/

I then clicked on the Priviledges tab, "add new user" link. I skipped the global priviledges and added my geeklog user with the rights to the geeklog table as listed in that install error help document posted above. Something about the syntax of the command in the help document was causing mysql to choke. I have no idea why but phpmyadmin added the needed user and I was able to finish the install without anymore errors.

Hope that helps!

ironicly kinda , i just got it working and i came here to say it. but ya i had a very similar problem , for some reason the phpmyadmin wasnt giving the right rights , like i told it too i refreshed the database , but for some reason it wasn't working.

since i'm not hosting but merely playing around with it to later put on the web i just gave it root and said *censored* it. and when i tried it that time it worked.

Here's a better description of how to add a user to fix that type problem:

Hmm... let's verify that the geeklog user has access to the geeklog db, by resetting the permissions.

(From MD's mysql cheatsheet: http://tech-geeks.org/contrib/mdrone/mysql-cheatsheet.html)

login to console as root:

#> mysql
#mysql> grant all on geeklog.* to geeklog@localhost identified by 'geeklog';

#mysql> quit;


Now, check the config.php file.

#> pico -w /opt/geeklog-1.3.9/config.php

Section 1 has db settings. You should have these:

$_DB_host = 'localhost'; // host name or IP address of your DB server
$_DB_name = 'geeklog'; // name of your database,
// must exist before running the installer!
$_DB_user = 'geeklog'; // MySQL user name
$_DB_pass = 'geeklog'; // MySQL password

Glad to hear you got it fixed!

lol yes , man things are so much easier on linux...

but thanks , i think i maybe able to transfer that into windows

You can use the mysql prompt from windows. just run your cmd.exe (dos box for you old-timers) from the mysql/bin dir. just type "mysql" without the quotes and see how easy it is--it's no different than on linux. and as for pico, well, i'm sure you have a text editor on windows.