joomla app-vault

[Waylander]

hi all:)

its me or this release (1.04) dont write any users in the db?

after install via psa ill login but get only a... cant login, no admin defined
(sure, in psa ive an admin and an editor defined)
a look in the db show me... zero users.

psa7.5.4 on rh9, mysql 4.0.24, php 4.4.1

anyone have a hint? thanks

way

[Waylander]

sorry for the pushup

real noone use this app-vault?

thanks

way

[scott]

Is this on a new install?

[Waylander]

hi scott,

yes, ive removed the 1.03 then installed the 1.04 (via yum)

all looks fine. but when i install a joomla in a new domain (docroot without any other files) and a new database (both via the app-vault installer)... after the install no users show up in the db.

and ive seen another prob too... the install chmods all files to 777???

thanks.

way

[mdzigurski]

all looks fine. but when i install a joomla in a new domain (docroot without any other files) and a new database (both via the app-vault installer)... after the install no users show up in the db.

and ive seen another prob too... the install chmods all files to 777???

I have exactly the same problem.

[scott]

I'll refer this one to pascal to debug then, hes the guy that created the package

[rspurlock]

Did this issue ever get updated? I'm having the same problems. No admin users...nothing.

[rembrandt]

Hello all,

After update MySQL to v 4.1.15 i´ve got the same problem with all newly installed applications: no connection to MySQL: user/pasword are 'incorrect' is the message i get.

It doens't matter what applications i test, all applications i´ve tested (Joomla Wordpress) have the same problem... so at this point no new db_users/passwords are accepted.

However when i ssh to the server and the connect to MySQL with the same user/passwd i can log in without any problems. So there definatly must be something wrong here.


Just tested: When using an exsisting database, with an exsisting username and password, there are no problems to connect to MySQL, so only new usernames/passwords aren´t accepted. I´ve checked the DB Users and they were there... so my best guess is that somehow passwords aren´t saved.

Best regards

[scott]

did you set old_passwords=1 in my.cnf?

[rembrandt]

Update: I´ve just checked and the new usernames/passwords are stored, however, somehow they aren´t accepted. So maybe there is something the matter with the way the they are stored (not the format, that´s still 'plain').

What i mean is that someho their 'relation' isn´t recognized anymore.

[rembrandt]

did you set old_passwords=1 in my.cnf?

Not yet, i´ll do that immediatly.

Maybe there is another (not MySQL related) issue. I´ve just noticed there were two hotfixes installed at approximatly the same time:

hotfix75051115.01
hotfix75051209.16

It mught very well be that one (or both) of these 'fixes' screwed things up with usernames and passwords.... it wouldn´t be a first .....

Best regards.

[rembrandt]

I´ve just set:

old_passwords=1

in my.cnf, restarted mysql and tried again, it looks like it done the trick. Pretty weird.. but it works

[ChipMonk]

dear all;

this thread is for JOOMLA problem, mySQL problem is totally differnt.

please do not hijack the thread, and let the joomla thingie get solved.

[rspurlock]

I got the impression that that post said he got Joomla working on his site, but I've tried it on both MySQL 4.0 and 4.1 sites and there are no entries in the users table at all. I even tried copying some from an existing site and it wouldn't work for me.

Has anyone been able to use the app version of Joomla and go in behind and fix it?

Want to share your commands to do so?

TIA

[rspurlock]

Courtesy of Robin at www.robink.nl here are the commands to run to fix the admin login after you install via the app vault:

INSERT INTO `jos_core_acl_aro` VALUES (10, 'users', '62', 0, 'Administrator', 0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, '', 10);
INSERT INTO `jos_users` VALUES (62, 'Administrator', 'admin', 'yourmail@mail.com', '21232f297a57a5a743894a0e4a801fc3', 'Super Administrator', 0, 1, 25, '2005-03-16 19:16:51', '2005-05-10 19:59:33', '', '');

Or course you can change the e-mail address, MD5 hash password and even dates if you choose.

Here's the link to Robin's fix post:

http://forum.mamboserver.com/showthread.php?t=43404