Topic: Snafu'd my IMP

[Ruusvuu]

I don't know what happened.
I opened https://***.***.**.**/webmail
and got access denied for user hordemgr@localhost using password YES

So I installed IMP 3.1
Now I get:

Some of IMP's configuration files are missing:
conf.php This is the main IMP configuration file. It contains paths and options for the IMP scripts.
html.php This file controls the stylesheet that is used to set colors and fonts in addition to or overriding Horde defaults.
mime_drivers.php This file controls local MIME drivers for IMP, specifically what kinds of attachments are viewable and/or downloadable.
prefs.php This file controls the default preferences for IMP, and also controls which preferences users can alter.
servers.php This file controls the default settings for IMP, and also defines the list of available servers if you are using the server list.

What have I done? %(

Thanks

[Ruusvuu]

OK, I'm an idiot!

all the files in the horde folder are named .php3
The new IMP is obviously looking for .php files.

Simple question:   How do I rename the files from SSH?

Thank you!

[Dan G.]

_HOW_ did you upgrade?  Were you following Dan Brown's very nice How-to to the letter?   ...and I mean, to the letter?

If you did, something else would have to be majorly unhinged to come up with what you are seeing...

Dan G.

[Dan Brown]

If he upgraded to IMP 3.1, he couldn't have done so following my HOWTO, as it's for IMP 3.0 only.  I'll update it after IMP 3.1 is released (not in RC stage).

[Ruusvuu]

Hi Dan!

Maybe I can upgrade to 3.0 using --force?
I really hope I didn't totally mess things up.

[Dan Brown]

Depends how you installed 3.1.  If you used tarballs, you shouldn't need --force; just follow my howto.

[Ruusvuu]

Thanks for your help Dan.
What is the default password for hordemgr?
I don't know what happened to it.
The horde DB was gone and the user hordemgr was gone, too.
Once I get this fixed, I think I'm ready to roll.

Richard

[Ruusvuu]

Hello Gentlemen!

PHP works
MySQL works
They don't work together
In attempting to finally follow DB's How-To, I get the following:

[root@xend php412]# ls
php-4.1.2-2es.i386.rpm       php-mysql-4.1.2-2es.i386.rpm
php-imap-4.1.2-2es.i386.rpm  php-pgsql-4.1.2-2es.i386.rpm
php-ldap-4.1.2-2es.i386.rpm
[root@xend php412]# rpm -Fvh *
[root@xend php412]# rpm -Uvh *
error: failed dependencies:
        postgresql is needed by php-pgsql-4.1.2-2es
        libpq.so   is needed by php-pgsql-4.1.2-2es
[root@xend php412]#

Any and all help appreciated.

"A good teacher makes him/herself progressively unnecessary."
                                                                    Author Unknown

[robert]

Do you get any errors in IMP? Because the rpm error is easily explained and nothing to worry about. The -F switch tells rpm to only 'freshen' those packages for which there's an older version on your system. The -U switch will update a package if there's an older version on your system _or_ install a new package if there's no older version on your system. That's why -Fvh does not return any errors, while -Uvh does. Rpm -Uvh tries to install php-pgsql, but fails because you don't have postgresql installed on your system, but you don't need it anyway. Looks like the install went ok. Did you encounter any other problems?

[Ruusvuu]

cannot load MySQL extension,
please check PHP Configuration.

This is what phpMyAdmin returns

I edited php.ini thus:

extension_dir = ./ --> extension_dir = /usr/lib/php4

The problem might lie in the fact that I incorrectly upgraded php from 4.0.6 to 4.1.2
and, therefore, may have hph installed in the wrong place, which means I may have edited the wrong php.ini file.

I'm not giving up on this!

The primary domain on this server is www.xend.net and is colo'd at Deru Internet in Arizona.

[Ruusvuu]

Fatal error: Call to undefined function: mysql_connect() in /home/e-smith/files/primary/html/advt/common.php on line 7

Does this look like my PHP 4.1.2 doesn't even know what mysql is?!

[Dan Brown]

Yes, that's what it looks like.  Make sure php-mysql is installed (with rpm -q php-mysql).  If it is, take a look in /etc/php.ini.  The extension_dir setting you mentioned above is one thing that needs to be correct (and /usr/lib/php4 is the correct value); also make sure that you have a line that says "extension=mysql.so", and that that line isn't commented out.

[Ruusvuu]

[root@xend php412]# rpm -ivh php-mysql-4.1.2-2es.i386.rpm
Preparing...                ########################################### [100%]
package php-mysql-4.1.2-2es is already installed
[root@xend php412]# rpm -e php-mysql-4.1.2-2es.i386.rpm
error: package php-mysql-4.1.2-2es.i386.rpm is not installed
[root@xend php412]#

Wow!  First it's already installed and two seconds later it's not!
Maybe I just understand the rpm syntaqx well enough - and I admin I don't know as much as I'd like.

Thanks for all help.
We'll get this thing!

[Terry Brummell]

When uninstalling a rpm you don't specify the version number.

rpm -e php-mysql

(or something like that)

[Ruusvuu]

OK!

I didn't need to reinstall or uninstall anything.
Thanks to Dan Brown, simply typing in the directive:

extension-mysql.so

did the trick

What puzzles me is that php.ini says the mysql is included by default or something like that and doesn't need the extension...

Oh, well

Thanks for everyone's input.
I'm so stoked!

[Ruusvuu]

Now back to the original problem - IMP(Horde, I think) is Snafu'd
login to https://xend.net/webmail and this is the first thing you'll see:

Warning: Use of undefined constant SORTARRIVAL - assumed 'SORTARRIVAL' in /home/httpd/html/horde/imp/config/prefs.php on line 233

Warning: Use of undefined constant SORTARRIVAL - assumed 'SORTARRIVAL' in /home/httpd/html/horde/imp/config/prefs.php on line 237

Warning: Use of undefined constant SORTDATE - assumed 'SORTDATE' in /home/httpd/html/horde/imp/config/prefs.php on line 238

Warning: Use of undefined constant SORTFROM - assumed 'SORTFROM' in /home/httpd/html/horde/imp/config/prefs.php on line 239

Warning: Use of undefined constant SORTSUBJECT - assumed 'SORTSUBJECT' in /home/httpd/html/horde/imp/config/prefs.php on line 240

Warning: Use of undefined constant SORTSIZE - assumed 'SORTSIZE' in /home/httpd/html/horde/imp/config/prefs.php on line 241

Any ideas?

Thanks

[Dan Brown]

Short answer: no.  However, it sounds like something with the config files.  Did you follow all of my howto, including installing dcb-e-smith-{horde|imp|turba}?

[Ruusvuu]

Dan,

I followed the howto to the letter - after the fact - if you recall, I installed php4.1.2
as an rpm before all this happened because some program I was installing needed mcrypt.  I couldn't install mcrypt due to some missing deps.

I admit I jumped the gun on this whole thing, but I'm certain there's a way to fix it without reinstalling SME 5.1.2, which I love, BTW.

Thanks

[Ruusvuu]

What is the default root password for mysql?

Anyone?

[Dan Brown]

I wrote this to answer a slightly different question, but the answer to your question is also there:

http://www.familybrown.org/howtos/mysql-password-howto.html

[Terry Brummell]

There is no "default" password.  A 70some character password is randomly generated at time of install.  You can see this password by going to the hidden file in your root directory called ".my.cnf"  (pico .my.cnf while in the root folder).
Hope it helps.

Terry

[Ruusvuu]

You know since this happened I've read all the posts about not changing your mysql password, but I wanted to install phpMyAdmin and didn't know about the how-to that was written for it.  I still don't know how to find out the password for mysql on a new install.

I did know that I could launch mysql with just that command - mysql - as root.

The problem was that I needed to know the password so I could install phpMyAdmin using http authentication.

Bottom line:  I changed the mysql root password.  My bad.  Now I know.
Question:  Is the password in .my.cnf unencrypted?
If so I will simply restore it, copy and paste into my http authentication dialog and save it.

Could it be that easy?

[Dan Brown]

No, the password is not encrypted--it's just a really long random string.

[Ruusvuu]

ALL IS WELL!

I 'Upgraded' my server i.e. restored the defaults without erasing everything on it.

Thanks to everyone who helped.

Richard aka Ruusvuu