Topics

User Functions

Events

There are no upcoming events

What's New

Stories

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

NEW FILES last 14 days

No new files

Welcome to Geeklog Thursday, May 23 2013 @ 07:56 AM EDT


 Forum Index > Support > General Geeklog Support New Topic Post Reply
 What am I doing wrong?
   
gramps
 11/17/03 03:43AM (Read 3005 times)  
+----
Newbie
confused

Status: offline


Registered: 11/16/03
Posts: 10
I have read through the docs, and double checked all the paths in my config.php, and have even did a google search for the following error:


Warning: mysql_connect(): Access denied for user: 'gldtdngs@localhost' (Using password: YES) in /home/gldtdngs/blog/system/databases/mysql.class.php on line 108
Cannnot connect to DB server


I can't seem to be able to straighten this out for some reason. Any suggestions?

 
Profile Email Website
 Quote
Anonymous: stupidtek
 11/17/03 04:25AM  



Your mysql database password is incorrect within the config.php file.
PHP Formatted Code

$_DB_pass         = 'pa$$word';    // MySQL password

 


notes:
1. usernames and passwords are case sensitive
2. if you did not assign a user to the database you will get the error too.

 
 Quote
gramps
 11/18/03 12:49AM  
+----
Newbie
curious

Status: offline


Registered: 11/16/03
Posts: 10
I have done what you suggested, and it didn't work. I even
deleted the original database, and created a new one with new
usernames and passwords, and changed config.php to match it. That still didn't work




I get the following error:
Warning: mysql_connect(): Access denied for user:
'wsloan@localhost' (Using password: YES) in
/home/gldtdngs/blog/system/databases/mysql.class.php on line 108
Cannnot connect to DB server

Line 108 reads:// Connect to MySQL server
$conn =
mysql_connect($this->_host,$this->_user,$this->_pass) or
die('Cannnot connect to DB server');

When I set up the database on my server, I get a string of code
that looks like this:

