Topic: Another groupware product!

[Brandon Friedman]

For those interested:
I have been testing another web-based groupware product called PHProjekt:

homepage: http://www.phprojekt.de/en/

download page: http://www.phprojekt.de/phprojekt.tar.gz

It has really cool features - all work great! Chat, forum, calendar, notes,todo, contacts etc...

A quick howto....

1) Create a web-accessible i-bay eg groupware
2) Unzip the file eg tar -zxvf phprojekt.tar.gz and copy the contents to your ibay html directory /ibays/groupware/html
3) Create a database in mysql and a user to control it eg
mysql> create database groupware;
mysql> grant all on groupware.* to groupware@localhost indentified by 'password';
exit
mysqladmin reload
4)Run the setup php - from your browser http://www.mydomain.com/groupware/setup.php
5)Follow the on-screen instructions.
6)Have fun!
Brandon

[Nef]

3) Create a database in mysql and a user to control it eg
  mysql> create database groupware;
  mysql> grant all on groupware.* to groupware@localhost   indentified by 'password';
  exit
  mysqladmin reload

4)Run the setup php - from your browser   http://www.mydomain.com/groupware/setup.php

5)Follow the on-screen instructions.

can you give us more detailed and step by step perhaps instruction in creating the database ans seting up the groupware?
or a sample.

thanks.

[Nef]

Warning: MySQL Connection Failed: Unknown MySQL Server Host 'groupware@localhost' (2) in /home/e-smith/files/ibays/groupware/html/setup.php on line 112
Sorry, it does not work!
Please fix it and restart the installation.

i get the above error when i tried setting up, can you help me how to set this up.

thanks

[Brandon Friedman]

Ok you need to log onto the console as root and run the commands:
mysql
mysql> create database groupware;
mysql> grant all on groupware.* to groupware@localhost indentified by 'password';
exit
mysql reload
This has setup a database called groupware and a user called groupware that can control the database and you specified a 'password' - got it?

Next you went to your browser:
http://www.yourdomain.com/setup.php
Chose installation and then click on the next button
The next page asks you info about the the database:
Hostname: leave this blank
DBuser: groupware
DBPassword: password - the password you chose above
Exisiting database: groupware
That's it: the next page asks you a whole lot of variable - I left it as default.
You can then go to the index page: www.mydomain.com/groupware/
Log in as root - passwd root.
You can add new users from the admin tab at the top....
BF

[Brandon Friedman]

Sorry (a bit tired here!!!)

>exit
>mysql reload

That should say:
exit
mysqladmin reload

Also:

>Next you went to your browser:
>http://www.yourdomain.com/setup.php

It should be:
http://www.yourdomain.com/groupware/setup.php

<<<>>>>>
Good night!
BF

[Nef]

here is what i did:

i login to the server as root:

i change the directory from root to
cd /home/e-smith/files/ibays/groupware/html

i run this command and simply supplement password and the rest is as is:

  mysql> create database groupware;
  mysql> grant all on groupware.* to groupware@localhost  
indentified by 'password';
  exit
  mysqladmin reload

after i run mysqladmin reload i get this error:

mysqladmin:connect to server at 'localhost' failed
error" 'Access denied for user" 'root@localhost' (using password: NO)'

thanks

  This has setup a database called groupware and a user called groupware that can control the database and you specified a
  'password' - got it?

[Nef]

when i browse the setup.php this is what i get

Warning: MySQL Connection Failed: Access denied for user: 'groupware@localhost' (Using password: YES) in
/home/e-smith/files/ibays/groupware/html/setup.php on line 112
Sorry, it does not work!
Please fix it and restart the installation.

[Brandon Friedman]

Well.... I am not to sure.......

You can try use root as the dbuser in your setup.php configuration!

What I can suggest , if you haven't done it already, drop you're database groupware and start over....

Just try fiddle around.....
The setup procedure for this programme is similar to other php+mysql apps.
Here is an example:
http://linux.made-to-order.net/article.php

Use it as a guideline
BF

[Brandon Friedman]

Hi there
Below is a screen dump from my console:
You can replace the 'password' with something else eg 'abcdefg'

login as: root
Sent username "root"
root@192.168.42.50's password:
Last login: Mon Mar  5 11:20:19 2001
Welcome to the e-smith server and gateway.
[root@smb-server /root]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.32

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> create database groupware;
Query OK, 1 row affected (0.18 sec)

mysql> grant all on groupware.* to groupware@localhost identified by 'password';Query OK, 0 rows affected (0.18 sec)

mysql> exit
Bye
[root@smb-server /root]# mysqladmin reload
[root@smb-server /root]#

Let me know if it helps?
BF

[Nef]

i login in as "admin" to the console and run mysql:

e-smith server and gateway release 4.0.1beta1
 (based on Red Hat Linux release 6.1)
Kernel 2.2.16-3 on an i686
login: root
Password:
Last login: Tue Mar  6 07:45:28 on tty2
Welcome to the e-smith server and gateway.

[root@internet-srvr /root]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO
[root@internet-srvr /root]#

i get an error of access denied. thanks

[Dan Brown]

Well, first, you're logging in as root, not as admin--but this is a good thing.

Second, prior to version 4.1, you need to know the MySQL root password and enter it when you use mysql.  In that case, you'd use the command 'mysql -p' instead of just 'mysql' to start it.  The MySQL documentation should explain this.

[Nef]

Below is a screen dump from my console using the mysql -p:


e-smith server and gateway release 4.0.1beta1
 (based on Red Hat Linux release 6.1)
Kernel 2.2.16-3 on an i686
login: root
Password:
Last login: Tue Mar  6 10:00:50 from pc-00001.e-smith.chemrockph.com
Welcome to the e-smith server and gateway.
[root@internet-srvr /root]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 32 to server version: 3.22.32

Type 'help' for help.

mysql> create database groupware;
Query OK, 1 row affected (0.01 sec)

mysql> grant all on groupware.* to groupware@localhost identified by 'password';
Query OK, 0 rows affected (0.00 sec)


thanks

mysql> exit
Bye
[root@internet-srvr /root]# mysqladmin reload
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
[root@internet-srvr /root]#

[Charlie Brady]

Nef wrote:

> e-smith server and gateway release 4.0.1beta1
>  (based on Red Hat Linux release 6.1)

I don't even remember a 4.0.1beta1.

In any case, you should upgrade to 4.1.1. Things will work better, and if you need help, you'll get better help.

Regards

Charlie

[Nef]

i got it i just have to used:

mysqladmin -p reload

instead of just:

mysqladmin reload

thanks.. got it working.

[Richard]

panic: config.inc.php doesn't exist!! Did you backup it after installation? ...

Do I need to start over?

Cheers!