Re: [SM-PLUGINS] multilogin problem

[Oguzhan K. <ogu...@bi...>]

On Tuesday, December 14, 2010 11:25:08 pm Paul Lesniewski wrote:
> Please configure your Outlook to quote replies properly.
> 
> >>> Hello,
> >>> I installed sm 1.4.21 with multilogin plugin.
> >>> And i added mysql based prefs.(which my other Sm installation 1.4.15
> >>> uses) I check that none of my user preferences is loaded.
> >>> But if i update a value (for ex my name) i can see that it is updated
> >>> on mysql
> >>> side.
> >>> By the way after i update i can see the prefs correctly on 1.4.21
> >>> options too.
> >> 
> >> You're saying it *does* save your preferences correctly.  So please
> >> explain what the problem is.  Try with a variety of very different
> >> settings.
> > 
> > For ex, if I open Personal Information, it shows blank in all fields as
> > my name email signature etc (even all exists on database)
> > 
> > And after that if I type my name and save again, it starts to appear on
> > info page too.
> > 
> > Then if I logout and login back, it is empty again.
> > 
> > (By the way it updates mysql side correcty, I tried adding some extra
> > letters to my name etc, and it all seems ok on mysql, and 1.4.15 (which
> > uses same databases)
> > 
> >>> I got
> >>>          'prefs_dsn'         => 'mysql://xx:xx@sqlserver/sqltable',
> >>>          'prefs_table'       => 'userprefs',
> >>>          'prefs_user_field'  => 'user',
> >>>          'prefs_key_field'   => 'prefkey',
> >>>          'prefs_val_field'   => 'prefval',
> >>> 
> >>> on my multilogin settings for this domain.
> >>> 
> >>> Why it doesnt load preferences?
> >> 
> >> Did this used to work (in 1.4.15)?  Did you patch the core when you
> >> installed the plugin?
> > 
> > yes I patched .21
> > I don't use this plugin on 1.4.15, istead I modified login.php and made a
> > complete different approach to mutiple domains, which uses different file
> > paths for all domains. But because it is not smthing standart, I decided
> > to use such plugins with my fresh install.
> 
> You should try without ANY plugins activated.  Make sure
> includes/validate.php has the Multilogin code in it as well.  I recall
> an identical issue reported a few months ago, and although I can't
> remember if a solution was found, I don't believe it had anything to
> do with any plugins.  You may want to search carefully through the
> archives.  I just tried replicating your setup with alternate database
> settings in Multilogin and it worked just fine for me.

Yes i got the following lines in validate.php

require_once(SM_PATH . 'class/mime.class.php');
require_once(SM_PATH . 'functions/global.php');

include_once(SM_PATH . 'plugins/multilogin/functions.php');
multilogin_sqoverride_config_do(array('validate_top')); // dummy hook name

require_once(SM_PATH . 'functions/i18n.php');
require_once(SM_PATH . 'functions/auth.php');


I removed all plugins except multilogin
then i started to tcpdump connection between sqmail and mysql server.
Only packets i captured was 
REPLACE INTO userprefs (user, prefkey, prefval) 
VALUES('oguzhank','hililist','a:0:{}')

REPLACE INTO userprefs (user, prefkey, prefval) 
VALUES('oguzhank','security_tokens','a:1:{s:12:
\"xVrgGca9VR0J\";i:1292397726;}')

thats all.

When i change any value on options, i can see that:
REPLACE INTO userprefs (user, prefkey, prefval) 
VALUES('oguzhank','full_name','Oguzhan Kayhan')

When i click on addressbook i can see
SELECT * FROM address WHERE owner='oguzhank'

But it is interesting that..if i click on any options page i see no select 
query for userprefs..

PS: I installed 1.4.22 stable to test..it doesnt work either.
sqmail is running on
Server version: Apache/2.2.14 (Ubuntu)
PS2:  I removed multilogin and just configured mysql for single site on sqmail 
with conf.pl (just to see if there is any problem on reaching sql server from 
this computer), it worked fine.