Anyone here played with PhpMyAdmin?

[tallbloke]

I'm having problems getting it to connect to the MySql database on my webserver.
Tried runing the config script with some sensible looking prameters but no joy.

Any tips?

[ErnestM]

What flavour of MySQL? Which version of PHPMyAdmin? The reason that I ask is that over the years there have been some changes in the way that MySQL clients (especially PHP based clients) encrypt the password for delivery to MySQL. There is a setting in your MySQL configuration that you can use to allow "legacy" passwords. You may want to try that.

ErnestM

[Plotloss]

Is the webserver local or remote?

If its local, ditch the idea of phpMyAdmin and use sqlYog instead...

[tallbloke]

It's remote, and wierdly enough, I've discovered it works fine using Firefox, but not internet exploder. What a surprise.

I'm using config auth with plain text passwords, and relying on .htaccess directory passwording on the webserver to secure it. I gather i.e. has problems with cookie auth too...

server spec as follows:

FreeBSD 4.10-STABLE FreeBSD 4.10-STABLE #0: Thu Dec i386
Database Version: 3.23.54-log
PHP Version: 4.4.1
Web Server: Apache/1.3.33 (Unix)
WebServer to PHP interface: cgi
Mambo Version: Mambo 4.5.4 Stable [ Sani ] 26-May-2006 10:00 GMT
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
MySQL - 3.23.54-log
phpMyAdmin - 2.8.1


While I'm on the scrounge for help and info, anyone played with mamboserver or Joomla?
]

Edited by tallbloke on Friday 16th June 18:30

[ErnestM]

The only thing that jumps right out at me is that the MySQL version appears to be a bit long in the tooth...

ErnestM

[tallbloke]

Documentation seems to be saying anything post 3.23.x should be fine.

Oh well, it works, so it ain't all bad.

[SlidingSideways]

tallbloke said:

While I'm on the scrounge for help and info, anyone played with mamboserver or Joomla?

Had a bit of a look and a play. It's looking the likeley candidate to use for our company intranet that I've been tasked with writing. What do you reckon to it so far?

[Plotloss]

Played with both Mambo and Joomla, very impressive they are too.

Not an ideal for all types of website but as portal type sites go its pretty hard to beat.

Absolutely smashes phpnuke and dotnetnuke out of the water.

[tallbloke]

SlidingSideways said:

tallbloke said:

While I'm on the scrounge for help and info, anyone played with mamboserver or Joomla?

Had a bit of a look and a play. It's looking the likeley candidate to use for our company intranet that I've been tasked with writing. What do you reckon to it so far?

Looks nice for running an updateable website with good plugins for mailing lists, newsletters, forum etc. I want to know how easy it is to create scripts to extract and display data from the MySql database which has been imported in by other means.

The community builder plugin is what you want for an intranet for it's advanced profile features.

[Plotloss]

tallbloke said:

SlidingSideways said:

tallbloke said:

While I'm on the scrounge for help and info, anyone played with mamboserver or Joomla?

Had a bit of a look and a play. It's looking the likeley candidate to use for our company intranet that I've been tasked with writing. What do you reckon to it so far?

Looks nice for running an updateable website with good plugins for mailing lists, newsletters, forum etc. I want to know how easy it is to create scripts to extract and display data from the MySql database which has been imported in by other means.

The community builder plugin is what you want for an intranet for it's advanced profile features.

You can embed your own webpages into the Mambo/Joomla framework no worries, one of the default install pages is a 'foreign' page.

[tallbloke]

Plotloss said:

tallbloke said:

Looks nice for running an updateable website with good plugins for mailing lists, newsletters, forum etc. I want to know how easy it is to create scripts to extract and display data from the MySql database which has been imported in by other means.

The community builder plugin is what you want for an intranet for it's advanced profile features.

You can embed your own webpages into the Mambo/Joomla framework no worries, one of the default install pages is a 'foreign' page.

Yep, the GPL license page is a demo of the way you can set up static html pages and link to them. What I'm after is an extension to the content managemnt which will allow you to set up sql queries and use php to dynamically generate a page with info from the d'base and then build forms for the front end user to be able to run those queries from pick and poke menus.

[Plotloss]

You can embed PHP in those too, I do it...

I have a database outside Joomla and a foreign page which works like any other php page.

The access is controlled via Joomla so I can allow some users to my php page and others dont get the navigation.

[jamieboy]

We're just starting to look at a CMS, so this is all interesting. Because most of our other work is ASP or VB, I've been more inclined toward dotnetnuke than Mambo, which are the only two I've tried so far.

What is there about Mambo that makes it better than dotnetnuke? Bear in mind I've only spent about a day playing with each of them so far.

We're also investigating a retail CMS - they all seem pretty dear, but we'd rather pay for something good than use a less-good one just because it's free. Anyone got experience or recommendations?

[Plotloss]

I personally found dotnetnuke massively resource hungry (not so much a concern in a corporate environment I guess) and unintuitive in comparison.

There just seems to be something more flexible and friendly about Joomla.

[tallbloke]

There's a guy on PH who sells tools who uses a free retail system which is supposed to be great.

Ah here you go:

www.oscommerce.com/

[Plotloss]

oscommerce is widely used but I think Mamboshop does just as well, with the benefits of mambo as a whole added in.

[tallbloke]

Plotloss said:

I personally found dotnetnuke massively resource hungry (not so much a concern in a corporate environment I guess) and unintuitive in comparison.

There just seems to be something more flexible and friendly about Joomla.

Apparently, mambo 4.6 is a lot less resouce hungry then earlier mambo versions and Joomla. Haven't been able to test it yet as dreamweavers built in ftp program is having trouble with the depth of the directory tree in the mambots folder.

Any recommendations for a good cheap or free standalone ftp proggy?

[tallbloke]

Plotloss said:

oscommerce is widely used but I think Mamboshop does just as well, with the benefits of mambo as a whole added in.

:nuff said.

[jamieboy]

tallbloke said:

There's a guy on PH who sells tools who uses a free retail system which is supposed to be great.

Cheers, but I guess I phrased that badly - when I said 'retail CMS' I meant a bought-and-paid-for one as opposed to a free one, not an e-commerce system. If you see what I mean.

Thanks anyway though, never know when it might be useful.

[Plotloss]

tallbloke said:

Plotloss said:

I personally found dotnetnuke massively resource hungry (not so much a concern in a corporate environment I guess) and unintuitive in comparison.

There just seems to be something more flexible and friendly about Joomla.

Apparently, mambo 4.6 is a lot less resouce hungry then earlier mambo versions and Joomla. Haven't been able to test it yet as dreamweavers built in ftp program is having trouble with the depth of the directory tree in the mambots folder.

Any recommendations for a good cheap or free standalone ftp proggy?

Filezilla or SmartFTP