Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: Brandon Friedman on March 02, 2001, 10:47:30 PM
-
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
-
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.
-
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
-
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
-
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
-
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?
-
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.
-
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
-
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
-
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
-
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.
-
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]#
-
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
-
i got it i just have to used:
mysqladmin -p reload
instead of just:
mysqladmin reload
thanks.. got it working.
-
panic: config.inc.php doesn't exist!! Did you backup it after installation? ...
Do I need to start over?
Cheers!
-
What is the command for running setup.php?
Please pardon the ignorance!
Thanks
-
From your browser:
http:/www.yourdomain.com/ibayname/setup.php
Follow the on-screen instructions!
Brandon
-
Thanks. I got it setup.
Now when I load the ibay or even index.php I get the following:
-> login.php
That's all there is on the page.
Any suggestions?
-
Ok, I figured out to type in login.php, but when I add a use and try to login as that user it comes back with "Sorry, you're not allowed in here".
I would really like to start using this.
Please help. Thanks
-
Your logon name is 'lastname' and the password you specified!