Search found 16 matches

by Marty
Fri Jun 16, 2006 4:59 pm
Forum: MySQL
Topic: MySQL logfile questions
Replies: 1
Views: 5789

MySQL logfile questions

I've been looking at my MYSQL_ROOT:[MYSQL_SERVER]MYSQLD.LOG files and have noticed that most of them report that the DB didn't shutdown correctly and are chock full of read error messages...

...logfile snippet...
$ mysqld --default-storage-engine=InnoDB --innodb-safe-binlog --ansi --myisam-
060524 ...
by Marty
Tue Jun 06, 2006 4:48 am
Forum: General
Topic: Unzipping downloaded distributions
Replies: 4
Views: 10587

One additional tip for using jar to unzip dists

The trick to getting jar working right is to make sure the java$filename_controls logical is set correctly. Out of the box that logical is set to -1, which means it will do the underscore for multiple dots translation, and a host of other fun file tricks. By defining the logical like so...

$ def ...
by Marty
Thu May 18, 2006 4:30 pm
Forum: Joomla!
Topic: Installation
Replies: 17
Views: 38206

Installation tips if you're having admin login problems

After installing I was having a hard time getting logged into the admin account. Seems that all of the joomla tables use the MyISAM engine, which has been reported to have problems on VMS. The jos_users table, which keeps the usernames, passwords, etc, for joomla in my installation, was getting ...
by Marty
Thu May 18, 2006 4:11 pm
Forum: Joomla!
Topic: Can't login as admin
Replies: 7
Views: 12718

Fingers crossed

Seems the user database kept getting corrupted, so I coulndn't log in as admin because the admin entry had disappeared.

After the initial install I renamed the installation directory to installation_removed. This made it easier for me to do reinstalls without all the fuss and muss of unjarring ...
by Marty
Wed May 17, 2006 11:26 pm
Forum: phpMyAdmin
Topic: cannot login on first access.
Replies: 10
Views: 16941

Add a line to the config file.

By putting this in the config^.inc.php file

Code: Select all

$cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
and restarting SWB (the browser, not the webserver), it seems to work now.

SWB 1.7-11, MySQL 4.1.14, phpMyAdmin 2.8.0.4
by Marty
Wed May 17, 2006 4:10 pm
Forum: MySQL
Topic: #1030 - Got error 127 from storage engine
Replies: 7
Views: 13674

I'd be interested in seeing how your friend got this to work. By default Joomla uses MyISAM which may be why it keeps crapping out. Did your friend do any changes to the install, or did he change the db engine for it?

Curious,
Marty
by Marty
Fri May 12, 2006 4:46 pm
Forum: MySQL
Topic: #1030 - Got error 127 from storage engine
Replies: 7
Views: 13674

Well, something is not right...

MySQL 4.1.4, VMS 7.3-2 and Joomla users keep disappearing. Since I'm the only one using this on my test machine, it says to me that something is wrong with MySQL.

mysql> use joomla;
Database changed
mysql> select username,password,gid from jos_users;

ERROR 1030 (HY000): Got error 127 ...
by Marty
Fri May 12, 2006 4:37 pm
Forum: Joomla!
Topic: Can't login as admin
Replies: 7
Views: 12718

Yep, using the "latest" MySQL I can find

i.e. JFP AXPVMS MYSQL V4.1-14

I tried to access the URL mentioned in the post "www.pi-net" but it timed out.
by Marty
Fri May 05, 2006 5:12 pm
Forum: MySQL
Topic: #1030 - Got error 127 from storage engine
Replies: 7
Views: 13674

MyISAM still a problem with 4.1.14?

Does the MyISAM engine still have corruption problems? It looks like Joomla is set up to use MyISAM, and I've been having problems with table data disappearing.
by Marty
Thu May 04, 2006 9:31 pm
Forum: Joomla!
Topic: Can't login as admin
Replies: 7
Views: 12718

Hmm, not a good fix, but it is working now.

I reinstalled joomla from scratch, and it seems to work now. I think MySQL is getting corrupted somehow, but I can't confirm it, yet.
by Marty
Thu May 04, 2006 8:30 pm
Forum: Joomla!
Topic: Can't login as admin
Replies: 7
Views: 12718

I did 'use joomla'

Check the MySQL statements again.

I did use the joomla database. I then checked the username, password and gid in jos_users. I then set the password to 'joomlatest' using both the regular password function and the old_password function, which came out to the same hashed password result. This ...
by Marty
Wed May 03, 2006 9:17 pm
Forum: Joomla!
Topic: Can't login as admin
Replies: 7
Views: 12718

Can't login as admin

Now that I have Joomla installed, I can't seem to login to the admin account. When I go to http://localhost/joomla/administrator/index.php and fill in admin for the username and joomlatest for the password (the password set during installation), it comes back with

Incorrect Username, Password. Try ...
by Marty
Wed May 03, 2006 8:42 pm
Forum: Joomla!
Topic: Installation
Replies: 17
Views: 38206

UnZip won't work. The trick to getting jar working right.

When I went to start using Joomla I found out that the multi-dot filenames had been mangled by unzip. I tried using the jar program in the Java distribution to unzip/unjar the zip file and got the same result.

Essentially, you'll see an error something like...

Warning: main(/apache$common ...
by Marty
Tue May 02, 2006 8:53 pm
Forum: Joomla!
Topic: Installation
Replies: 17
Views: 38206

Figured it out...at least the first part.

It might be bad form to reply to my own post, but here is how I got the install to work...

$ edit MYSQL_ROOT:[VMS]my.cnf

and added these two lines in the [mysqld] block

#Use old password encryption method (needed for 4.0 and older clients).
old_password=1

This has to be ...
by Marty
Tue May 02, 2006 7:51 pm
Forum: Joomla!
Topic: Installation
Replies: 17
Views: 38206

The password and username provided are incorrect

Downloaded Joomla 1.0.8 from joomla.org to pkg_disk:[ecos] and did the following...

$ cre/dir apache$common:[joomla]
$ set def apache$common:[joomla]
$ unzip "-V" PKG_DISK:[ECOS]JOOMLA_1_0_8-STABLE-FULL_PACKAGE.ZIP;1
$ edit apache$common:[conf]httpd ...