Topic: Urgent Webmail Fetchmail Accounts Problem

[Agent86]

Hi all

I was playing around with adding hotmail account to fetchmail, and put a setting in like pop.mail.hotmail.com or something like this.
Now I can't get into wemail at all ? Note:with this user only.

If I could at least turn off the fetchmail for other accounts until I could login and fix this fetchmail setting or remove if from my account then I would be ok ?

I have my webmail set to login and fetchmail automatically on login. So now I can't get into the webmail because it's trying to check for this bogus settings I put in for other accounts in fetchmail; I can login but it just keeps thinking and thinking and never goes into webmail so I can't change these settings or take them out ?
because I can't get past the initial login.

How do I take out the extra account that I put into fetchmail options without beging able to access my webmail with this user ? Or even change the fetchmail setting so it won't fetch upon login ?

Please advise
Thanks

[mrjhb3]

If you have mysqladmin installed, you should be able to use it and remove from the horde_prefs table, under the pref_scope of imp the pref_names of fm_accounts and all of the fetchmail_ entries (I see three for my user) for that user.

John

[cactus]

If you have mysqladmin installed, you should be able to use it and remove from the horde_prefs table, under the pref_scope of imp the pref_names of fm_accounts and all of the fetchmail_ entries (I see three for my user) for that user.

John

Or perhaps restore from a recent backup from before the configuration change?

[mrjhb3]

Or perhaps restore from a recent backup from before the configuration change?

You wouldn't need to do a complete restore, you'd only need the horde db restored, so you could re-import it.

If we're trying to come up with a lot of other options, here are two more:

1. Remove the horde settings above via the mysql command line
2. Dump the horde DB, make the changes to the file, re-import it

JB

[Agent86]

WOW,

It's hard to believe all because of one setting in one user account in fetchmail That I may have to restore from backup or ditch the complete horde db etc.

I have a backup, but it's the complete default backup used with dar2, and I'm not sure how to extract only the horde DB that I need ?

For one user to mistype or incorrectly setup an account in fetchmail, this seems like a lot of work to correct?

Can't I just remove that fetchmail account some place else or perhaps stop fetchmail from doing anything so that I can access the webmail interface and make changes ?

If I just let Fetchmail continue to think, and think and think will it ever get into webmail interface or will it just keep trying ?


Thanks

[Agent86]

You wouldn't need to do a complete restore, you'd only need the horde db restored, so you could re-import it.

If we're trying to come up with a lot of other options, here are two more:

1. Remove the horde settings above via the mysql command line
2. Dump the horde DB, make the changes to the file, re-import it

JB

I would like to give any of these a try, but I'm not sure how to do it. I don't really understand the command line but I would like to try it, or dump the horde DB but I don't even know where it is located and can't seem to find it.
I'm having trouble understanding the above instruction as well.

Thanks for any help on this.

It appears I can access the mysql commandline, however according to this:

  Access MySQL from the local network

MySQL on SME Server is run on a socket instead of on a port. MySQL on SME Server is by default configured to allow only localhost connections to improve security, this means that it is only accessible from the server itself and not from the local network nor from the internet. If you wish to enable local network access, execute the following commands on a SME Server shell as root:

config setprop mysqld LocalNetworkingOnly no
expand-template /etc/my.cnf
sv t /service/mysqld

I'm not suppose to be able to because I never ran these commands, however I can ssh to the server from the local network and login to mysql.

Anyhow I just want to get rid of the fetchmail setting fm accounts as suggested.

Thanks for any help on this once again.

[Agent86]

If you have mysqladmin installed, you should be able to use it and remove from the horde_prefs table, under the pref_scope of imp the pref_names of fm_accounts and all of the fetchmail_ entries (I see three for my user) for that user.

John

I keep reading and reading and reading for about 2 days straight now;and it appears this is a complicated task for someone who knows nothing about mysql.
I believe I understand your instruction but I do'nt know how to delete the entry ?

I can show databases; thus far thats about all I can do from commandline, I'm trying to figure out the command to open the database and edit / remove the fetchmail entries

I can veiw databases and tables now, hopefully by the end of next week I'll finally be able to edit with the commandline and remove this entry if my raid array holds up. Then I can backup and install new server since my raid is partially degraded.


Please advise

[Agent86]

Ok I've installed PHPmyadminmulti from the contribs and I can see the structure of the databases and horde_pref etc.

I've got it fixed now, thanks to all.