A-conman Mysql Port Here! - GoFuckYourself.com

tical · 05-29-2003, 08:58 PM

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!

playa · 05-29-2003, 09:06 PM

yes a readme file would be helpful

tical · 05-29-2003, 09:14 PM

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

Brujah · 06-06-2003, 06:32 PM

So anyone tried it ?

PHmike · 06-06-2003, 07:41 PM

Cool.

Will anyone be supporting a MySQL branch?

Mr.Fiction · 06-06-2003, 07:49 PM

Opensource? I thought that was a commercial script?

Brujah · 06-06-2003, 07:56 PM

Used to be commercial.
Opensource now.

Mr.Fiction · 06-06-2003, 07:57 PM

Quote:

Originally posted by Brujah
Used to be commercial.
Opensource now.

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

PHmike · 06-06-2003, 08:33 PM

Cool.

Will anyone be supporting a MySQL branch?

Brujah · 06-07-2003, 09:53 AM

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

Trax · 06-07-2003, 09:59 AM

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

tical · 06-08-2003, 03:47 AM

n00bz

SpaceAce · 06-08-2003, 03:58 AM

Quote:

Originally posted by tical
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

Tipsy · 06-08-2003, 04:02 AM

Quote:

Originally posted by SpaceAce

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.

SpaceAce · 06-08-2003, 04:07 AM

Quote:

Originally posted by Tipsy

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

Naughty · 06-08-2003, 04:12 AM

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

Definately going to look into it.

Tipsy · 06-08-2003, 04:42 AM

Quote:

Originally posted by SpaceAce

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

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

)

Tipsy · 06-08-2003, 04:55 AM

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

SpaceAce · 06-08-2003, 02:45 PM

Quote:

Originally posted by Tipsy
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

Tipsy · 06-08-2003, 03:11 PM

Quote:

Originally posted by SpaceAce

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.

Brujah · 06-08-2003, 03:22 PM

What version of PHP ?

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

SpaceAce · 06-08-2003, 04:59 PM

Quote:

Originally posted by Brujah
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

4Pics · 06-08-2003, 10:42 PM

Anyone have this working?

SpaceAce · 06-08-2003, 10:44 PM

Quote:

Originally posted by 4Pics
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

Snowone · 06-08-2003, 11:30 PM

Quote:

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

Definately going to look into it.

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.

fiveyes · 06-08-2003, 11:45 PM

Quote:

Originally posted by SpaceAce

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

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.

SpaceAce · 06-08-2003, 11:48 PM

Quote:

Originally posted by fiveyes

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

4Pics · 06-09-2003, 12:25 AM

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.

fiveyes · 06-09-2003, 12:33 AM

Quote:

Originally posted by SpaceAce

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

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.

SpaceAce · 06-09-2003, 01:35 AM

Quote:

Originally posted by fiveyes

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

Stramm · 06-09-2003, 02:09 AM

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

Stramm · 06-09-2003, 02:19 AM

found the mistake

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

fiveyes · 06-09-2003, 03:47 AM

Quote:

Originally posted by SpaceAce

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

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.

Stramm · 06-09-2003, 03:57 AM

Quote:

Originally posted by fiveyes

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'

KevinX · 06-09-2003, 04:08 AM

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

Naughty · 06-09-2003, 04:36 AM

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?

SpaceAce · 06-09-2003, 04:41 AM

Quote:

Originally posted by fiveyes

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.

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

SpaceAce · 06-09-2003, 04:42 AM

Quote:

Originally posted by KevinX
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

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

SpaceAce

Stramm · 06-09-2003, 04:59 AM

Quote:

Originally posted by Naughty
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?

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

Naughty · 06-09-2003, 05:16 AM

Quote:

Originally posted by Stramm
http://sourceforge.net/forum/forum.p...orum_id=256457

thanks .. however that is old news.

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

fiveyes · 06-09-2003, 05:31 AM

Quote:

Originally posted by SpaceAce

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

You've stated the problem, $_SERVER['PHP_AUTH_USER'] is not being set. Have you implemented password protection within that directory before?

KevinX · 06-09-2003, 05:57 AM

SpaceAce,

Notice the "and the CGI version of PHP"....

Regards,
Kevin

Stramm · 06-09-2003, 06:35 AM

Quote:

Originally posted by Naughty

thanks .. however that is old news.

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

hmm.. sorry
however I have fixed the db backup mess. If anyone needs it...

Stramm · 06-09-2003, 07:23 AM

Quote:

Originally posted by Naughty

thanks .. however that is old news.

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

can you check that again??? Mine is creating the thumbs but messing up the pathes and therfore doesn't display them

Stramm · 06-10-2003, 12:15 AM

Quote:

Originally posted by tical
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!

