Changeset 131

Timestamp:

08/27/07 02:38:18 (3 years ago)

Author:

DmitryChemerik

Message:

Added function of creation a database

Location:

trunk

Files:

• Makefile.in (modified) (2 diffs)
• README (modified) (1 diff)
• README.RUS (added)
• php/install.php (added)
• php/mysqltools.php (modified) (2 diffs)

trunk/Makefile.in

@@ -220 +220 @@
                 rm -f $(datadir)/sams/src; \
         fi
-        -@if test ! -d $(datadir)/sams/data; then \
-                echo "creating $(datadir)/sams/data"; \
-                mkdir $(datadir)/sams/data; \
-        fi
         cp -R php/* $(datadir)/sams/;
         -@if test ! -d $(datadir)/sams/src/lffolder_4_z3_local.php; then \
@@ -241 +237 @@
         rm -f $(datadir)/sams/data/*;
         cp -R doc $(datadir)/sams/;
+        cp ./mysql/sams_db.sql $(datadir)/sams/data;
+        cp ./mysql/squid_db.sql $(datadir)/sams/data;
         -@if test ! -d $(HTTPDPATH)/sams; then \
                 echo "creating symlink to sams directory"; \

trunk/README

@@ -1 @@
-VERSION 2006 06 07
+################################################################################
+#
+# SAMS (Squid Account Management System)
+#
+# Copyleft 2007 Dmitry Chemerik
+# Web: http://sams.perm.ru
+#
+# This code is open source and may be copied and modified as long as the source
+# code is always made freely available.
+# Please refer to the General Public Licence http://www.gnu.org/ or Licence.txt
+################################################################################
 
-SAMS 1.0
+How to setup SAMS ?
 
-ðÏÖÁÌÕÊÓÔÁ, ÏÔÐÒÁ×ÌÑÊÔÅ Ó×ÏÉ ×ÏÐÒÏÓÙ/ËÏÍÍÅÎÔÁÒÉÉ/ÐÏÖÅÌÁÎÉÑ ÎÁ chemerik@mail.ru 
+SAMS needs the following components:
+- MySQL version 3.23 or higher
+- libmysql-devel 
+- Apache version 1.3.33 or higher / Apache version 2.0.X or higher
+- Apache Mod_php
+- libpcre, libpcre-devel
+- libgd, libgd-devel
+- PHP 4.3.2 or higher
+- Zlib support for PHP.
+- php-mysql: MySQL support for PHP.
+- php-gd: GD support for PHP.
+- Zlib support for PHP.
 
-üÔÁ ÄÉÒÅËÔÏÒÉÑ ÓÏÄÅÒÖÉÔ × ÓÅÂÅ ÉÓÈÏÄÎÙÅ ËÏÄÙ ÐÒÏÇÒÁÍÍÙ SAMS, ÐÒÅÄÎÁÚÎÁÞÅÎÎÏÊ ÄÌÑ 
-ÎÁÓÔÒÏÊËÉ É ÁÄÍÉÎÉÓÔÒÉÒÏ×ÁÎÉÑ ÄÏÓÔÕÐÁ ÐÏÌØÚÏ×ÁÔÅÌÅÊ Ë ÐÒÏËÓÉ-ÓÅÒ×ÅÒÕ SQUID Ó
-ÉÓÐÏÌØÚÏ×ÁÎÉÅÍ ntlm ÁÕÔÅÎÔÉÆÉËÁÃÉÉ × Windows ÄÏÍÅÎÅ, ÕÐÒÁ×ÌÅÎÉÑ ÄÏÓÔÕÐÏÍ 
-ÐÏÌØÚÏ×ÁÔÅÌÅÊ Ë ÒÅÓÕÒÓÁÍ ÉÎÔÅÒÎÅÔ, Á ÔÁËÖÅ ÓÂÏÒÁ É ÐÒÅÄÏÓÔÁ×ÌÅÎÉÑ ÓÔÁÔÉÓÔÉËÉ
-Ï ÏÂßÅÍÅ ÐÏÌÕÞÅÎÎÏÊ ÐÏÌØÚÏ×ÁÔÅÌÑÍÉ ÉÎÆÏÒÍÁÃÉÉ. 
+Compilation:
 
-óÉÓÔÅÍÎÙÅ ÔÒÅÂÏ×ÁÎÉÑ:
-- SQUID - ÐÒÏËÓÉ ÓÅÒ×ÅÒ
-- Winbind - ×ÈÏÄÉÔ × ÓÏÓÔÁ× SAMBA Suite 
-- MySQL - âÁÚÁ ÄÁÎÎÙÈ
-- Apache - WEB ÓÅÒ×ÅÒr Ó ÍÏÄÕÌÅÍ php. 
+SAMS now has autoconf: building should just be (in the sams-<version> dir:
 
-òÅËÏÍÅÎÄÕÅÍÁÑ ËÏÎÆÉÇÕÒÁÃÉÑ - ipIII-500/128/20Gb
+./configure
+make
 
+If you like you can do a:
 
+make install
+
+after the make. This will place SAMS binaries in  /usr/local/bin, WEB-interface 
+in /usr/local/share/sams.
+
+Fix the /etc/init.d/samsd startup file.
+
+Running samsdaemon: service samsd start
+
+Open the file http://yourserver/sams/index.html in your browser. SAMS should 
+now display a welcome screen and a login dialog. You can be reading the 
+user "Admin" password in the file INSTALL.
+
+Enjoy SAMS ;-)
+
+SAMS Team

trunk/php/mysqltools.php

@@ -281 +281 @@
       $this->ReadSAMSConfFile($configfile);
       
+if(!function_exists('mysql_connect'))
+  {
+        echo "<br><center><font color=red><b>ERROR: MySql for PHP is not properly installed.<br>Try installing mysql for php package </b></font></center>";
+        die();
+  }
+
+
 $link=mysql_connect("$this->MYSQLHOSTNAME","$this->MYSQLUSER","$this->MYSQLPASSWORD");
 if($link==FALSE)
@@ -310 +317 @@
                 if($function=="userdoc")
                   {
-
-                        print("<SCRIPT language=JAVASCRIPT>\n");
-                        print("function Createdb()\n");
-                        print("{\n");
-                        print("parent.basefrm.location.href=\"main.php?show=exe&function=loadsamsdbform&filename=createdb.php&setup=setup\";\n");  
-                        //print("        parent.basefrm.location.href=\"main.php?show=exe&function=deleteuser&filename=userbuttom_9_delete.php&&userid=$userid\";\n");
-                        print("}\n");
-                        print("</SCRIPT> \n");
                         print("<TABLE><TR> \n");
                         echo "<TD><IMG SRC=\"icon/classic/warning.jpg\" ALIGN=LEFT>";
-                        echo "<TD>Web ÉÎÔÅÒÆÅÊÓ ÎÅ ÓÍÏÇ ÐÏÄÓÏÅÄÉÎÉÔØÓÑ Ë ÂÁÚÅ SAMS.<BR>";
+                        echo "<TD>SAMS databases not connected<BR>";
                         print("</TABLE> \n");
                         if($squidlogdb==1)
-                                echo "âÁÚÁ squidlog ÎÅÓÏÚÄÁÎÁ ÉÌÉ ÐÏÌØÚÏ×ÁÔÅÌØ $this->MYSQLUSER ÎÅ ÉÍÅÅÔ ÐÒÁ× ÎÁ ÐÏÄËÌÀÞÅÎÉÅ Ë ÎÅÊ<BR>";
+                                echo "The base $this->LOGDB not created or the user $this->MYSQLUSER has no rights to connection to it<BR>";
                         if($squidctrldb==1)
-                                echo "âÁÚÁ squidctrl ÎÅÓÏÚÄÁÎÁ ÉÌÉ ÐÏÌØÚÏ×ÁÔÅÌØ $this->MYSQLUSER ÎÅ ÉÍÅÅÔ ÐÒÁ× ÎÁ ÐÏÄËÌÀÞÅÎÉÅ Ë ÎÅÊ<BR>";
-                        echo "<BR>ëÁË ÓÏÚÄÁÔØ ÂÁÚÙ SAMS: ";
-                        echo "<BR>RUS:  <A HREF=\"doc/RU/mysql_install.html\" TARGET=\"basefrm\">õÓÔÁÎÏ×ËÁ É ÓÏÚÄÁÎÉÅ ÂÁÚÙ SAMS × MySQL</A>";
-                        //echo "<BR>óÅÊÞÁÓ ×Ù ÓÍÏÖÅÔÅ ÓÏÚÄÁÔØ ÂÁÚÙ SAMS ÉÌÉ ÐÒÏ×ÅÒÉÔØ ÓÏÅÄÉÎÅÎÉÅ Ó ÎÉÍÉ";
-                        //print("<FORM NAME=\"createdbform\" ENCTYPE=\"multipart/form-data\" ACTION=\"main.php?show=exe&function=loadsamsdbform&filename=createdb.php&setup=setup \" METHOD=POST>\n");
-                        //print("<P><CENTER><INPUT TYPE=\"SUBMIT\" VALUE=\"Ok\" onclick=CreateDB()></CENTER>\n");
-
-                        //print("</FORM>\n");
-                        //echo "CREATE DATABASE<BR>";
-                        //print("<SCRIPT>\n");
-                        //print("parent.basefrm.location.href=\"main.php?show=exe&function=loadsamsdbform&filename=createdb.php&setup=setup\";\n");  
-                        //print("</SCRIPT> \n");
-
+                                echo "The base $this->SAMSDB not created or the user $this->MYSQLUSER has no rights to connection to it<BR>";
+
+                        print("<FORM NAME=\"createdatabase\" ACTION=\"install.php\">\n");
+                        print("<BR><INPUT TYPE=\"SUBMIT\" value=\"Run SAMS database installation script\">\n");
+                        print("</FORM>\n");
+
+                        print("<B>SAMS documentation</B><BR>\n");
+                        print("<A HREF=\"doc/EN/index.html\">english<BR>\n");
+                        print("<A HREF=\"doc/RU/index.html\">russian<BR>\n");
+                        
                   }
                 
         }
-
-
       $this->ReadSAMSSettings();