Topic: how do I set MySQL user+password?

[Holger]

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!?

[Holger]

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;

???

[guestHH]

Hi,

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

is correct.

Regards,
guestHH

[Holger]

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

[guestHH]

Hi,

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

guestHH

[Holger]

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....

[Holger]

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

[guestHH]

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

[Holger]

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!

[guestHH]

Does it work with or without the RequireSSL?

[Holger]

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.