<< Back
Message for this thread
Posted by Messages text
Garf

Noavatar
Total post : 3
> Profile
Written on : 04/09/2009 19:15 ( more than one month )
Object : Has anyone succeeded in a working windows clean install?

Hi all,

Just checking out Docebo. Looks like a great project!!!   But…I can’t seem to get it working correcly. Running a Windows Vista as my test platform, IIS 7, MySQL 5.1 and PHP 5.2. No problems there as Moodle and Joomla run fine. Tried working with both Docebo 3.5 and 3.6, but both fail to runn properly from a clean install.

Everything installed correctly, languages included, but, many oeprations fail because of database errors. For istance, the CMS_Area db has a new field in 3.6 called Last_Modify as a date field that can not contain a Null. The PHP script that updates this table does not pass a date and the operation fials. Remove the Null constraint and everything is fine.

 

The script that installs the DB is:

CREATE TABLE `cms_area` (

  `idArea` int(11) NOT NULL auto_increment,

  `idParent` int(11) NOT NULL default '0',

  `path` varchar(255) NOT NULL default '',

  `lev` int(10) NOT NULL default '0',

  `title` varchar(255) NOT NULL default '',

  `alias` varchar(255) NOT NULL default '',

  `template` varchar(255) NOT NULL default '',

  `mr_title` varchar(255) NOT NULL default '',

  `browser_title` varchar(255) NOT NULL default '',

  `keyword` text NOT NULL,

  `sitedesc` text NOT NULL,

  `link` varchar(255) NOT NULL default '',

  `home` tinyint(1) NOT NULL default '0',

  `publish` tinyint(1) NOT NULL default '0',

  `langdef` tinyint(1) NOT NULL default '0',

  `show_in_menu` tinyint(1) NOT NULL default '1',

  `show_in_macromenu` tinyint(1) NOT NULL default '1',

  `last_modify` DATETIME NOT NULL ,

  PRIMARY KEY  (`idArea`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

Another script that has all the DB ‘s in the install directoy called db_full.sql shows no last_modify at all :

 

CREATE TABLE `cms_area` (

  `idArea` int(11) NOT NULL auto_increment,

  `idParent` int(11) NOT NULL default '0',

  `path` varchar(255) NOT NULL default '',

  `lev` int(10) NOT NULL default '0',

  `title` varchar(255) NOT NULL default '',

  `alias` varchar(255) NOT NULL default '',

  `template` varchar(255) NOT NULL default '',

  `mr_title` varchar(255) NOT NULL default '',

  `browser_title` varchar(255) NOT NULL default '',

  `keyword` text NOT NULL,

  `sitedesc` text NOT NULL,

  `link` varchar(255) NOT NULL default '',

  `home` tinyint(1) NOT NULL default '0',

  `publish` tinyint(1) NOT NULL default '0',

  `langdef` tinyint(1) NOT NULL default '0',

  `show_in_menu` tinyint(1) NOT NULL default '1',

  `show_in_macromenu` tinyint(1) NOT NULL default '1',

  PRIMARY KEY  (`idArea`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

This type of issue comes up time and again. Has anyone installed this clean and had it run out of the box? Orif you have had to tweak it, what tweaks and mods have you done or had to do to make it work? Sorry if I'm missing the obvious, I hate when that happens. Any help is appreciated though.

 

 

Thanks!

 

garf
 
De Simone Davide

Avatar
Total post : 162
> Profile
Written on : 05/09/2009 19:24 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
try to remove " ENGINE=MyISAM DEFAULT CHARSET=utf8; "
 
Derks Giovanni

Avatar
Total post : 1861
> Profile
Written on : 07/09/2009 10:56 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
hello,
are you using a version from SVN or the officiale release?

I've tried to manually run the query also with sql_mode set to strict but it works, and so the installer.. 

when do you get that error exactly? could you tell us your sql_mode settings (copy and paste the result of this query that you can run from phpMyAdmin or mysql client: SELECT @@GLOBAL.sql_mode;)

thanks.

bye,
Giovanni. 

Docebo Staff
 - Docebo 4 released! -
 
Garf

Noavatar
Total post : 3
> Profile
Written on : 08/09/2009 05:12 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?

Thanks for the quick replies guys!

I downloaded both Docebo versions from the site here. I'll pass along the entire ini file at the end of this thread, but the query Giovanni asked for shows:

'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

The string you mention Dado1 is right within the SQL installation scripts, so while I can remove it, I'm not sure I should be? However, I did notice when I  try to browse foreign keys at the table level, I get an error explaining foreign keys are only supported with the INNODB engine? Perhaps this is the problem? I"ll try switching the default table engine from MyISMA over to INODB and see what happens.

Giovanni, is there anything populating into this field on your server? If there is, I'm curious what code is triggerrig that? Perhaps that is something I'm missing? What is the query you used manually to update this table and I can try it too and then check it against the PHP that is currently running? Also, can you review the issue around foreign keys and see what your table defaults/MYSQL defaults are set to? Another item I noticed is that when I turn on debugging in Docebo, I do get foreign key errors.


Thanks again for the assistance!


Garf



The MySQL ini file is set as:

# MySQL Server Instance Configuration File

# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]

port=3306

[mysql]

default-character-set=latin1


# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306


#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.1/"

#Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.
max_connections=100

# Query cache is used to cache SELECT results and later return them
# without actual executing the same query once again. Having the query
# cache enabled may result in significant speed improvements, if your
# have a lot of identical queries and rarely changing tables. See the
# "Qcache_lowmem_prunes" status variable to check if the current value
# is high enough for your load.
# Note: In case your tables change very often or if your queries are
# textually different every time, the query cache may result in a
# slowdown instead of a performance improvement.
query_cache_size=0

# The number of open tables for all threads. Increasing this value
# increases the number of file descriptors that mysqld requires.
# Therefore you have to make sure to set the amount of open files
# allowed to at least 4096 in the variable "open-files-limit" in
# section [mysqld_safe]
table_cache=256

# Maximum size for internal (in-memory) temporary tables. If a table
# grows larger than this value, it is automatically converted to disk
# based table This limitation is for a single table. There can be many
# of them.
tmp_table_size=35M


# How many threads we should keep in a cache for reuse. When a client
# disconnects, the client's threads are put in the cache if there aren't
# more than thread_cache_size threads from before.  This greatly reduces
# the amount of thread creations needed if you have a lot of new
# connections. (Normally this doesn't give a notable performance
# improvement if you have a good thread implementation.)
thread_cache_size=8

#*** MyISAM Specific options

# The maximum size of the temporary file MySQL is allowed to use while
# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.
# If the file-size would be bigger than this, the index will be created
# through the key cache (which is slower).
myisam_max_sort_file_size=100G

# If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here, then prefer the
# key cache method.  This is mainly used to force long character keys in
# large tables to use the slower key cache method to create the index.
myisam_sort_buffer_size=69M

# Size of the Key Buffer, used to cache index blocks for MyISAM tables.
# Do not set it larger than 30% of your available memory, as some memory
# is also required by the OS to cache rows. Even if you're not using
# MyISAM tables, you should still set it to 8-64M as it will also be
# used for internal temporary disk tables.
key_buffer_size=256M

# Size of the buffer used for doing full table scans of MyISAM tables.
# Allocated per thread, if a full scan is needed.
read_buffer_size=64K
read_rnd_buffer_size=256K

# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. It is allocated per thread so be careful with
# large settings.
sort_buffer_size=256K


#*** INNODB Specific options ***


# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
#skip-innodb

# Additional memory pool that is used by InnoDB to store metadata
# information.  If InnoDB requires more memory for this purpose it will
# start to allocate it from the OS.  As this is fast enough on most
# recent operating systems, you normally do not need to change this
# value. SHOW INNODB STATUS will display the current amount used.
innodb_additional_mem_pool_size=3M

# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit, which offers full ACID behavior. If you are
# willing to compromise this safety, and you are running small
# transactions, you may set this to 0 or 2 to reduce disk I/O to the
# logs. Value 0 means that the log is only written to the log file and
# the log file flushed to disk approximately once per second. Value 2
# means the log is written to the log file at each commit, but the log
# file is only flushed to disk approximately once per second.
innodb_flush_log_at_trx_commit=1

# The size of the buffer InnoDB uses for buffering log data. As soon as
# it is full, InnoDB will have to flush it to disk. As it is flushed
# once per second anyway, it does not make sense to have it very large
# (even with long transactions).
innodb_log_buffer_size=2M

# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. The bigger you set this the less disk I/O is needed to
# access data in tables. On a dedicated database server you may set this
# parameter up to 80% of the machine physical memory size. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system.  Note that on 32bit systems you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size=107M

# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.
innodb_log_file_size=54M

# Number of threads allowed inside the InnoDB kernel. The optimal value
# depends highly on the application, hardware as well as the OS
# scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=10

 
 
Derks Giovanni

Avatar
Total post : 1861
> Profile
Written on : 08/09/2009 10:02 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
Writted by: Garf

The string you mention Dado1 is right within the SQL installation scripts, so while I can remove it, I'm not sure I should be? However, I did notice when I  try to browse foreign keys at the table level, I get an error explaining foreign keys are only supported with the INNODB engine? Perhaps this is the problem? I"ll try switching the default table engine from MyISMA over to INODB and see what happens.


You should leave the DEFAULT CHARSET=utf8; part.. the engine on some tables is MyISAM but this should not be a problem as the scripts doesn't relies on the db engine foreign keys..

Giovanni, is there anything populating into this field on your server? If there is, I'm curious what code is triggerrig that? Perhaps that is something I'm missing? What is the query you used manually to update this table and I can try it too and then check it against the PHP that is currently running? Also, can you review the issue around foreign keys and see what your table defaults/MYSQL defaults are set to? Another item I noticed is that when I turn on debugging in Docebo, I do get foreign key errors.


'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

the problem when trying to add a page to the cms is due to the STRICT_TRANS_TABLES mode.. you can try to disable it editing your my.ini like this:

#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

(I've commented the original line for backup purposes)
 
then restart mysql.

 That error could be caused by the fact that the last_modify field is a new one and probably the module hasn't been tested with mysql strict mode after its introduction.. but you wrote you got also other similar errors; could you tell in which modules / performing which action? thanks. also please let me know if the problems get fixed disabling the strict mode.


bye,
Giovanni. 

p.s.
to have the cms pages module works also with mysql strict mode you should run the following query:
ALTER TABLE `cms_area` CHANGE `last_modify` `last_modify` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' or, as you wrote, you can remove the null constraint.
Message modified by : giovanni.derks on : 08/09/2009 10:09

Docebo Staff
 - Docebo 4 released! -
 
Garf

Noavatar
Total post : 3
> Profile
Written on : 09/09/2009 17:36 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
Thanks Giovanni!

This worked perfectly and it appears all the other strange errors are now gone. I was even getting an error when trying to access the CMS saying "Access not Allowed" or something liek that. THis error too is gone.  I believe I saw something about that issue (CMS Access) in another thread that hadn't been resolved, so it might be worth noting.



Thanks again for the quick help!

Garf 
 
Derks Giovanni

Avatar
Total post : 1861
> Profile
Written on : 10/09/2009 12:21 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
You're welcome ;) thanks for your detailed feedback.

bye,
Giovanni. 

Docebo Staff
 - Docebo 4 released! -
 
Chirravuri Subrahmanyam

Noavatar
Total post : 11
> Profile
Written on : 19/09/2009 15:46 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?

Congratulations to the team that created docebo. Cool

I have just installed the application on a laptop and it looks easy to deal with and great in functionality. The application seems to be quite generic in design with simple configuration for setting up many of the application features.

Is there a way I could disable the email sending feature with PC Installation?

I understand that we would not be able to send email with the URL for the user to click and confirm. This amounts to the same as a user being created by the admin. However, but for the email, we should be able to grab the URL generated from the system (I do not know how easy this is) on the same screen for the user to click and confirm (for use on a desk top). This allows some one to eavaluate quite quickly and completely on the suitability of Docebo for their purpose.

Thanks & Regards

PS: Once again my best compliments to the team.
 
Derks Giovanni

Avatar
Total post : 1861
> Profile
Written on : 21/09/2009 10:06 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
hi,
and thanks for your positive feedback ;)

at this moment it is not possible to disable the email feature for local installations .. you should have to do it by hand editing the code, or you could install a local mailserver and have it to work with your php installation.. (run it only when needed, then switch it off) .. for example XAMP for windows should provide it..

bye,
Giovanni. 

Docebo Staff
 - Docebo 4 released! -
 
Chirravuri Subrahmanyam

Noavatar
Total post : 11
> Profile
Written on : 21/09/2009 19:19 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?

Here is a detailed notes on my installation process.

Step 1 & 2 are trivial.

Step 3 - my system details:

Step 3: Choose application to install
Server information
Server address : 127.0.0.1
Server port : 80
Server name : localhost
Server administrator : [my mail ID]
Server software : Apache/2.2.4 (Win32) PHP/5.2.0
PHP Information :
PHP Version : 5.2.0
Safe mode : OFF
register_global : OFF
magic_quotes_gpc : ON
upload_max_filsize : 2M
post_max_size : 8M
max_execution_time : 120s
allow_url_include : OFF
Ldap : OFF Consider this warning only if you need to use LDAP [I am not using LDAP and ignoring this message]

Step 6: Database importing
 
Database correctly loaded
Now we will import languages, this operation can take ong time (1 minute or more), don't close the browser and click"next step" ONLY when page is completely loaded. If you experience problem please ask to your server administrator or hosting provider to set the PHP timeout to an higer value or use the manual procedure
[This step completed with out any error - thanks to the change of   "max_execution_time : 120s" instead of 30s.
Perhaphs my computer is slow. It is a Lenovo - 3000 N100 with T2300 processor @1.66GHz and 512MB RAM. I was having problems
of not able to complete this step in a single attempt due to the above parameter.]

The screen shot on Step 7: Language importing, also gives a few issues of failure, though you could complete the step with retry.
I have no idea what parameters need to be tweaked.
Further, just as an observation, when you click the button - "Start", you would notice, the bottom button to change text to "Next Step"
where as the top button remaining as "Start". This is the case irrespective of which of the two buttons (Right bottom or Left top) you use.

All in all the installation was rather easier, but for the above minor things.

My recommendation would be to provide values that would be conservative to install on a PC desktop.





Step 7 - issue


I hope this information is useful to people.

Regards
 
Derks Giovanni

Avatar
Total post : 1861
> Profile
Written on : 22/09/2009 10:04 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
Writted by: Chirravuri Subrahmanyam


The screen shot on Step 7: Language importing, also gives a few issues of failure, though you could complete the step with retry.
I have no idea what parameters need to be tweaked.



Probably it is still due to the max_execution_time parameter, if it took to you about 120 seconds before fail.

thanks for sharing your notes and feedback :)

bye,
Giovanni. 

Docebo Staff
 - Docebo 4 released! -
 
Chirravuri Subrahmanyam

Noavatar
Total post : 11
> Profile
Written on : 22/09/2009 20:07 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
Thanks for your useful clarifications. I have met with an issues after installation as below:

Below screen shot shows the number of Words not translated in the system for LMS module for a user role.Language Translation issue

Then, when I try to define the translation per the attached screen, the error does not go away.

Translation attept screen

Please help me to understand the point of my mistake.

Thank you for your support.
 
Chirravuri Subrahmanyam

Noavatar
Total post : 11
> Profile
Written on : 22/09/2009 20:11 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
I notice that my attempt to login to the forum is being rejected on my reattempts after a connection failure over broadband with my ISP. I have changed my browser from IE7 to Firefox to log the above issue.

I have an impression that there is a check on my credentials being presented from a different IP before the earlier session is logged out from my end. I think, the system has a longer session_timeout duration, during which my attempts are rejected.

Please correct my understanding.

Once again thanks.
 
Derks Giovanni

Avatar
Total post : 1861
> Profile
Written on : 23/09/2009 09:58 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
Then, when I try to define the translation per the attached screen, the error does not go away.


hi,
it seems that you have the option "Activate language editing (used for debugging)" turned on.. please disable it in configuration > common > Configuration and interface options.

bye,
Giovanni. 

Docebo Staff
 - Docebo 4 released! -
 
Derks Giovanni

Avatar
Total post : 1861
> Profile
Written on : 23/09/2009 10:04 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
Writted by: Chirravuri Subrahmanyam

I notice that my attempt to login to the forum is being rejected on my reattempts after a connection failure over broadband with my ISP. I have changed my browser from IE7 to Firefox to log the above issue.


hi,
I'm not sure to fully understand what you mean; which error do you receive? Did you tried to delete the cookie from IE7? If you changed your IP and your browser session is still active, the session should expire..

bye,
Giovanni. 

Docebo Staff
 - Docebo 4 released! -
 
Chirravuri Subrahmanyam

Noavatar
Total post : 11
> Profile
Written on : 24/09/2009 18:28 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
Writted by: Derks Giovanni

Then, when I try to define the translation per the attached screen, the error does not go away.


hi,
it seems that you have the option "Activate language editing (used for debugging)" turned on.. please disable it in configuration > common > Configuration and interface options.

bye,
Giovanni. 


________________________________________
This did fix my problem. Thanks for your help.
 
Chirravuri Subrahmanyam

Noavatar
Total post : 11
> Profile
Written on : 24/09/2009 18:29 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?
Writted by: Chirravuri Subrahmanyam

Writted by: Derks Giovanni

Then, when I try to define the translation per the attached screen, the error does not go away.


hi,
it seems that you have the option "Activate language editing (used for debugging)" turned on.. please disable it in configuration > common > Configuration and interface options.

bye,
Giovanni. 


________________________________________
This did fix my problem. Thanks for your help.
 
Chirravuri Subrahmanyam

Noavatar
Total post : 11
> Profile
Written on : 24/09/2009 18:32 ( more than one month )
Object : Re: Has anyone succeeded in a working windows clean install?

Writted by: Derks Giovanni

Writted by: Chirravuri Subrahmanyam

I notice that my attempt to login to the forum is being rejected on my reattempts after a connection failure over broadband with my ISP. I have changed my browser from IE7 to Firefox to log the above issue.


hi,
I'm not sure to fully understand what you mean; which error do you receive? Did you tried to delete the cookie from IE7? If you changed your IP and your browser session is still active, the session should expire..

bye,
Giovanni. 



I just tried to login into the forum for 3 times from IE7 browser window, but in vain. After 1st time failure, I cleared the cookies as well.

The system does not give any error message to me at all.

Then I changed my browser to Firefox and have succeeded to login with my same credentials.

I have no idea what was the cause of the issue.
 
<< Back