Hi Tical, are you and Brujah still working on it? Cause there are still db access errors in the script and it's hard/ impossible to use it as it is now. Unfortunately I found out after I fixed and improved some stuff. So my version has now a thumb crop functionality, you can set thumb quality and the database backup/restore is working.

Brujah · 06-10-2003, 12:35 AM

No, I'm not doing any work on it.

lEricPl · 06-10-2003, 12:39 AM

This is lame.

You get what you pay for.

Stramm · 06-10-2003, 12:42 AM

Quote:

Originally posted by Brujah
No, I'm not doing any work on it.

bad luck

anyways, thanks for answering

Naughty · 06-10-2003, 04:29 AM

Stramm, yes please. The database backup stuff would be nice. I thought it was me why it was not working.

lEricPl , you even familiar with open source? In a few months this program will probably be the best out there, with the help of many of course.

Stramm · 06-10-2003, 04:50 AM

Quote:

Originally posted by Naughty
Stramm, yes please. The database backup stuff would be nice. I thought it was me why it was not working.

stramm[@]whammed.com

05-29-2003, 08:58 PM	#1
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	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!

06-06-2003, 06:32 PM	#4
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	So anyone tried it ? __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

06-06-2003, 07:41 PM	#5
PHmike Registered User Join Date: Nov 2002 Location: NYC Posts: 71	Cool. Will anyone be supporting a MySQL branch? __________________ I am hiring.

06-06-2003, 07:56 PM	#7
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	Used to be commercial. Opensource now. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

06-06-2003, 08:33 PM	#9
PHmike Registered User Join Date: Nov 2002 Location: NYC Posts: 71	Cool. Will anyone be supporting a MySQL branch? __________________ I am hiring.

05-29-2003, 09:06 PM	#2
playa Confirmed User Join Date: Feb 2001 Location: atlanta, GA Posts: 6,432	yes a readme file would be helpful

05-29-2003, 09:14 PM	#3
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	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

06-06-2003, 07:49 PM	#6
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	Opensource? I thought that was a commercial script?

06-07-2003, 09:53 AM	#10
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	Just what Groovy was looking for.. ( i think ) __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

06-07-2003, 09:59 AM	#11
Trax [----------------------] Join Date: Aug 2001 Posts: 14,486	is it hard to install for a noob like me ;)????

06-08-2003, 03:47 AM	#12
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	n00bz __________________ 112.020.756

06-08-2003, 04:12 AM	#16
Naughty Confirmed User Industry Role: Join Date: Jul 2001 Location: Utopia Posts: 6,482	Wow, totally missed this thread. I love open source, they're the best. Definately going to look into it. __________________ seks.ai for sale - ping me

06-08-2003, 04:55 AM	#18
Tipsy Confirmed User Join Date: Jul 2001 Location: See sig Posts: 6,989	WTF - can't even find it now. Oh well. I'll just shut-up and go sit back in the corner __________________ Ignorance is never bliss.

06-08-2003, 03:22 PM	#21
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	What version of PHP ? Note: $_SERVER was introduced in 4.1.0. In earlier versions, use $HTTP_SERVER_VARS. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

06-08-2003, 10:42 PM	#23
4Pics Confirmed User Industry Role: Join Date: Dec 2001 Posts: 7,952	Anyone have this working?

06-09-2003, 12:25 AM	#28
4Pics Confirmed User Industry Role: Join Date: Dec 2001 Posts: 7,952	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.

06-09-2003, 02:09 AM	#31
Stramm Confirmed User Join Date: Jan 2003 Location: NL Posts: 342	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

06-09-2003, 02:19 AM	#32
Stramm Confirmed User Join Date: Jan 2003 Location: NL Posts: 342	found the mistake change in common.inc line 83 $default_thumb_height = $records[20]; to $default_thumb_height = $records[10];

06-09-2003, 04:08 AM	#35
KevinX Registered User Join Date: Jun 2003 Location: Jersey Posts: 23	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

06-09-2003, 04:36 AM	#36
Naughty Confirmed User Industry Role: Join Date: Jul 2001 Location: Utopia Posts: 6,482	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? __________________ seks.ai for sale - ping me

06-09-2003, 05:57 AM	#42
KevinX Registered User Join Date: Jun 2003 Location: Jersey Posts: 23	SpaceAce, Notice the "and the CGI version of PHP".... Regards, Kevin

06-10-2003, 12:35 AM	#46
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	No, I'm not doing any work on it. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

06-10-2003, 12:39 AM	#47
lEricPl Confirmed User Join Date: Dec 2002 Location: FL Posts: 1,062	This is lame. You get what you pay for.

06-10-2003, 04:29 AM	#49
Naughty Confirmed User Industry Role: Join Date: Jul 2001 Location: Utopia Posts: 6,482	Stramm, yes please. The database backup stuff would be nice. I thought it was me why it was not working. lEricPl , you even familiar with open source? In a few months this program will probably be the best out there, with the help of many of course.