Topic: "last" problem after installing twiggi 1.10.13

[Jakob Strebel]

Hello List readers,

my apology to bother you again with the remaining twiggi installation problem.

Using SME 5-6

Just some explanations to my earlier posting;
It seems the different installations of groupware srewed some access setting in MySQL up.
Therefore I removed my add ons and started new:

(rpm -Uvv twiggi-sme-server-1.10.13-0.noarch.rpm)
The log produced by the installation does not contain any errors or warnings.


I have now a working version of twiggi which has only (as far I see) the problem you see the log entry below.

Mar  3 15:12:48 kobifix httpd: PHP Warning:  
Access denied for user: 'twiggi_admin@localhost' (Using password: YES)
 in /opt/groupware/twiggi/lib/db/mysql.db.inc.php on line 81
Mar  3 15:22:53 kobifix last message repeated 65 times

(every time I make a entry then the count of this message counts up. I do not see any strange behaveyours in the application. I was able to change the defaults of twiggi and can make entries and changes in the application)


Q: how can I fix the remaining problem.
Q: does twiggi_admin have a another password?

This are the acces right I gave.


mysql> grant all privileges on *.* to twiggi_admin@localhost identified by 'xxxxxxx';
mysql> grant all privileges on *.* to twiggi@localhost identified by 'xxxxxxx';
mysql> grant all privileges on *.* to www@localhost identified by '';
mysql> grant all privileges on *.* to jakob@localhost identified by 'xxxxxxx';

Here is some info about the tables:

mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv    |
| db              |
| func            |
| host            |
| tables_priv     |
| user            |
+-----------------+

examinin table user:

mysql> select * from user;
+-----------+--------------+------------------+-------------+-
| Host      | User         | Password         | Select_priv |
+-----------+--------------+------------------+-------------+-
| localhost | root         | 3d3884ab4da3bf8f | Y           |
| kobifix   | root         | 3d3884ab4da3bf8f | Y           |
| localhost | twiggi       | 545491c04c2500e6 | Y           |
| localhost | jakob        | 545491c04c2500e6 | Y           |
| localhost | twiggi_admin | 545491c04c2500e6 | Y           |      
| localhost | www          |                  | Y           |      
+-----------+--------------+------------------+-------------+--

Thank you for your time in advance to look into it.

Jakob Strebel

[Bob Todd]

why exactly are you making these changes to the twiggi install? I installed that same rpm on 5.6 today and it went on first time with apparently no problems. I then tested logins with a selection of the users on the server and they were all functioning as expected, tried e-mail, group diaries etc.

[Jakob Strebel]

Bob,
thank you for the response.

> why exactly are you making these changes to the twiggi install?

I could not login at all to twiggi. ( I got similar access denied messages as above for the names where I granted the access by hand.)

I start to think that twiggi did not like the previously installed (and later removed) phproject and phpgroupware which where installed from the SME repositories. It looks to me that twiggi install does ignore settings or get confused form other previously installed php/MySQL apps.
Would be great if one of the experts gives advises.

> I installed that same rpm on 5.6 today and it went on first time with apparently >no problems.

Would it be possible to send me the output of the table: user ? I guess this gives me a idea where the problem is.

Best regards
jakob

[alejandro]

this thread Seems to be the answer to login twiggi problems exept mine.

http://forums.contribs.org/index.php?topic=16361.msg63295#msg63295

When I log into twiggi I pass the user password screen and I'm able see mails etc, but if I try to use one of the panels, Icons or whatever, it kiks me off  the login screen apears again,
I'm being ignored by twiggi once already logged in,....yep strange isn't?
any clues?

[alejandro]

this thread Seems to be the answer to login twiggi problems exept mine.

http://forums.contribs.org/index.php?topic=16361.msg63295#msg63295

When I log into twiggi I pass the user password screen and I'm able see mails etc, but if I try to use one of the panels, Icons or whatever, it kiks me off  the login screen apears again,
I'm being ignored by twiggi once already logged in,....yep strange isn't?
any clues?