Perl $dbh =
DBI->connect("DBI:mysql:gldtdngs_truth:localhost","gldtdngs_wsloa
n","");
PHP $dbh=mysql_connect ("localhost", "gldtdngs_wsloan",
"") or die ('I cannot connect to the database
because: ' . mysql_error());
mysql_select_db ("gldtdngs_truth");

Ok, I am no genius here, so correct me if I am wrong. But can I
not fix my problem by hacking line 108 to read what my server
returned to me? Say, starting with where it says PHP, I insert
$dbh_mysql_connect... into the file on line 108 in place of what
is there?


 
Profile Email Website
 Quote
Dirk
 11/18/03 03:31AM  
AAAAA
Admin

Status: offline


Registered: 01/12/02
Posts: 13027
You shouldn't try hacking things. Geeklog is perfectly capable of connecting to your database, provided that the data (user name and password, db name and host) in config.php is correct.

If it's your own database (not one that your hosting service set up for you) then make sure that the database user exists and has the proper access permissions. There's a section in the installation instructions with all the information you would need.

bye, Dirk

 
Profile Email Website
 Quote
gramps
 11/18/03 11:34AM  
+----
Newbie
determined

Status: offline


Registered: 11/16/03
Posts: 10
Ok,
I have done all of that. Several times over. I keep coming back to square one. But there is nothing wrong at square one.
I guess what I need to do is contact tech suport for my hosting service and have them check out my setup. Maybe they will find what is wrong.

I will get back with you.

 
Profile Email Website
 Quote
gramps
 11/18/03 11:12PM  
+----
Newbie
stressed

Status: offline


Registered: 11/16/03
Posts: 10
Ok. I checked with tech support, and found that I did in fact have my username and password entered wrong. I was supposed to prefix the name of the database and username with the name of my account. i.e.; gldtdngs_db, gldtdngs_username.
However, now I get another error message, and it reads like this:
PHP Warning: fopen(/home/gldtdngs/blog/logs/error.log): failed to open stream: Permission denied in /home/gldtdngs/public_html/truth/public_html/lib-common.php on line 1588

What is this telling me?

 
Profile Email Website
 Quote
exaurdon
 11/19/03 12:20AM  
++++-
Regular Poster

Status: offline


Registered: 08/13/03
Posts: 107
That error message is telling you that PHP does not have permission to write to the log file. Check your directory permission (I think the geeklog docs detail which directories need to be set for write access.) You'll need to chmod/chown the logs directory to provide access to the php user.

Alex~

 
Profile Email
 Quote
gramps
 11/20/03 12:13AM  
+----
Newbie

Status: offline


Registered: 11/16/03
Posts: 10
After nearly 4 days of struggling with your script, I finally solved my problem. I deleted the whole thing off my server. Yesterday, I made 47 attempts to get this script to work. I got all kinds of error messages. When I would fix one problem, I would get another error message on the next attempt. Two in particular I would get was the one, "Xsilver is not a valid directory" and the one that told me I had permissions set wrong. I would modify the path to public_html, then my permissions were wrong. I would reset my permissions, then my path would be wrong. Back and forth, forth and back.
I could not tell you what was wrong. If I could I would have fixed it. I deleted it from the server, and installed PHPbb in it's place very easily. In less than ten minutes, with very little configuration, PHPbb was up and running.
I do want to say that I really liked what I saw in the Geeklog script. I liked the rss feed. Every place I went to that was running the script made me think that Geeklog was the script I wanted.
PHPbb was second best for me. But at least I could get it to work with no headaches.
I still have the Geeklog tarball on my computer. I would still like to use it.
Could you explain to me why Geeklog was such a headache, and PHPbb was so painless? I really want to know what the problem was. I would still like to use Geeklog.

 
Profile Email Website
 Quote
Dirk
 11/20/03 01:56PM  
AAAAA
Admin

Status: offline


Registered: 01/12/02
Posts: 13027
Quote by gramps: Could you explain to me why Geeklog was such a headache, and PHPbb was so painless? I really want to know what the problem was. I would still like to use Geeklog.

Sorry to hear you had such a hard time.

In my experience, when people start getting errors, they are sometimes trying to fix things on their own and make things worse. If you follow the installation instructions precisely (and assuming you know some basic things such as what your paths are and how to do a chmod), a Geeklog site should be up and running within a few minutes.

If you're running into trouble, read the error message carefully and try to understand it. People often look for the problem in the wrong file, for example, because they misread the error message. The most common problems are listed in a separate section in the installation instructions - those should cover all the problems people usually run into.

bye, Dirk

 
Profile Email Website
 Quote
Anonymous: max
 11/20/03 04:59PM  



i dont know how this happened, i never edited the files, but i received errors because i had spaces or blanke lines after the php scripts closing, might want ot check that.

 
 Quote
gramps
 11/20/03 06:25PM  
+----
Newbie

Status: offline


Registered: 11/16/03
Posts: 10
I'm back at it again for another try. But now I get a completely different error message that I don't find in the docs or in the forum. It reads like this:

Warning: main(): open_basedir restriction in effect. File(/path/to/geeklog/config.php) is not within the allowed path(s): (/home/gldtdngs:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/gldtdngs/public_html/truth/public_html/lib-common.php on line 69

Warning: main(/path/to/geeklog/config.php): failed to open stream: Operation not permitted in /home/gldtdngs/public_html/truth/public_html/lib-common.php on line 69

Fatal error: main(): Failed opening required '/path/to/geeklog/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gldtdngs/public_html/truth/public_html/lib-common.php on line 69

 
Profile Email Website
 Quote
exaurdon
 11/20/03 06:36PM  
++++-
Regular Poster

Status: offline


Registered: 08/13/03
Posts: 107
Warning: main(): open_basedir restriction in effect. File(/path/to/geeklog/config.php) is not within the allowed path(s): (/home/gldtdngs:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/gldtdngs/public_html/truth/public_html/lib-common.php on line 69


You have not edited your lib-common.php file in your geeklog public_html directory.

(Step 6 of the installation instructions)
(Step 6 of the installation instructions)

It is looking for config.php in '/path/to/geeklog/config.php' You must change line 69, the one where it says require_once( blah blah config.php) to be an absolute or relative path to your config.php dir

 
Profile Email
 Quote
dgrosvold
 11/20/03 11:48PM  
+----
Newbie
angry

Status: offline


Registered: 06/05/03
Posts: 8
There are only 10 kinds of people in the world; those who read binary, and those who don't.


Perhaps you should learn to read binary. Or at least try using an original tag line.

Dave Grosvold - Greenwood, AR
 
Profile Email Website
 Quote
Content generated in: 1.78 seconds
New Topic Post Reply

Normal Topic Normal Topic
Sticky Topic Sticky Topic
Locked Topic Locked Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Able to post 
Filtered HTML Allowed 
Censored Content