<div dir="ltr"><span style="font-size:12.8px">Hello, Thank you very much for sharing experiences. Best, Kamal</span><div><span style="font-size:12.8px"><br></span><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Partha Mukhopadhyay</b> <span dir="ltr"><<a href="mailto:psm_vu@india.com">psm_vu@india.com</a>></span><br>Date: Mon, May 30, 2016 at 10:50 PM<br>Subject: Re: [Koha-devel] More problems with MySQL 5.7<br>To: koha-devel <<a href="mailto:koha-devel@lists.koha-community.org">koha-devel@lists.koha-community.org</a>><br><br><br><div><div><span>Dear All<br></span></div><div> </div><div><span>I also got the same problems in installation and post-installation of Koha 3.22.06 on Ubuntu 16.04 (MySQL 5.7.12). I followed the following steps to get rid of the situation in our departmental ICT lab.</span></div><div> </div><div><span>Installation </span></div><div> </div><div><span>1. Off default sql_mode;</span></div><div><span>2. Web installer still fails in step 3;</span></div><div><span>3. Changed Kohastructue.sql (Tables letter and permissions)</span></div><div><span>4. Imported kohastructure.sql manually to Koha_instancename db (after vacating it)</span></div><div><span>5. Altered Koha_instancename db to make it Unicode compatible as we are using multilingual records (ALTER DATABASE `koha_instancaname` CHARACTER SET utf8 COLLATE utf8_unicode_ci;)</span></div><div><span>6. Again started web installer and this time it worked</span></div><div><span>7. Finished installation and logged on to koha for post installation works</span></div><div><span>6. Retured to default sql_mode</span></div><div> </div><div><span>Post installtion work</span></div><div> </div><div><span>1. Tried all basic operations in post installation phase - all worked except add patron (always says no patron category thoug it is present there) </span></div><div><span>2. Again set off ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES in sql_mode</span></div><div><span>3. Recheked and found everything is working</span></div><div> </div><div><span>Questions</span></div><div><span>1. Is it safe and secured to keep ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES off in MySQL 5.7.12 (or latter versions)?</span></div><div><span>2. Is it wise to use Koha 3.22.06 or 16.05 vesion (having same problems) on ubuntu 16.04 (with MySQL 5.7.12) in production mode?</span></div><div> </div><div> </div><div><span>The entire process in step-step manner has alreday been documented and uploaed in github. Those who are facing same problems and wish to have a solution may check it from here:</span></div><div> </div><div><span><a href="https://github.com/psmukhopadhyay/OLS" target="_blank">https://github.com/psmukhopadhyay/OLS</a></span></div><div> </div><div><span><a href="https://github.com/psmukhopadhyay/OLS/blob/master/Koha%203.22.x%20on%20Ubuntu%2016.04%28psm%29.pdf" target="_blank">https://github.com/psmukhopadhyay/OLS/blob/master/Koha%203.22.x%20on%20Ubuntu%2016.04%28psm%29.pdf</a></span></div><div> </div><div> </div><div><span>But a caution: I'm no DBMS expert (a teacher in LIS by profession to be exact) and the entire process requires authentication and clearence by Koha experts working DBMS domain.</span></div><div> </div><div> </div><div><span>Regards </span></div><div> </div><div><span>----------------------------------------------------<br><br>Dr. Parthasarathi Mukhopadhyay<br><br>Associate Professor<br><br>Department of Library and Information Science<br><br>University of Kalyani (WB, India)<br><br>------------------------------------------</span></div><div>
<br><br>At 30 May 2016 09:32:09 +0000 (+00:00) from Juan Francisco Romay Sieira <<a href="mailto:juan.sieira@xercode.es" target="_blank">juan.sieira@xercode.es</a>>:</div><div><div class="h5"><blockquote style="margin-left:10px;padding-left:10px;border-left-width:3px;border-left-style:solid;border-left-color:rgb(255,204,51)">
<div>Hello,
<div>we found this issue some days ago, and this is what we do:</div>
<div> </div>
<div>
<pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span style="font-family:monospace,monospace"><span style="font-weight:bold">sub </span><span style="color:rgb(153,0,0);font-weight:bold">_new_schema</span> <span>{</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-49"></a>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-50"></a> <span style="color:rgb(153,153,153)">require</span> <span style="color:rgb(85,85,85)">Koha::</span><span>Schema</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-51"></a>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-52"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$context</span> <span style="font-weight:bold">=</span> <span style="color:rgb(85,85,85)">C4::</span><span>Context</span><span style="font-weight:bold">-></span><span style="font-weight:bold">new</span><span>();</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-53"></a>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-54"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$db_driver</span> <span style="font-weight:bold">=</span> <span style="color:teal">$context</span><span style="font-weight:bold">-></span><span>{</span><span>db_driver</span><span>};</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-55"></a>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-56"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$db_name</span> <span style="font-weight:bold">=</span> <span style="color:teal">$context</span><span style="font-weight:bold">-></span><span>config</span><span>(</span><span style="color:rgb(187,136,68)">"database"</span><span>);</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-57"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$db_host</span> <span style="font-weight:bold">=</span> <span style="color:teal">$context</span><span style="font-weight:bold">-></span><span>config</span><span>(</span><span style="color:rgb(187,136,68)">"hostname"</span><span>);</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-58"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$db_port</span> <span style="font-weight:bold">=</span> <span style="color:teal">$context</span><span style="font-weight:bold">-></span><span>config</span><span>(</span><span style="color:rgb(187,136,68)">"port"</span><span>)</span> <span style="font-weight:bold">||</span> <span style="color:rgb(187,136,68)">''</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-59"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$db_user</span> <span style="font-weight:bold">=</span> <span style="color:teal">$context</span><span style="font-weight:bold">-></span><span>config</span><span>(</span><span style="color:rgb(187,136,68)">"user"</span><span>);</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-60"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$db_passwd</span> <span style="font-weight:bold">=</span> <span style="color:teal">$context</span><span style="font-weight:bold">-></span><span>config</span><span>(</span><span style="color:rgb(187,136,68)">"pass"</span><span>);</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-61"></a>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-62"></a> <span style="font-weight:bold">my</span> <span>(</span> <span style="color:teal">%encoding_attr</span><span>,</span> <span style="color:teal">$encoding_query</span><span>,</span> <span style="color:teal">$tz_query</span><span>,</span> <span style="color:teal">$sql_mode</span> <span>);</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-63"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$tz</span> <span style="font-weight:bold">=</span> <span style="color:teal">$ENV</span><span>{</span><span>TZ</span><span>};</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-64"></a> <span style="font-weight:bold">if</span> <span>(</span> <span style="color:teal">$db_driver</span> <span style="font-weight:bold">eq</span> <span style="color:rgb(187,136,68)">'mysql'</span> <span>)</span> <span>{</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-65"></a> <span style="color:teal">%encoding_attr</span> <span style="font-weight:bold">=</span> <span>(</span> <span>mysql_enable_utf8</span> <span style="font-weight:bold">=></span> <span style="color:rgb(0,153,153)">1</span> <span>);</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-66"></a> <span style="color:teal">$encoding_query</span> <span style="font-weight:bold">=</span> <span style="color:rgb(187,136,68)">"set NAMES 'utf8'"</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-67"></a> <span style="color:teal">$tz_query</span> <span style="font-weight:bold">=</span> <span style="color:rgb(187,136,68)">qq(SET time_zone = "$tz")</span> <span style="font-weight:bold">if</span> <span style="color:teal">$tz</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-68"></a> <span style="color:teal">$sql_mode</span> <span style="font-weight:bold">=</span> <span style="color:rgb(187,136,68)">"set sql_mode = ''"</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-69"></a> <span>}</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-70"></a> <span style="font-weight:bold">elsif</span> <span>(</span> <span style="color:teal">$db_driver</span> <span style="font-weight:bold">eq</span> <span style="color:rgb(187,136,68)">'Pg'</span> <span>)</span> <span>{</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-71"></a> <span style="color:teal">$encoding_query</span> <span style="font-weight:bold">=</span> <span style="color:rgb(187,136,68)">"set client_encoding = 'UTF8';"</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-72"></a> <span style="color:teal">$tz_query</span> <span style="font-weight:bold">=</span> <span style="color:rgb(187,136,68)">qq(SET TIME ZONE = "$tz")</span> <span style="font-weight:bold">if</span> <span style="color:teal">$tz</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-73"></a> <span>}</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-74"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$schema</span> <span style="font-weight:bold">=</span> <span style="color:rgb(85,85,85)">Koha::</span><span>Schema</span><span style="font-weight:bold">-></span><span style="color:rgb(153,153,153)">connect</span><span>(</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-75"></a> <span>{</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-76"></a> <span>dsn</span> <span style="font-weight:bold">=></span> <span style="color:rgb(187,136,68)">"dbi:$db_driver:database=$db_name;host=$db_host;port=$db_port"</span><span>,</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-77"></a> <span>user</span> <span style="font-weight:bold">=></span> <span style="color:teal">$db_user</span><span>,</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-78"></a> <span>password</span> <span style="font-weight:bold">=></span> <span style="color:teal">$db_passwd</span><span>,</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-79"></a> <span style="color:teal">%encoding_attr</span><span>,</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-80"></a> <span>RaiseError</span> <span style="font-weight:bold">=></span> <span style="color:teal">$ENV</span><span>{</span><span>DEBUG</span><span>}</span> <span>?</span> <span style="color:rgb(0,153,153)">1</span> <span>:</span> <span style="color:rgb(0,153,153)">0</span><span>,</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-81"></a> <span>PrintError</span> <span style="font-weight:bold">=></span> <span style="color:rgb(0,153,153)">1</span><span>,</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-82"></a> <span>unsafe</span> <span style="font-weight:bold">=></span> <span style="color:rgb(0,153,153)">1</span><span>,</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-83"></a> <span>quote_names</span> <span style="font-weight:bold">=></span> <span style="color:rgb(0,153,153)">1</span><span>,</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-84"></a> <span>on_connect_do</span> <span style="font-weight:bold">=></span> <span>[</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-85"></a> <span style="color:teal">$encoding_query</span> <span style="font-weight:bold">||</span> <span>(),</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-86"></a> <span style="color:teal">$tz_query</span> <span style="font-weight:bold">||</span> <span>(),</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-87"></a> <span style="color:teal">$sql_mode</span> <span style="font-weight:bold">||</span> <span>(),</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-88"></a> <span>]</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-89"></a> <span>}</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-90"></a> <span>);</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-91"></a>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-92"></a> <span style="font-weight:bold">my</span> <span style="color:teal">$dbh</span> <span style="font-weight:bold">=</span> <span style="color:teal">$schema</span><span style="font-weight:bold">-></span><span>storage</span><span style="font-weight:bold">-></span><span>dbh</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-93"></a> <span style="color:rgb(153,153,153)">eval</span> <span>{</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-94"></a> <span style="color:teal">$dbh</span><span style="font-weight:bold">-></span><span>{</span><span>RaiseError</span><span>}</span> <span style="font-weight:bold">=</span> <span style="color:rgb(0,153,153)">1</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-95"></a> <span style="color:teal">$dbh</span><span style="font-weight:bold">-></span><span style="font-weight:bold">do</span><span>(</span><span style="color:rgb(187,136,68)">q|</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-96"></a><span style="color:rgb(187,136,68)"> SELECT * FROM systempreferences WHERE 1 = 0 |</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-97"></a> <span>);</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-98"></a> <span style="color:teal">$dbh</span><span style="font-weight:bold">-></span><span>{</span><span>RaiseError</span><span>}</span> <span style="font-weight:bold">=</span> <span style="color:teal">$ENV</span><span>{</span><span>DEBUG</span><span>}</span> <span>?</span> <span style="color:rgb(0,153,153)">1</span> <span>:</span> <span style="color:rgb(0,153,153)">0</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-99"></a> <span>};</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-100"></a> <span style="color:teal">$dbh</span><span style="font-weight:bold">-></span><span>{</span><span>RaiseError</span><span>}</span> <span style="font-weight:bold">=</span> <span style="color:rgb(0,153,153)">0</span> <span style="font-weight:bold">if</span> <span style="color:teal">$@</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-101"></a>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-102"></a> <span style="font-weight:bold">return</span> <span style="color:teal">$schema</span><span>;</span>
<a style="color:rgb(53,114,176)" name="m_70167566341509449_Database.pm-103"></a><span>}</span></span></pre>
</div>
<div> </div>
<div>Regards,</div>
<div> </div>
</div>
<div class="gmail_extra">
<br>
<div class="gmail_quote">2016-05-26 17:59 GMT+02:00 Tomas Cohen Arazi <<a href="mailto:tomascohen@gmail.com" target="_blank">tomascohen@gmail.com</a>>:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>Maybe it is worth checking if it can be configured client-side. As we do for UTF-8</div>
<br>
<div class="gmail_quote">
<div>El jue., 26 may. 2016 a las 9:45, Bernardo Gonzalez Kriegel (<<a href="mailto:bgkriegel@gmail.com" target="_blank">bgkriegel@gmail.com</a>>) escribió:</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>Hi,
<div>testing things on MySQL 5.7 - Koha 3.22, found a new problem:</div>
<div> </div>
<div>
<span style="font-family:monospace;color:rgb(0,0,0)"><a href="http://memberentry.pl" target="_blank">memberentry.pl</a>: DBD::mysql::st execute failed: Expression #1 of SELE</span><span style="font-family:monospace">CT list is not in GROUP BY clause and contains nonaggregated column 'kohadev.categories.categorycode' which is not functionally dependent on columns in GROUP BY clause; this is incompati</span><span style="font-family:monospace">ble with sql_mode=only_full_group_by ...</span>
</div>
<div> </div>
<div>This comes trying to add a patron after fresh install, 3.22+marc21+all sample data</div>
<div> </div>
<div>Can we change sql_mode for Koha?</div>
<div> </div>
<div>Regards</div>
<div>Bernardo</div>
<div> </div>
<div>
<br clear="all">
<div>
<div>--
<div>Bernardo Gonzalez Kriegel</div>
<div><a href="mailto:bgkriegel@gmail.com" target="_blank">bgkriegel@gmail.com</a></div>
</div>
</div>
</div>
</div>
<span><span style="color:rgb(136,136,136)"> _______________________________________________<br> Koha-devel mailing list<br> <a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br> website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br> git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br> bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></span></span>
</blockquote>
</div>
<div>-- </div>
<div>
<div>
<div style="color:rgb(117,117,117);font-family:'helvetica neue',helvetica,arial,sans-serif;font-size:12.8px">Tomás Cohen Arazi</div>
<div style="color:rgb(117,117,117);font-family:'helvetica neue',helvetica,arial,sans-serif;font-size:12.8px">Theke Solutions (<a href="http://theke.io/" target="_blank">http://theke.io</a>)<br>✆ <a>+54 9351 3513384</a><br>GPG: B2F3C15F</div>
</div>
</div>
<br>_______________________________________________<br> Koha-devel mailing list<br> <a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br> website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br> git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br> bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a>
</blockquote>
</div>
<br><br clear="all">
<div> </div>
-- <br>
<div>
<div>
<div>
<div>
<div>
<div>
<span style="text-indent:0px"><span style="text-indent:0px"><br clear="all"><br><span style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial">--</span><span style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial"> </span><br></span></span>
<div><strong> </strong></div>
<span style="text-indent:0px"><span style="text-indent:0px"><strong style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial">Juan Francisco Romay Sieira</strong><br><span style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial"> </span><br></span></span>
<div>
<div style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial">
<em>Chief Technology Officer</em><br><a href="mailto:juan.sieira@xercode.es" target="_blank">juan.sieira@xercode.es</a><br> <br>C/ Hedras, 4 2ºA | 15895 | Milladoiro - A Coruña - Spain<br><a href="http://www.xercode.es/" target="_blank">www.xercode.es</a> | <a href="mailto:info@xercode.es" target="_blank">info@xercode.es</a>
</div>
<div style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial">Tel. <a href="tel:%28%2B34%29%20881%20975%20576" value="+34881975576" target="_blank">(+34) 881 975 576</a><br> </div>
<div style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial"><img src="http://xercode.es/wp-content/uploads/2015/07/Xercode.png" alt="" width="200" height="38"></div>
<div style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial">
<br><span style="font-family:arial,helvetica,sans-serif;font-size:10pt;color:rgb(34,34,34);text-align:justify">La información contenida en este mensaje de correo electrónico es confidencial y puede revestir el carácter de reservada. Está destinada exclusivamente a su destinatario. El acceso o uso de este mensaje, por parte de cualquier otra persona que no esté autorizada, puede ser ilegal. Si no es Ud. la persona destinataria, le rogamos que proceda a eliminar su contenido y comunicar dicha anomalía a su remitente.</span>
</div>
<div>
<p style="color:rgb(34,34,34);font-size:12.8px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;text-align:justify"><span style="font-size:10pt"><span style="font-family:arial,helvetica,sans-serif"> </span></span></p>
<p style="color:rgb(34,34,34);font-size:12.8px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;text-align:justify"><span style="font-size:10pt"><span style="font-family:arial,helvetica,sans-serif">En cumplimiento de lo establecido por la LOPD 15/1999 le comunicamos que los datos personales contenidos en esta comunicación han sido recogidos de los contactos mantenidos por Ud. con personal de Xercode Media Software S.L. o de fuentes accesibles al público, y han sido incorporados a un fichero CLIENTES cuya finalidad es la de mantener con usted relaciones comerciales y/o profesionales.<br><br></span></span></p>
<p style="color:rgb(34,34,34);font-size:12.8px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;text-align:justify"> </p>
<div><span style="font-family:arial,helvetica,sans-serif"><span style="text-align:justify"><span style="font-size:10pt">Asimismo, podrá ejercitar sus derechos de acceso, rectificación, cancelación y oposición enviando un escrito a </span><span style="font-size:13.3333px">C/ Hedras, 4 2ºA</span><span style="font-size:10pt"> , 15895, Milladoiro -</span></span><span style="color:rgb(34,34,34);font-size:10pt;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;text-align:justify"> </span><span style="color:rgb(34,34,34);font-size:10pt;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;text-align:justify">Ames, A Coruña – Spain, junto con prueba válida en derecho, como fotocopia del D.N.I. e indicando en el asunto "PROTECCIÓN DE DATOS".</span><span style="font-size:12.8px"> </span></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div></div><div>--</div><div> </div></div>
<br>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a><br></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr">Kamal Hossain<div>Sr. Assistant Librarian</div><div>University of Liberal Arts Bangladesh (ULAB)</div><div>House 56, Road 4/A, Dhaka 1209</div><div>Bangladesh</div><div>Tel: 9661255, 9661301 (Ext. 203)</div><div>Fax: 9660610</div><div>Website:<a href="http://www.ulab.edu.bd" target="_blank">www.ulab.edu.bd</a></div><div><br></div></div></div></div></div>
</div></div>