A-conman Mysql Port Here!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tical
    Confirmed User
    • Feb 2002
    • 6504

    #1

    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!
    112.020.756
  • playa
    Confirmed User
    • Feb 2001
    • 6432

    #2
    yes a readme file would be helpful

    Comment

    • tical
      Confirmed User
      • Feb 2002
      • 6504

      #3
      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
      112.020.756

      Comment

      • Brujah
        Beer Money Baron
        • Jan 2001
        • 22157

        #4
        So anyone tried it ?

        Comment

        • PHmike
          Registered User
          • Nov 2002
          • 71

          #5
          Cool.

          Will anyone be supporting a MySQL branch?
          I am hiring.

          Comment

          • Mr.Fiction
            Confirmed User
            • Feb 2002
            • 9484

            #6
            Opensource? I thought that was a commercial script?
            Don't be lazy, protect free speech: ACLU | Free Speech Coalition | EFF | IMPA

            Comment

            • Brujah
              Beer Money Baron
              • Jan 2001
              • 22157

              #7
              Used to be commercial.
              Opensource now.

              Comment

              • Mr.Fiction
                Confirmed User
                • Feb 2002
                • 9484

                #8
                Originally posted by Brujah
                Used to be commercial.
                Opensource now.
                I'll check it out if it's free.
                Don't be lazy, protect free speech: ACLU | Free Speech Coalition | EFF | IMPA

                Comment

                • PHmike
                  Registered User
                  • Nov 2002
                  • 71

                  #9
                  Cool.

                  Will anyone be supporting a MySQL branch?
                  I am hiring.

                  Comment

                  • Brujah
                    Beer Money Baron
                    • Jan 2001
                    • 22157

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

                    Comment

                    • Trax
                      [----------------------]
                      • Aug 2001
                      • 14486

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

                      Comment

                      • tical
                        Confirmed User
                        • Feb 2002
                        • 6504

                        #12
                        n00bz
                        112.020.756

                        Comment

                        • SpaceAce
                          Confirmed User
                          • Jul 2002
                          • 6493

                          #13
                          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

                          Comment

                          • Tipsy
                            Confirmed User
                            • Jul 2001
                            • 6989

                            #14
                            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.
                            Ignorance is never bliss.

                            Comment

                            • SpaceAce
                              Confirmed User
                              • Jul 2002
                              • 6493

                              #15
                              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

                              Comment

                              • Naughty
                                Confirmed User
                                • Jul 2001
                                • 6487

                                #16
                                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

                                Comment

                                • Tipsy
                                  Confirmed User
                                  • Jul 2001
                                  • 6989

                                  #17
                                  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 )
                                  Ignorance is never bliss.

                                  Comment

                                  • Tipsy
                                    Confirmed User
                                    • Jul 2001
                                    • 6989

                                    #18
                                    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.

                                    Comment

                                    • SpaceAce
                                      Confirmed User
                                      • Jul 2002
                                      • 6493

                                      #19
                                      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

                                      Comment

                                      • Tipsy
                                        Confirmed User
                                        • Jul 2001
                                        • 6989

                                        #20
                                        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.
                                        Ignorance is never bliss.

                                        Comment

                                        • Brujah
                                          Beer Money Baron
                                          • Jan 2001
                                          • 22157

                                          #21
                                          What version of PHP ?

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

                                          Comment

                                          • SpaceAce
                                            Confirmed User
                                            • Jul 2002
                                            • 6493

                                            #22
                                            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

                                            Comment

                                            • 4Pics
                                              Confirmed User
                                              • Dec 2001
                                              • 7952

                                              #23
                                              Anyone have this working?

                                              Comment

                                              • SpaceAce
                                                Confirmed User
                                                • Jul 2002
                                                • 6493

                                                #24
                                                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

                                                Comment

                                                • Snowone
                                                  Confirmed User
                                                  • Jul 2002
                                                  • 183

                                                  #25
                                                  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.

                                                  <a href=http://zfuck.com/>Free Host</a> | <a href=http://top-porn-links.com/>Niched Top List</a>

                                                  Comment

                                                  • fiveyes
                                                    Confirmed User
                                                    • Aug 2001
                                                    • 1680

                                                    #26
                                                    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.
                                                    <CENTER><A HREF="http://www.hot-off-bourbon.com/" target="_blank"><IMG SRC="http://www.hot-off-bourbon.com/images/hob-logosmall.jpg" border="0"></A>

                                                    <FONT face="Comic Sans MS" SIZE="-1"><I>Mardi Gras, Spring Break, Wet-T, Night Club Action, UpSkirt, Oil Wrestling, Voyeur</I></FONT></CENTER>

                                                    Comment

                                                    • SpaceAce
                                                      Confirmed User
                                                      • Jul 2002
                                                      • 6493

                                                      #27
                                                      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

                                                      Comment

                                                      • 4Pics
                                                        Confirmed User
                                                        • Dec 2001
                                                        • 7952

                                                        #28
                                                        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.

                                                        Comment

                                                        • fiveyes
                                                          Confirmed User
                                                          • Aug 2001
                                                          • 1680

                                                          #29
                                                          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.
                                                          <CENTER><A HREF="http://www.hot-off-bourbon.com/" target="_blank"><IMG SRC="http://www.hot-off-bourbon.com/images/hob-logosmall.jpg" border="0"></A>

                                                          <FONT face="Comic Sans MS" SIZE="-1"><I>Mardi Gras, Spring Break, Wet-T, Night Club Action, UpSkirt, Oil Wrestling, Voyeur</I></FONT></CENTER>

                                                          Comment

                                                          • SpaceAce
                                                            Confirmed User
                                                            • Jul 2002
                                                            • 6493

                                                            #30
                                                            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

                                                            Comment

                                                            • Stramm
                                                              Confirmed User
                                                              • Jan 2003
                                                              • 342

                                                              #31
                                                              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

                                                              Comment

                                                              • Stramm
                                                                Confirmed User
                                                                • Jan 2003
                                                                • 342

                                                                #32
                                                                found the mistake

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

                                                                Comment

                                                                • fiveyes
                                                                  Confirmed User
                                                                  • Aug 2001
                                                                  • 1680

                                                                  #33
                                                                  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.
                                                                  <CENTER><A HREF="http://www.hot-off-bourbon.com/" target="_blank"><IMG SRC="http://www.hot-off-bourbon.com/images/hob-logosmall.jpg" border="0"></A>

                                                                  <FONT face="Comic Sans MS" SIZE="-1"><I>Mardi Gras, Spring Break, Wet-T, Night Club Action, UpSkirt, Oil Wrestling, Voyeur</I></FONT></CENTER>

                                                                  Comment

                                                                  • Stramm
                                                                    Confirmed User
                                                                    • Jan 2003
                                                                    • 342

                                                                    #34
                                                                    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'

                                                                    Comment

                                                                    • KevinX
                                                                      Registered User
                                                                      • Jun 2003
                                                                      • 23

                                                                      #35
                                                                      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

                                                                      Comment

                                                                      • Naughty
                                                                        Confirmed User
                                                                        • Jul 2001
                                                                        • 6487

                                                                        #36
                                                                        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

                                                                        Comment

                                                                        • SpaceAce
                                                                          Confirmed User
                                                                          • Jul 2002
                                                                          • 6493

                                                                          #37
                                                                          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

                                                                          Comment

                                                                          • SpaceAce
                                                                            Confirmed User
                                                                            • Jul 2002
                                                                            • 6493

                                                                            #38
                                                                            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

                                                                            Comment

                                                                            • Stramm
                                                                              Confirmed User
                                                                              • Jan 2003
                                                                              • 342

                                                                              #39
                                                                              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

                                                                              Comment

                                                                              • Naughty
                                                                                Confirmed User
                                                                                • Jul 2001
                                                                                • 6487

                                                                                #40
                                                                                thanks .. however that is old news.


                                                                                I did say: "ImageMagick is installed fine and everything"
                                                                                seks.ai for sale - ping me

                                                                                Comment

                                                                                • fiveyes
                                                                                  Confirmed User
                                                                                  • Aug 2001
                                                                                  • 1680

                                                                                  #41
                                                                                  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?
                                                                                  <CENTER><A HREF="http://www.hot-off-bourbon.com/" target="_blank"><IMG SRC="http://www.hot-off-bourbon.com/images/hob-logosmall.jpg" border="0"></A>

                                                                                  <FONT face="Comic Sans MS" SIZE="-1"><I>Mardi Gras, Spring Break, Wet-T, Night Club Action, UpSkirt, Oil Wrestling, Voyeur</I></FONT></CENTER>

                                                                                  Comment

                                                                                  • KevinX
                                                                                    Registered User
                                                                                    • Jun 2003
                                                                                    • 23

                                                                                    #42
                                                                                    SpaceAce,

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

                                                                                    Regards,
                                                                                    Kevin

                                                                                    Comment

                                                                                    • Stramm
                                                                                      Confirmed User
                                                                                      • Jan 2003
                                                                                      • 342

                                                                                      #43
                                                                                      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...

                                                                                      Comment

                                                                                      • Stramm
                                                                                        Confirmed User
                                                                                        • Jan 2003
                                                                                        • 342

                                                                                        #44
                                                                                        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

                                                                                        Comment

                                                                                        • Stramm
                                                                                          Confirmed User
                                                                                          • Jan 2003
                                                                                          • 342

                                                                                          #45
                                                                                          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.

                                                                                          Comment

                                                                                          • Brujah
                                                                                            Beer Money Baron
                                                                                            • Jan 2001
                                                                                            • 22157

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

                                                                                            Comment

                                                                                            • lEricPl
                                                                                              Confirmed User
                                                                                              • Dec 2002
                                                                                              • 1062

                                                                                              #47
                                                                                              This is lame.



                                                                                              You get what you pay for.

                                                                                              Comment

                                                                                              • Stramm
                                                                                                Confirmed User
                                                                                                • Jan 2003
                                                                                                • 342

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

                                                                                                anyways, thanks for answering

                                                                                                Comment

                                                                                                • Naughty
                                                                                                  Confirmed User
                                                                                                  • Jul 2001
                                                                                                  • 6487

                                                                                                  #49
                                                                                                  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.
                                                                                                  seks.ai for sale - ping me

                                                                                                  Comment

                                                                                                  • Stramm
                                                                                                    Confirmed User
                                                                                                    • Jan 2003
                                                                                                    • 342

                                                                                                    #50
                                                                                                    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

                                                                                                    Comment

                                                                                                    Working...