Re: [Perp-developers] perp 0.2.003 on egw 1.8

[Bjorn P. <per...@ad...>]

Hi Nathan,

Yeah, imagine my surprise... Hence my first, a bit, puzzled post, thinking this was work in progress...

Anyway... Did what you said and... Same result... It just doesn't work. If I switch to mysqlt after installation (I installed with mysql), then I just end up with the same issue, despite installing with mysql. Not to mention mysqli... That just doesn't even work a bit. If I set it to mysqli and I try to login, I get an error straight away, with some mysql query-syntax error, missing the variable to a query, I believe. Nothing else works after that, of course.

But this is not the only issue I've got. I have several. 

If I install perp first time and I use a starting id (uid/gid) in the egw config, everything installs fine, but when I login with my admin user, I notice stuff missing from the admin page for the perp module (ACL and the likes are all missing). That's because, when I was looking at the egw_acl in my db, I saw a lot of access grants to gid "-2", while my admin group starts somewhere around -10000. So I "update egw_acl set acl_account='-10000' where acl_account='-2'" and logged out and back in again. That gives me the menus, correctly, for perp admin. 

Now, I am also using LDAP for users, as well as for the addressbook. Bad idea too. I am a LDAP freak, but somehow this screws up the country field in the addressbook of EGW. I cannot select a country from the list, I have to type it, for some weird reason.

Hence, for that reason, I figured that AR clients->addressbook linking wasn't working, because of my LDAP backend. However, I first switched addressbook to mysql and it still didn't work. Then I found out that mysqlt seemed to be the culprit.

I have one debian system running this (on mysql, which is fine) and one ubuntu system that is giving me the exact same problem when I set the whole lot to mysqlt. When I switch back to mysql again, everything is fine there too. 

Are you running suhosin and/or suphp? It's the best I can think of... Any other ideas, anybody?

Maybe the install problem I have to manually fix, has something to do with it?

Let me know if I can do anymore tests...


Best,
B]

--------------------------------------------------------------- 
Bjorn Padding
BHP Solutions Design, S.L. 

Web http://bhpsd.com 
Tel +31 (0)70 324 50 20 (Netherlands) 
Tel +34 677 66 15 24 (Spain) 
--------------------------------------------------------------- 
Because high performance survives Darwin




 
----------------original message-----------------
From:"Nathan Gray" nat...@gm... 
To:"Bjorn Padding" 
CC:per...@li... 
Date:Mon, 17 Jan 2011 09:03:32 -0700
-------------------------------------------------
 
 
> On Sat, Jan 15, 2011 at 4:19 PM, Bjorn Padding
> 
 wrote:
>> ... Don't ask me why (nor why I put it to mysqlt) ...
> 
> 
> That is so weird. I have all mine set to mysqlt, and have not seen
> this. Perhaps there's a difference between installation time and run
> time? I would be interested to know if you can use mysql for
> installation, then switch it to mysqlt after your installation is
> done.
> 
> As for why you would want mysqlt, the T is for transactions. Highly
> recommended.
> 
> Nathan
>