Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Holger on November 28, 2002, 11:51:27 PM

Title: how do I set MySQL user+password?
Post by: Holger on November 28, 2002, 11:51:27 PM

First:
I know _nothing_ about mysql  :(

Now, I'm trying to follow the howto at:
http://www.e-smith.org/docs/howto/contrib/howto-install-phpgroupware.txt

It says:
------------------ snip ---------------------------
   -         Now Enter: grant all on phpgroupware.* to
   phpgroupware@localhost identified by 'password';
   
   -         Change the username and password to fit your needs.
------------------ snip ---------------------------
 ... but I see don't 'username' anywhere!?

Title: Re: how do I set MySQL user+password?
Post by: Holger on November 29, 2002, 12:39:13 AM

phpgroupware is the user, right?

let's say my password is pw (and user is mygroup). Would I then write?:
grant all on phpgroupware.* to mygroup@localhost identified by 'pw';

Or?:
grant all on phpgroupware.* to mygroup@localhost identified by pw;

???

Title: Re: how do I set MySQL user+password?
Post by: guestHH on November 29, 2002, 12:58:20 AM

Hi,

grant all on phpgroupware.* to mygroup@localhost identified by 'pw';

is correct.

Regards,
guestHH

Title: Re: how do I set MySQL user+password?
Post by: Holger on November 29, 2002, 01:08:08 AM

Thanx!

maybe you should clarify that in your howto!?   Just a suggestion!  :)

Actually I've already tried it - but it doesn't work :(
My browser can't connect to it - and I can't find anything in the log files....

Or maybe it does connect... the MSIE globe icon is still rotating - now after 30 minutes.

I will send you another billion thanx, once I get the darn thing working ;)

Cheers

Title: Re: how do I set MySQL user+password?
Post by: guestHH on November 29, 2002, 01:16:20 AM

Hi,

- What's the URL you're trying to connect to
- What's the exact result

guestHH

Title: Re: how do I set MySQL user+password?
Post by: Holger on November 29, 2002, 01:23:45 AM

And thanx again for you swift support - it's really appriciated!

I changed it to /group and I don't have an ibay of that name - is that ok?

Then I connect to:
https://www.mydomain.dk/group/setup

... and it hangs.

My gues it's got something to do with permissions...
------------------ snip ---------------------------
cd /opt
ls -l
total 12
drwxr-xr-x    3 root     root         4096 Aug 27 22:06 administration
drwxrwx---   52 500      www          4096 Nov 25 19:05 phpgroupware
------------------ snip ---------------------------
ls -l phpgroupware/
total 276
-rw-r--r--    1 500      users        1915 Jan  2  2002 about.php
drwxr-xr-x    7 500      users        4096 Nov 25 19:05 addressbook
drwxr-xr-x    8 500      users        4096 Nov 25 19:05 admin
..... snip ......
drwx------    5 www      www          4096 Jan 28  2002 files
......
------------------ snip ---------------------------
I'm a bit worried about the "500" user and the "users" group....
But I can't figure out the consequences or what it ought to be....

Title: Re: how do I set MySQL user+password?
Post by: Holger on November 29, 2002, 01:27:45 AM

ok, that didn't really answer your question did it?!

I don't get anything back in the browser - just a blank page. And the icon keeps rotating.


The template looks like this:
cat /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/98phpgroupware
#-------------------------------------------
# phpGroupWare
#-------------------------------------------

Alias /group /opt/phpgroupware


    RequireSSL on
    AddType application/x-httpd-php .php .php3 .phtml
    Options Indexes +Includes FollowSymLinks
    order deny,allow
    deny from all
    allow from all

Title: Re: how do I set MySQL user+password?
Post by: guestHH on November 29, 2002, 01:32:46 AM

Well,

Did you follow step 3? expanded and restarted httpd? If you did, try to remove the RequireSSL line, expand and restart httpd again. Give it another try

guestHH

Title: Re: how do I set MySQL user+password?
Post by: Holger on November 29, 2002, 01:42:37 AM

ok it works now - or I can get setup page. I'll get back with a status later.

It looks like it was a sudden dns problem - hmmm strange!

Thanx again!

Title: Re: how do I set MySQL user+password?
Post by: guestHH on November 29, 2002, 01:47:56 AM

Does it work with or without the RequireSSL?

Title: Re: how do I set MySQL user+password?
Post by: Holger on November 29, 2002, 01:52:48 AM

It worked without when I removed the line and with ssl when I put it back in.

I haven't yet tested if pure http gets through now.