A-conman Mysql Port Here!
 

I'm not sure if anyone has done this and made it public yet.

But I managed to port over the A-Conman database shit to MySQL (w/ a little help from Brujah).

Everything is here in this zip: BOOYOW!

I can't help you with the install, you're on your own for that part. I hope someone can use it :)

GOOD LUCK!

yes a readme file would be helpful

http://sourceforge.net/projects/a-conman

I don't think they included any readme docs when they went open source... but they'll charge you $200 to set it up :)

So anyone tried it ?

Cool.

Will anyone be supporting a MySQL branch?

Opensource? I thought that was a commercial script?

Used to be commercial.
Opensource now.

I'll check it out if it's free. :)

Cool.

Will anyone be supporting a MySQL branch?

Just what Groovy was looking for.. ( i think )

is it hard to install for a noob like me ;)????

n00bz

Speaking of which, you hardcoded the database host/user/pass into sql.php and there was an error in common.inc that was causing the script to fail every time because it couldn't load cm_db.inc. I changed the copy I downloaded so sql.php takes values from cm_db.inc for creating the tables and I took care of the problem with loading cm_db.inc in common.inc but it still doesn't work. For some reason, $_SERVER['PHP_AUTH_USER'] is always equal to null so the script always rejects my authentication because it has nothing to check against the users table. I know this probably has nothing to do with your port but I am hoping someone else might have a solution.

SpaceAce

Yes but I can't remember what I done to it now. I think there's 2 or 3 places it chucks that error so in the end I simply added an if (blahblah = NULL) where the error occurred. Hope that makes sense because I don't think I commented where I made the change which would make it tough to find again.

We might be thinking of two different problems. When the authentication box pops up and I put in my username, for some reason the script always thinks my username was left blank. So, it doesn't even try to check my password against the "users" table because it thinks I didn't enter a username. The script always quits at this point

if ((!isset($_SERVER[PHP_AUTH_USER])) || ($_SERVER[PHP_AUTH_USER] hahahaha "")){

because $_SERVER[PHP_AUTH_USER] equals null even though I typed in a username when the auth box popped up in my browser. Because it thinks there is no username, it never even gets to this part:

$pass_query = "SELECT rtrim(password),access,email FROM users WHERE userid='".$_SERVER[PHP_AUTH_USER]."'";

For some reason, $_SERVER[PHP_AUTH_USER] never has anything in it.

SpaceAce

Wow, totally missed this thread. I love open source, they're the best.

Definately going to look into it.

Now I'm going to have to looksee. I really can't even remember the details only that the problem was similar. The script was getting a NULL when it expected something. I'll see if I can find it so I know what the hell I'm talking about (there's a first time for everything :) )

WTF - can't even find it now. Oh well. I'll just shut-up and go sit back in the corner :)

The code is in common.inc, near the top. Just search for "$_SERVER" in the file.

SpaceAce

Sorry - should have clarified. Can't find the bit I'm babbling on about was what I meant. Oh well.

I think senality is setting in early.

What version of PHP ?

Note: $_SERVER was introduced in 4.1.0. In earlier versions, use $HTTP_SERVER_VARS.

4.3.2 compiled fresh yesterday.

SpaceAce

Anyone have this working?

Not me, although I didn't spend much time on it. I can't figure out why the script always thinks I didn't enter a username into the auth box.

SpaceAce

The original OS version is for postgresql and it's home page is here http://sourceforge.org/projects/a-conman/

You can also check out the http://a-conman.com site for the fast overview.

I'm running the postgresql version and am very happy with it.

:thumbsup

Be sure that you haven't enabled authorization already in the directory, either in your config files or .htaccess. If you have, I believe only _SERVER['REMOTE_USER'] is available to the PHP program. That's what I get from http://www.zend.com/manual/features.http-auth.php anyway.

I thought along those lines, too. It's actually on a fresh domain with nothing else on it, so no .htaccess or other auth conflicts.

SpaceAce

I don't have the login problem at all, Just have no idea how to add photos? I can add one model pic at time without a problem? Nor do I know how to actually get info out of it.

Try the basic script that's given on the link I gave above (Ex. 16-1) and see if that works as it's supposed to. Sometimes narrowing a program down to just the problem area will reveal what's going wrong.

I had already narrowed it down to failure in setting the PHP_AUTH variables and the test script backs that up. For some reason, the AUTH variables are not being set. The code in the sample script is basically identical to the A-Conman code.

From what I understand, the AUTH variables won't be set if you have already logged in using basic HTTP authorization, which I have not. There is no password protection in that folder. Just to be safe, I tried to display the REMOTE_USER variable and got null. I don't know what's up.

SpaceAce

login is working for me.. no problem with that. However after doing the setup and testing the stuff (all results OK) it still keeps on telling me:
Warning! One or more ConMan parameters are not set.
Fix the options before using ConMan further.
What's missing is always the default thumb height. I fill it in again (even check in the MySQL table if it's there, OK) and test the settings... all cool. But when going back to the main menu see above.. error

found the mistake

change in common.inc line 83
$default_thumb_height = $records[20];
to
$default_thumb_height = $records[10];

Let's make sure we're not overlooking something obvious here: Have you successfully implemented htaccess authorization within this directory before? If not, try do so now with a .htaccess that requires a valid-user and points to a .htpasswd file.

ahhm... just a lil hint. I had the same problems. But I didn't mess around with the code and just entered the required pathes in the mysql table 'globals'

For all those having problems with the PHP_AUTH_USER not being set run the function phpinfo(). If you see Server API set as "ISAPI" you will not be able to get the PHP_AUTH_USER variable. Below find an excerpt from http://www.zend.com/manual/features.http-auth.php

-------------------------------------

Also note that this does not work using Microsoft's IIS server and the CGI version of PHP due to a limitation of IIS. If you're using the IIS module (ISAPI), you may use the HTTP_AUTHORIZATION variable for example: list($user, $pw) = explode(':', base64_decode(substr($_SERVER['HTTP_AUTHORIZATION'], 6)));

-------------------------------------


Regards,
Kevin

I have it working fine too.
Found that common.inc error myself already earlier, BUT I cannot get the images to be made into thumbs. ImageMagick is installed fine and everything.

Anybody got this working without the Postgresql version? So the version posted here?

This is a dedicated server with over 100 of my domains on it. I've never had the slightest problem implementing any kind of password protection on any of the domains, before, so I cannot imagine that is the problem.

SpaceAce

Hm, this is definitely not the problem for me. I wouldn't operate my sites on a Microsoft server if they paid me.

SpaceAce

http://sourceforge.net/forum/forum.p...orum_id=256457

thanks .. however that is old news.


I did say: "ImageMagick is installed fine and everything" :winkwink: