Fix: Errno 3502, no GRANT or GRANT compatible permit exists
Tuesday, November 3, 2009

aka, UCOSP: status report #12

Here is a piece of php code that I ran to check I can execute query under my web server.
There it prints this error message:

no GRANT or GRANT compatible permit exists


Reason:
By default, when you create a database, the access to the database is public.
By default, when you create a table/view/procedure the access is restricted to the owner.
You will need to do "grant select on the_table/view/procedure_you_want to public". For convenience, I did "grant all on test" and ran the code above. Remember you will NEED TO log off the database where that table is sitting in order for the above code to work :)

Posted byA nerdy girl at 10:32 AM 0 comments  

Labels: , , ,

Code: Test if Apache is working with Ingres
Friday, October 30, 2009

The following is a piece of code that will help to see if Apache is talking to Ingres

error_reporting(E_ALL);

$link = ingres_connect("your_whatever_database_name")
or die("Could not connect");

echo "Connected successfully
";

?>

Ingres by default creates database with the access type public. If you explicitly put in a user name or password as parameters to ingres_connect for public database, it will fails to connect.

Now that I know Apache is talking to Ingres, next Drupal!

Posted byA nerdy girl at 10:53 PM 0 comments  

Labels: , , , ,

UCOSP: status report #11

An alternative way to do what I have been doing for these months, but you don't have the chance to explore the bigger picture like I do, how's that? EasyIngres is a package which automatically installs a PHP development environment on Windows including Ingres 9.2, Apache 2.2.8 and PHP 5.2.9

Posted byA nerdy girl at 8:24 AM 0 comments  

Configuring Apache 2.2 with Ingres 10.0.0.107 on Windows 32 bit XP Home SP3
Thursday, October 29, 2009

Configuring Apache 2.2 with Ingres 10.0.0.107 on Windows 32 bit XP Home SP3, aka, UCOSP: status report #10

  • Bring up your command line window by going to start->Run and type cmd. Type "cbf" to bring up the menu for settings of the DBMS Ingres.
    1. Go to DBMS Server->cache Menu, turn the variable 64k caches from "off"(default) to "on".
    2. Go to DBMS Server->cursor_limit, increase from 128(default) to 200.
    3. Go to DBMS Server->system_maxlocks, increase from 50(default) to 1500.
    4. Go to Locking System->per_tx_limit, increase to 1500(default) if it is not.

  • Follow this to check if your Apache is running as a service or locally.
  • If your web server, Apache, is running as a service, then do the following:
    1. Right click My Computer
    2. Select "Properties", then go to "Advanced" Tab, click onto "Environment Variables", go to the section of "System variables".
    3. Use Add/Edit to add:
      II_SYSTEM=C:\Program Files\Ingres\IngresIJ
      PATH=C:\Program Files\Ingres\IngresIJ\bin;C:\Program
      Files\Ingres\IngresIJ\utility;%PATH%

    4. Reboot your PC for the Service Control Manager to see the new variables

  • If your web server, Apache, is running via your local Windows account, then do the following:
    1. Go to Start->Run, and type "cmd /k C:\Program Files\Ingres\IngresIJ\bin\setingenvs.bat"
    2. Restart the Apache instance, httpd.exe, by typing "C:\your_path_to_apache\bin\httpd.exe -k restart"

  • Follow this here to see if Apache is talking to Ingres


As I move onto configuring Apache with Ingres myself, I have made some side notes when following this wiki here:
  • The wiki above is specific to Fedora Linux as of date 2009-10-29, ways to configure vary for different types and version of Linux as well as Windows.
  • After following the above on the part of changing locking variables of Ingres, and restarted the Ingres instance, the "shocking green light" of "Primary Transaction Log", and "Dual Transaction Log" maybe become a darker green colour. If you check your own errlog.log in "C:\Program Files\\whatever\\Ingres??\ingres\files\", and there is no problem about changing of the variables, then it should be the Ingres Visual Manager(IVM) that got confused :p, so don't worry about that.

Posted byA nerdy girl at 1:09 PM 0 comments  

Solution: How to check as what does Apache is running on Windows XP

The following description is specific to Apache 2.2 and Windows XP, but other OS should be similar.

  1. Start up your Apache instance. There are two ways you can do so: 1. Click "Start" from "Apache Service Monitor". 2. Run "/your_apache_path/Apache2.2/httpd.exe -k start" from commandline.
  2. Bring up your "Task Manager"(Press Ctrl+Alt+Del), go to Process Tab and look for Image Name httpd.exe. If the "User Name" = "SYSTEM", then you are running Apache as a service, otherwise, you are running it from your local Windows XP account.

Posted byA nerdy girl at 1:09 PM 0 comments  

UCOSP: status report #9
Tuesday, October 27, 2009

While I'm following getting Drupal on Ingres, I come across another set of tutorials that I found them useful in understanding the bigger picture.



Also, today I have come across some command from IRC that I found them useful to configure a php module on Windows.

Make sure...
  • you have your_whatever_module.dll is located in the path stated in the following line inside the php.ini file: extension_dir=whatever_extension_path
  • the variable inside php.ini is enabled to see any error messages
  • you don't have your path slashes backwards, path such as "C:\php\ext" works but "C:/php/ext" won't for Windows user like me.
  • If you run this command: \whatever_path_you_install_the_php\php.exe -i(and it should give you "C:\WINDOWS" by default), then you need to place the php.ini into that directory given by the command.
  • You see the php module that you want to install by running this command: \whatever_path_you_install_the_php\php.exe -m


Good luck installing :)!

I have got the php_ingres.dll module loaded in php, and next configure Apache with Ingres, then Drupal installation.

Posted byA nerdy girl at 8:54 AM 0 comments  

UCOSP: status report #8
Monday, October 26, 2009

I'm trying to get Drupal 7 to talk to Ingres 10 following this here on Windows 32 bit XP home SP3, with PHP 5.3 and Apache 2.2. When I run the script from http://localhost:8080/drupal-6.14/install.php, and it's stucked on

Database configuration
Your web server does not appear to support any common database types.


I have these 2 lines in my php.ini under Apache

extension_dir=C:\php\ext
extenion=php_ingres.dll


The funny thing is Drupal knows about other extension such as php_mysql.dll, but the php_ingres.dll does not, which are also located in C:\php\ext like php_mysql.dll. I have got my version of php_ingres.dll from Grant earlier today since the dll is not up on ESD for Ingres version 10 yet(Thanks so much for Grant again on this).

Apparently, I'm not the only one of the UCOSP students who are still stucked on this. Sarah and Mary has got away from this problem by installing a Linux VM and Evan is still working on it. ARGH, I really want to get this working soon!

Posted byA nerdy girl at 9:31 PM 0 comments  

Labels: ,

Subscribe to: Posts (Atom)