Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: arnoldob on May 07, 2004, 11:39:56 PM

Title: Geeklog install issue with mysql
Post by: arnoldob on May 07, 2004, 11:39:56 PM

I was running through the geeklog contrib by Abe Lovelss and ran into a snag:
[root@server root]# rpm -Uvh smeserver-geeklog-1.3.9*.noarch.rpm
Preparing...                ########################################### [100%]
   1:smeserver-geeklog-1.3.9########################################### [100%]
Gracefully reloading httpd: [   OK   ]
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Creating database...
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

I assume this is because I set a password for mysql root user as recommended at mysql.org  So, how do I make this rpm install run correctly? I don't see a way of removing the root password to do the install on the mysql.org website. I have never really messed with mysql before. Any suggestions?

Title: Geeklog install issue with mysql
Post by: arnoldob on May 08, 2004, 04:43:36 PM

Anybody have any ideas on this?
Thanks :)

Title: Geeklog install issue with mysql
Post by: ergozd on May 09, 2004, 07:11:44 PM

It is mysql user/password issue

Try to run

http://your-server/geeklog/admin/install/

OR
copy /opt/geeklog-1.3.9/sql/mysql_tabelanddata.php file somewhere you can access via webbrowser and try to run it.

Good luck.

Title: Geeklog install issue with mysql
Post by: Anonymous on May 10, 2004, 06:33:29 PM

I tried re-running the install page you suggested. But that made no difference. I found this in another thread:

http://forums.contribs.org/index.php?topic=22343.msg88673#msg88673

It suggests trying this:

[root@tuxtest /root] # /etc/rc.d/init.d/mysqld stop
[root@tuxtest  /root # /etc/esmith/events/actions/conf-mysql-password
[root@tuxtest /root] # /etc/rc.d/init.d/mysqld start

That sets the mysql root password back to default :)

There's a helpful howto here as well:
http://www.familybrown.org/howtos/mysql-password-howto.html

Title: Geeklog install issue with mysql
Post by: arnoldob on May 10, 2004, 06:37:20 PM

oops forgot to login again :pint: