Topic: Groupware - phprojekt howto and rpm now available

[Andy parkinson]

Thanks for that Ari I had managed to work out the chief rights bit but the problem that is still beating me is the files upload. the error I get is as follows

Oops! Something went wrong ...
Please check whether the file exists in the upload directory
(Maybe the webserver is not allowed to copy the file from the tmp dir into the upload dir)
and the variable dat_rel in the config has the correct value.
Typical values would be:
dateien = "/usr/local/httpd/phprojekt/file"; and dat_rel = "file"; for Linux or /opt/project/upload = "c:\htdocs/phprojekt/file"; and upload = "file"; for windows


Ari Novikoff wrote:
>
> Andy parkinson wrote:
> >
> > This is wonderfull Ari Just what I was looking for. A couple
> > of small problems though.
> >
> > 1. It won't let me upload any files and come back with a
> > message which leads me to believe I need to define an upload
> > directory and
> > 2.I can't creat a project as that part of it seems to be
> > greyed out.
> >
> > Once again thanks for an excellent howto
>
> 1. What is the message it comes back with.
> 2. To create a project, the user must have "chief" rights. I
> know.. "but I'm an admin!. ...." doesn't matter. Figured that
> out the hard way. Seems that they designed the admin account
> to be -just- for administration. The other 2 levels, user and
> chief are the ones that can actually do stuff.
>
> Ari

[Ari Novikoff]

> Typical values would be:
> dateien = "/usr/local/httpd/phprojekt/file"; and dat_rel = "file"

In the 70filemanager fragment of config.inc.php you'll find the following info:
// file manager
$dateien = "/opt/project/upload";
                                // File management no = leave empty,  yes = insert full path
$dat_rel = "upload";            // Relative path to the PHProjekt directory
$dat_crypt = "1";               // Scramble filenames - 0: no, 1: yes

You'll need to create a directory called "upload" in /opt/project since it's not there. Oops! Oversight on my part...

# mkdir -p /opt/project/upload

That should solve the problem.

Ari

[Andy Parkinson]

Tried this as well Ari with no joy



Ari Novikoff wrote:
>
>
> > Typical values would be:
> > dateien = "/usr/local/httpd/phprojekt/file"; and dat_rel =
> "file"
>
> In the 70filemanager fragment of config.inc.php you'll find
> the following info:
> // file manager
> $dateien = "/opt/project/upload";
>                                 // File management no = leave
> empty,  yes = insert full path
> $dat_rel = "upload";            // Relative path to the
> PHProjekt directory
> $dat_crypt = "1";               // Scramble filenames - 0:
> no, 1: yes
>
> You'll need to create a directory called "upload" in
> /opt/project since it's not there. Oops! Oversight on my
> part...
>
> # mkdir -p /opt/project/upload
>
> That should solve the problem.
>
> Ari

[Ari Novikoff]

Andy Parkinson wrote:
>
> Tried this as well Ari with no joy
>

# chown www:www /opt/project/upload
# chmod 777 /opt/project/upload

This does work as I've tested.

Of course, I'm open to other suggestions in limiting just how wide you need to actually open up that directory...

Ari

[Andy Parkinson]

Thanks Ari that did the trick

Ari Novikoff wrote:
>
> Andy Parkinson wrote:
> >
> > Tried this as well Ari with no joy
> >
>
> # chown www:www /opt/project/upload
> # chmod 777 /opt/project/upload
>
> This does work as I've tested.
>
> Of course, I'm open to other suggestions in limiting just how
> wide you need to actually open up that directory...
>
> Ari

[Lazo]

I have no problem with the instalation!! but when i try to connecto to the server
http://mydomain.com/project i have an error

Database connection failed!
Call admin, please.

I enter mysql and type connect project, and the database exists!!

what can I do??

I have SME 5.0 update 4

[Ari Novikoff]

Lazo wrote:
>
> I have no problem with the instalation!! but when i try to
> connecto to the server
> http://mydomain.com/project i have an error
>
> Database connection failed!
> Call admin, please.
>
> I enter mysql and type connect project, and the database
> exists!!
>
> what can I do??
>
> I have SME 5.0 update 4

Did you ever change the password for the root user in MySQL?
If you did, that's the reason it can't connect. You'll have to go about doing some manual editing in the /etc/e-smith/template/opt/project/config.inc.php directory to make sure that it passes the correct password on to MySQL.

Ari

[Lazo]

Forgive for what I'm gonig to say, but I don't know the password for mysql, and I don't know how to change it!! I never touched it!

[Lazo]

How can I know my mysql password, or how can I reset it, so I can use this project thing??

Thanks

[Ari Novikoff]

You don't need to know it. It is automatically derived from your /etc/openldap/ldap.pw file.

[Lazo]

Oh well!!! I'll try with a clean install of SME!!

[Todd Pearsall]

Lazo wrote:
>
> How can I know my mysql password, or how can I reset it, so I
> can use this project thing??
>
> Thanks

You can search for the threads on mysql password and find the basic info.  The short version is the file .my.cnf in your /root directory (use ls -al to see it).  In there is the install mysql password for root (long nasty generated string).  Don't change the password or you'll break other stuff.  From what I understand phprojekt will use this password, but don't know for sure since I've never installed it.

Hope this helps a little.

- Todd

[Bala]

Thanks ....Ari Novikoff

I installed the RPM and it works wonderful...

Thanks again...........

Bala

[glenn pettit]

this is great has anyine tried WAP support or the syn-outlook tool yet.

[Craig Jensen]

Firstly, to Ari Novikoff, this is a great help to us all to have the "Projekt" package available in .rpm esp for e-smith!!!

Lazo, what you will soon learn with this and other forums...do some research and then begin asking.  I myself am just learning the wonder of Mysql and PHP and what they can do.

Here's how I solved the same issue as yours:

You have changed your Mysql password (at least it seems so).  Go here to reset your root password
http://i4net.tv/marticle/get.php?action=getarticle&articleid=9

Now, the package which Ari has put together is created with templates.  For future useage of E-smith you must learn about them.

Anyway, now if you have your root password changed and in memory, do the following...
pico -w /etc/e-smith/templates/opt/project/config.inc.php/10database

remove this:  
          {
open (PW, "/etc/openldap/ldap.pw")
         || die "Could not read LDAP password.\n";
my $pw = ;
chomp ($pw);
close PW;
$OUT .= "$pw";
 }";

Replace with: $db_pass = "your_password_you_just_set ";   // Database password

Then do the expand-template thing... /sbin/e-smith/expand-template /opt/project/config.inc.php

Now try to logon again with 'root' and 'your_password_you_just_set'  Worked for me.  In my attempts to solve the issue I HAD changed my Mysql password