Re: [SOGo] Sogo creates three tables in database upon login, how? why?

[Sven Schwedas]

On 2014-02-21 10:41, Jay Fitz wrote:
> Really? That seems a tad inefficient.

Really? The tables hold different data (raw data, ACLs and a
pre-rendered cache), why clobber all that in a single one?

> Is there any way to get it to put
> all that data in a single table? There's a single table for all of the
> users folder  and session info.

Those also hold significantly less data.

> OK, technically innodb can handle up to 4 billion tables and I'm
> probably going to end up with only 50,000 but more than 100 in a single
> DB makes me uncomfortable.

5 columns per table are hardly an improvement. ;)

> 
> 
> On 20 February 2014 19:17, Louis-Philippe  > wrote:
> 
> It's not a problem ... It's normal.
> 
> add a event in a calendar and delete the tables ... You will lost
> your data !
> 
> 
> 
> 
> 
> 
> 2014-02-20 12:45 GMT-05:00  >:
> 
> sogo 2.0.7-1, ubuntu 12.04, postfix, mysql, dovecot
> 
> hello, got an odd problem, using sogo with mysql and whenever a
> user first
> logs in, it creates three tables in my vmail database like this
> 
> sogouserdoma0010691ef21
> sogouserdoma0010691ef21_acl
> sogouserdoma0010691ef21_quick
> 
> it uses the first 8 characters of the email address where it has
> "userdoma"
> and the a quasi random string
> 
> There doesn't appear to be anything in these tables and nothing
> seems to break
> when I delete them.
> 
> Can anyone suggest why this many be happening and how to stop it?
> --
> users@sogo.nu 
> https://inverse.ca/sogo/lists
> 
> 
> 
> 
> -- 
> Louis-Philippe
> 
> 
> 
> 
> -- 
> This is not a signature
> 

-- 
Mit freundlichen Grüßen, / Best Regards,
Sven Schwedas
Systemadministrator
TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz
Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167
http://software.tao.at



signature.asc
Description: OpenPGP digital signature

Re: [SOGo] Sogo creates three tables in database upon login, how? why?

[Sven Schwedas]

Hi,

On 2014-02-20 18:45, pcbad...@gmail.com wrote:
> sogo 2.0.7-1, ubuntu 12.04, postfix, mysql, dovecot
> 
> hello, got an odd problem, using sogo with mysql and whenever a user first
> logs in, it creates three tables in my vmail database like this
> 
> sogouserdoma0010691ef21
> sogouserdoma0010691ef21_acl
> sogouserdoma0010691ef21_quick
> 
> it uses the first 8 characters of the email address where it has "userdoma"
> and the a quasi random string

That's for the default user calendar, I guess. Add new calendars or
address books, and their tables will appear too.

> There doesn't appear to be anything in these tables and nothing seems to break
> when I delete them.

You didn't enter anything into the calendar yet (nor modified its ACLs).
The metadata are stored in the sogo_folder_info table and you should
have an entry for each table triplet.

> Can anyone suggest why this many be happening

Because you're using sogo.

> and how to stop it?

Stop using sogo.

-- 
Mit freundlichen Grüßen, / Best Regards,
Sven Schwedas
Systemadministrator
TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz
Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167
http://software.tao.at



signature.asc
Description: OpenPGP digital signature

Re: [SOGo] Sogo creates three tables in database upon login, how? why?

[Jay Fitz]

Really? That seems a tad inefficient. Is there any way to get it to put all
that data in a single table? There's a single table for all of the users
folder  and session info.

OK, technically innodb can handle up to 4 billion tables and I'm probably
going to end up with only 50,000 but more than 100 in a single DB makes me
uncomfortable.


On 20 February 2014 19:17, Louis-Philippe  wrote:

> It's not a problem ... It's normal.
>
> add a event in a calendar and delete the tables ... You will lost your
> data !
>
>
>
>
>
>
> 2014-02-20 12:45 GMT-05:00 :
>
> sogo 2.0.7-1, ubuntu 12.04, postfix, mysql, dovecot
>>
>> hello, got an odd problem, using sogo with mysql and whenever a user first
>> logs in, it creates three tables in my vmail database like this
>>
>> sogouserdoma0010691ef21
>> sogouserdoma0010691ef21_acl
>> sogouserdoma0010691ef21_quick
>>
>> it uses the first 8 characters of the email address where it has
>> "userdoma"
>> and the a quasi random string
>>
>> There doesn't appear to be anything in these tables and nothing seems to
>> break
>> when I delete them.
>>
>> Can anyone suggest why this many be happening and how to stop it?
>> --
>> users@sogo.nu
>> https://inverse.ca/sogo/lists
>>
>
>
>
> --
> Louis-Philippe
>



-- 
This is not a signature
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Sogo creates three tables in database upon login, how? why?

[Louis-Philippe]

It's not a problem ... It's normal.

add a event in a calendar and delete the tables ... You will lost your data
!






2014-02-20 12:45 GMT-05:00 :

> sogo 2.0.7-1, ubuntu 12.04, postfix, mysql, dovecot
>
> hello, got an odd problem, using sogo with mysql and whenever a user first
> logs in, it creates three tables in my vmail database like this
>
> sogouserdoma0010691ef21
> sogouserdoma0010691ef21_acl
> sogouserdoma0010691ef21_quick
>
> it uses the first 8 characters of the email address where it has "userdoma"
> and the a quasi random string
>
> There doesn't appear to be anything in these tables and nothing seems to
> break
> when I delete them.
>
> Can anyone suggest why this many be happening and how to stop it?
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>



-- 
Louis-Philippe
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Sogo creates three tables in database upon login, how? why?

[pcbadger]

sogo 2.0.7-1, ubuntu 12.04, postfix, mysql, dovecot

hello, got an odd problem, using sogo with mysql and whenever a user first
logs in, it creates three tables in my vmail database like this

sogouserdoma0010691ef21
sogouserdoma0010691ef21_acl
sogouserdoma0010691ef21_quick

it uses the first 8 characters of the email address where it has "userdoma"
and the a quasi random string

There doesn't appear to be anything in these tables and nothing seems to break
when I delete them.

Can anyone suggest why this many be happening and how to stop it?
-- 
users@sogo.nu
https://inverse.ca/sogo/lists