jueves, 30 de mayo de 2013

Course

Plugins

Display customized reports through sql queries install the plugin Ad-hoc database queries

Install the folder customsql in htdocs\moodle\local
Restart moodle to times to show the pages to update the appliation

Documentation

http://docs.moodle.org/19/en/Custom_SQL_queries_report

Add Reources

In the section

you can add many items like labels, Test Surveys, Quizzes, Assignments, etc

Users

To send mails to new user install the plugin welcome

Install the folder welcome in htdocs\moodle\local
Restart moodle to times to show the pages to update the appliation

Groups

The term is referent to indicate that one course is given in many Groups.
The users must be enrolled before assign them to a group

Paypal

First, enable the plugin

2. Configured your

martes, 7 de mayo de 2013

Moodle with SQL Server

Execute the following commands

1)

CREATE LOGIN root WITH PASSWORD = 'Adm1n1234'
,DEFAULT_DATABASE = [moodle]
GO
-- Now add user to database

2)
USE moodle;
CREATE USER root FOR LOGIN root;
GO

3)

ALTER DATABASE moodle SET ANSI_NULLS ON

ALTER DATABASE moodle SET QUOTED_IDENTIFIER ON

ALTER DATABASE moodle SET READ_COMMITTED_SNAPSHOT ON

Set the following settings in your php.ini file

mssql.textlimit = 20971520
mssql.textsize = 20971520

lunes, 6 de mayo de 2013

Moodle instalation - Fix Problems

Fix problems
http://moodle-platform.cba.pl/admin/index.php?lang=en&agreelicense=1

SSL problem

admin/environment/php extension/openssl

Main page ► Managing a Moodle site ► Server settings ► Environment ► admin/environment/php extension/openssl

To install the openssl library on Windows

Open the php.ini file found in the moodle/apache/bin (if not there then, in folder server/php/)
Find the line: ;extension=php_openssl.dll
Remove the ; at the beginning of the line
Restart apache if necessary

Note: if Moodle fails to create a public key in Admin > Networking > Settings, you'll need to configurate your OPENSSL_CONF path. With Windows File Explorer find openssl.cnf file (usually in your php/extras directory). Rename it as openssl.conf. Then set OPENSSL_CONF in your Windows environment variable (example: C:/wamp/bin/php/extras/openssl/openssl.conf - do not forget the file name in the path, otherwise it doesn't work)

To install the openssl library on Unix

You need to recompile PHP from source
add --with-openssl to the command line when you run configure

INTL Problem

admin/environment/php extension/intl

Main page ► Managing a Moodle site ► Server settings ► Environment ► admin/environment/php extension/intl

The Internationalization extension (Intl) is a wrapper for the ICU library, a set of C/C++ and Java libraries that provide Unicode and Globalization support for software applications. It enables PHP programmers to perform UCA-conformant collation and date/time/number/currency formatting in their scripts.

MS Windows

To enable this extension add the following line to your php.ini file usually found in /php:

extension=php_intl.dll

And then set the intl.default_locale and intl.error_level directives in your php.ini file.

[intl]

intl.default_locale = en_utf8

intl.error_level = E_WARNING

The intl.error_level directive is optional.

In a WAMP installation it may be required to add the php path (e.g. C:\wamp\bin\php\php5.3.13 or C:\wamp\bin\php\php5.4.3) to the the system PATH so that the module4 could uploaded properly (see http://forum.wampserver.com/read.php?2,80704,82499 for a couple of other approaches).

“icuuc46.dll” file missing error

Go to [xampp_path]/php/
Select the following 3 files:

icudt46.dll
icuin46.dll
icuuc46.dll

Copy & Paste the files in [xampp_path]/apache/bin folder.

Restart APACHE

PHP connect to SQL Server 2012

1. Download the driver from msn
http://www.microsoft.com/en-us/download/details.aspx?id=29065

2. Execute SQLSRV30.EXE

3. Read SQLSRV_Readme.htm

4. Go to C:\xampp\php and find the file:
php5ts.dll or php.dll

5. Copy the files to C:\xampp\php\ext

php_sqlsrv_54_ts.dll
php_pdo_sqlsrv_54_ts.dll

6. Restart the apache

Create SQL Server user to a database

CREATE LOGIN JohnJacobs WITH PASSWORD = 'JinGleHeimerSchmidt'
,DEFAULT_DATABASE = [YourDatabaseHere]
GO

-- Now add user to database
USE YourDatabaseHere;
CREATE USER JohnJacobs FOR LOGIN JohnJacobs;
GO

Rodrigo IT Sacbé